A Database Error Occurred

Error Number: 1064

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 '-12, 12' at line 1

SELECT * from shop_product x,shop_stock y where 1=1 and x.Status='1' and y.Status='1' and x.ProductID=y.ProductID and UNIX_TIMESTAMP(y.`PromotionEndDate`)>=UNIX_TIMESTAMP(DATE_FORMAT(now(),'%Y-%m-%d 00:00:00')) and UNIX_TIMESTAMP(DATE_FORMAT(now(),'%Y-%m-%d 00:00:00'))>=UNIX_TIMESTAMP(y.`PromotionStartDate`) and UNIX_TIMESTAMP(y.`PromotionEndDate`)>=UNIX_TIMESTAMP(y.`PromotionStartDate`) and y.Promotion='1' group by y.ProductID order by x.ProductID desc LIMIT -12, 12

Filename: models/General.php

Line Number: 180