SELECT t1.RCT_NO, t1.PQTY FROM `RctInventory` as t1 LEFT JOIN `Cattype` as t7 on (t1.CATTYPE=t7.CATTYPE) WHERE t1.PQTY > 0 AND t1.IS_GARMENT = '0' AND t1.IS_INTERNAL = '0' AND t7.PUBLIC_VIEW = 'YES' AND t1.`CATTYPE` = 'SH145' ORDER BY t1.PQTY DESC limit -24,24;
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 '-24,24' at line 12