Select CT.CTNAME, CT.CTPOSE, CTSG.CTNO, SG.SALEGDNO, SG.GDNO, SG.GNAME, SG.GTYPE, SG.SET_TYPE, SG.BOOK_Y, SG.POST_Y, SG.GOODSQNA_Y, SG.AFTERPAY_Y, SG.SALECNT_Y, SG.SALECNT, SG.UNITSALE, SG.PRICE_P, Format( SG.PRICE_P, 0 ) AS PRICE_P_F, SG.PRICE_R, Format( SG.PRICE_R, 0 ) AS PRICE_R_F, SG.RATE_DCNT, SG.RATE_TRANS, SG.RATE_MILE, SG.RATE_POINT, SG.ATTRI, SG.REGDATE AS SREGDATE, SG.GREGDATE, SG.REGDTIME, SG.PICS_NAME, SG.PICS_WIDTH, SG.PICS_HEIGHT, SG.SPEC, SG.KEYWORD, SG.TITLE, SG.ORIGIN, SG.BRAND, SG.MAKER, SG.PGSYS, NOW() < Date_add( SG.REGDTIME, interval 12 Hour ) AS ICON_NEW, 60 <= SG.VIEWCNT AS ICON_COOL, 30 <= SG.SALEDCNT AS ICON_HOT From ta_salegoods AS SG LEFT JOIN ta_cate_salegoods AS CTSG ON SG.SALEGDNO = CTSG.SALEGDNO LEFT JOIN ta_cate AS CT ON CTSG.CTNO = CT.CTNO LEFT JOIN ta_cate_set AS CTST ON CT.CTNO = CTST.CTNO Where SG.GOODS_HIDDEN<>'Y' AND SG.SALEGDNO BETWEEN '257' AND '335' AND CT.CTNO <> '' AND CT.CTPOSE LIKE 'AAR%' Group By SG.SALEGDNO Order by SG.SALEGDNO DESC Limit -200, 20
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-200, 20' at line 22