A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 17

SELECT ah_itqs.* , (SELECT short_value FROM ah_itqs_values WHERE record_id=ah_itqs.itq_id AND field_id="itq_no") AS itq_no , (SELECT short_value FROM ah_itqs_values WHERE record_id=ah_itqs.itq_id AND field_id="itq_category") AS itq_category , (SELECT long_value FROM ah_itqs_values WHERE record_id=ah_itqs.itq_id AND field_id="itq_description") AS itq_description , (SELECT short_value FROM ah_itqs_values WHERE record_id=ah_itqs.itq_id AND field_id="itq_siteshow") AS itq_siteshow , (SELECT long_value FROM ah_itqs_values WHERE record_id=ah_itqs.itq_id AND field_id="itq_siteshowdetails") AS itq_siteshowdetails , (SELECT short_value FROM ah_itqs_values WHERE record_id=ah_itqs.itq_id AND field_id="itq_closingdate") AS itq_closingdate , (SELECT short_value FROM ah_itqs_values WHERE record_id=ah_itqs.itq_id AND field_id="itq_closingtime") AS itq_closingtime , (SELECT short_value FROM ah_itqs_values WHERE record_id=ah_itqs.itq_id AND field_id="itq_cost") AS itq_cost , (SELECT short_value FROM ah_itqs_values WHERE record_id=ah_itqs.itq_id AND field_id="itq_doc1") AS itq_doc1 , (SELECT short_value FROM ah_itqs_values WHERE record_id=ah_itqs.itq_id AND field_id="itq_doc2") AS itq_doc2 , (SELECT short_value FROM ah_itqs_values WHERE record_id=ah_itqs.itq_id AND field_id="itq_cp") AS itq_cp , (SELECT short_value FROM ah_itqs_values WHERE record_id=ah_itqs.itq_id AND field_id="itq_remarks") AS itq_remarks , (SELECT short_value FROM ah_itqs_values WHERE record_id=ah_itqs.itq_id AND field_id="itq_status") AS itq_status FROM ah_itqs HAVING itq_id = LIMIT 1