Fatal error: Uncaught Exception: Error: 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 '-10,10' at line 1<br />Error No: 1064<br />SELECT p.*, pk.*,IF(pk.currency='USD', pk.price*76, pk.price) as finalprice, r.region_name,cu.name as country_name,g.grade_name,pd.* FROM lt_product p JOIN lt_package pk ON (p.product_id = pk.product_id) LEFT JOIN lt_product_description pd ON (p.product_id = pd.product_id) RIGHT JOIN lt_region r ON(r.region_id = pk.region_id) RIGHT JOIN lt_country cu ON(cu.country_id = r.country_id) RIGHT JOIN lt_grade g ON(g.grade_id = pk.grade_id) WHERE p.model = 'package' and pk.tourtype='Tour Package' and p.status = '1' AND(r.region_name = 'Thoddoo Island') ORDER BY pk.product_id DESC LIMIT -10,10 in /home/gleesire/public_html/system/library/db/mysqli.php:40
Stack trace:
#0 /home/gleesire/public_html/system/library/db.php(16): DB\MySQLi->query('SELECT p.*, pk....', Array)
#1 /home/gleesire/public_html/catalog/model/cata in /home/gleesire/public_html/system/library/db/mysqli.php on line 40