SELECT DISTINCTROW `mantis_bug_table` . * FROM `mantis_bug_table` JOIN `mantis_project_table` ON `mantis_project_table` . `id` = `mantis_bug_table` . `project_id` LEFT JOIN `mantis_bugnote_table` `visible_bugnote` ON `mantis_bug_table` . `id` = `visible_bugnote` . `bug_id` JOIN `mantis_bug_text_table` ON `mantis_bug_table` . `bug_text_id` = `mantis_bug_text_table` . `id` LEFT JOIN `mantis_bugnote_text_table` ON `visible_bugnote` . `bugnote_text_id` = `mantis_bugnote_text_table` . `id` WHERE `mantis_project_table` . `enabled` = ? AND ( `mantis_bug_table` . `project_id` = ? ) AND ( `mantis_bug_table` . `handler_id` = ? AND ( ( `mantis_bug_table` . `summary` LIKE ? OR `mantis_bug_text_table` . `description` LIKE ? OR `mantis_bug_text_table` . `steps_to_reproduce` LIKE ? OR `mantis_bug_text_table` . `additional_information` LIKE ? OR `mantis_bugnote_text_table` . `note` LIKE ? ) ) ) ORDER BY `mantis_bug_table` . `sticky` DESC , `mantis_bug_table` . `last_updated` DESC , `mantis_bug_table` . `date_submitted` DESC LIMIT ?, ... 