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 h.lang_id = 4 AND r.r_person_max >= AND ( ( BETWEEN s.seas' at line 11
SELECT h.addi_id, h.ht_id, h.ht_name, h.urlh_name, h.ht_addr, h.ht_teaser, MIN(rp.rp_price) price,ar.ar_name, pr.pv_name,pr.country_id,a.zip_code,dir, MAX((rp.rp_cost * 100) / rp.rp_price) margin,a.ht_rating FROM tbl_hotel h JOIN tbl_hotel_addi a ON a.addi_id = h.addi_id JOIN aff_seasons s ON s.addi_id = h.addi_id JOIN aff_room_price rp ON rp.season_id = s.season_id JOIN aff_room r ON r.r_id = rp.r_id JOIN tbl_area ar ON ar.ar_id = h.ar_id JOIN tbl_province pr ON pr.pv_id = h.pv_id WHERE h.loca_id = AND h.lang_id = 4 AND r.r_person_max >= AND ( ( BETWEEN s.season_date_start and s.season_date_end) OR ( BETWEEN s.season_date_start and s.season_date_end) ) AND a.aff_status = 1 GROUP BY h.addi_id, h.ht_name, h.ht_addr, h.urlh_name, h.ht_teaser ORDER BY h.ht_name ASC LIMIT 0,15
Filename: /home/choowap/public_html/m/models/search_model.php
Line Number: 32