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 'AND addi.aff_status = 1 AND addi.ht_status = 1 AND cat.lang_id = 1 ' at line 7

SELECT cat.term,(cat.url_en)as url,cat.term_category_id,count(cat.term_category_id) as num_cat FROM tbl_term_relationship rel JOIN tbl_hotel_addi addi ON addi.addi_id = rel.object_id JOIN tbl_term_category cat ON cat.term_category_id = rel.term_category_id JOIN tbl_hotel hotel ON addi.addi_id = hotel.addi_id AND hotel.lang_id = 1 WHERE hotel.loca_id = AND addi.aff_status = 1 AND addi.ht_status = 1 AND cat.lang_id = 1 AND cat.category = 'tag' AND (addi.expire_date > 1710481139 OR addi.sel_price != 'TT') GROUP BY cat.term_category_id