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 '%16%' ) AND p.price BETWEEN '2000000' and '2500000' 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: Sat, December 5, 2020 02:37:07
IP: 18.234.255.5
Browser: CCBot/2.0 (https://commoncrawl.org/faq/)
Script: /khachsan/prices:2000-2500/services:16.html
Referer:
PHP Version : 5.6.40
OS: Linux
Server: Apache/2
Server Name: resortkhachsan.com