SELECT COUNT ( DISTINCTROW `mantis_bug_table` . `id` ) FROM `mantis_bug_table` JOIN `mantis_project_table` ON `mantis_project_table` . `id` = `mantis_bug_table` . `project_id` LEFT JOIN `mantis_category_table` ON `mantis_bug_table` . `category_id` = `mantis_category_table` . `id` WHERE `mantis_project_table` . `enabled` = ? AND ( `mantis_bug_table` . `project_id` = ? ) AND ( `mantis_bug_table` . `resolution` = ? ) 