Query Error
Notice: Undefined variable: templatefolder in /home/resortks/domains/resortkhachsan.com/public_html/libraries/database/mysql.php on line 249
SQL SYNTAX ERROR
Query SQL: SELECT h.id AS id, h.name AS name, h.stars AS stars, h.address AS address, h.city_id AS city_id, h.district_id AS district_id, h.summary AS summary, h.hotel_utilities AS hotel_utilities, h.alias AS alias, h.category_alias AS category_alias, h.image AS image, h.comments_total AS comments_total FROM fs_hotels AS h WHERE h.published = 1 AND h.name like '%%' AND p.price BETWEEN '1000000' and '1500000' GROUP BY h.id ORDER BY h.ordering DESC, h.created_time DESC, h.id DESC LIMIT 0,10
Error Number: 1054 Unknown column 'p.price' in 'where clause'
Date: Tue, March 19, 2024 10:03:39
IP: 34.228.7.237
Browser: claudebot
Script: /khachsan/prices:1000-1500.html
Referer:
PHP Version : 5.6.40
OS: Linux
Server: Apache/2
Server Name: resortkhachsan.com