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.addi_latitude != 0 AND addi.addi_longitude != 0 AND addi.aff_st' at line 8

SELECT ht_name,ht_name,ht_addr,'' as IMAGEPATH,url_en ,ht_rating,dir,addi_latitude,addi_longitude,ht_big_img,ht_stprice,ht_score,ht_weight,addi_cate_type ,SUBSTRING_INDEX(GROUP_CONCAT('https://www.chuwab.com/images/hotel/',dir,'/',pa_imgb), ',', 5) as photogal FROM tbl_hotel hotel JOIN tbl_hotel_addi addi ON addi.addi_id = hotel.addi_id JOIN tbl_album_photo photo ON addi.addi_id = photo.addi_id WHERE hotel.loca_id = AND addi.addi_latitude != 0 AND addi.addi_longitude != 0 AND addi.aff_status = 1 AND addi.ht_status = 1 AND (addi.expire_date > '1711715657' OR addi.sel_data != 'TT') GROUP BY addi.addi_id ORDER BY ht_weight DESC LIMIT 0,100