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 ( h.hotel_utilities like '%37%' ) AND p.price BETWEEN '2500000' and '3000000' 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, October 19, 2021 06:57:23
IP: 35.173.35.159
Browser: CCBot/2.0 (https://commoncrawl.org/faq/)
Script: /khachsan/prices:2500-3000/services:37.html
Referer:
PHP Version : 5.6.40
OS: Linux
Server: Apache/2
Server Name: resortkhachsan.com