SELECT * FROM `mantis_bug_history_table` WHERE `mantis_bug_history_table` . `bug_id` IN ( SELECT `mantis_bug_table` . `id` FROM `mantis_bug_table` JOIN `mantis_project_table` ON `mantis_project_table` . `id` = `mantis_bug_table` . `project_id` WHERE `mantis_project_table` . `enabled` = ? AND ( `mantis_bug_table` . `project_id` = ? ) ) AND `mantis_bug_history_table` . `date_modified` >= ? AND `mantis_bug_history_table` . `date_modified` < ? ORDER BY `mantis_bug_history_table` . `date_modified` DESC , `mantis_bug_history_table` . `id` DESC 