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 > '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 | : Sat, June 3, 2023 16:08:51 |
IP | : 44.200.82.149 |
Browser | : CCBot/2.0 (https://commoncrawl.org/faq/) |
Script | : /khachsan/prices:over-3000.html |
Referer | : |
PHP Version | : 5.6.40 |
OS | : Linux |
Server | : Apache/2 |
Server Name | : resortkhachsan.com |