ERROR: FAILED QUERY: SELECT DISTINCT( mantis_bug_table.id ) as count FROM mantis_bug_table, mantis_bug_text_table LEFT JOIN mantis_bugnote_table ON mantis_bugnote_table.bug_id = mantis_bug_table.id LEFT JOIN mantis_bugnote_text_table ON mantis_bugnote_text_table.id = mantis_bugnote_table.bugnote_text_id WHERE project_id='0000001' AND (view_state='10' OR (view_state='50' AND reporter_id='0002974')) AND status<>'90' AND ((summary LIKE '%quot%') OR (description LIKE '%quot%') OR (steps_to_reproduce LIKE '%quot%') OR (additional_information LIKE '%quot%') OR (mantis_bug_table.id LIKE '%quot%') OR (mantis_bugnote_text_table.note LIKE '%quot%')) AND mantis_bug_text_table.id = mantis_bug_table.bug_text_id :

1052: Column: 'view_state' in where clause is ambiguous