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_tenders.* , (SELECT short_value FROM ah_tenderss_values WHERE record_id=ah_tenders.tender_id AND field_id="tender_no") AS tender_no , (SELECT long_value FROM ah_tenderss_values WHERE record_id=ah_tenders.tender_id AND field_id="tender_description") AS tender_description , (SELECT short_value FROM ah_tenderss_values WHERE record_id=ah_tenders.tender_id AND field_id="tender_siteshow") AS tender_siteshow , (SELECT long_value FROM ah_tenderss_values WHERE record_id=ah_tenders.tender_id AND field_id="tender_siteshowdetails") AS tender_siteshowdetails , (SELECT short_value FROM ah_tenderss_values WHERE record_id=ah_tenders.tender_id AND field_id="tender_closingdate") AS tender_closingdate , (SELECT short_value FROM ah_tenderss_values WHERE record_id=ah_tenders.tender_id AND field_id="tender_closingtime") AS tender_closingtime , (SELECT short_value FROM ah_tenderss_values WHERE record_id=ah_tenders.tender_id AND field_id="tender_box") AS tender_box , (SELECT short_value FROM ah_tenderss_values WHERE record_id=ah_tenders.tender_id AND field_id="tender_cost") AS tender_cost , (SELECT short_value FROM ah_tenderss_values WHERE record_id=ah_tenders.tender_id AND field_id="tender_doc1") AS tender_doc1 , (SELECT short_value FROM ah_tenderss_values WHERE record_id=ah_tenders.tender_id AND field_id="tender_doc2") AS tender_doc2 , (SELECT short_value FROM ah_tenderss_values WHERE record_id=ah_tenders.tender_id AND field_id="tender_cp") AS tender_cp , (SELECT short_value FROM ah_tenderss_values WHERE record_id=ah_tenders.tender_id AND field_id="tender_remarks") AS tender_remarks , (SELECT short_value FROM ah_tenderss_values WHERE record_id=ah_tenders.tender_id AND field_id="tender_status") AS tender_status FROM ah_tenders HAVING tender_id = LIMIT 1