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 '204' AND '440'
AND CT.CTNO <> '' AND CT.CTPOSE LIKE 'AAI%'
Group By SG.SALEGDNO
Order by SG.MAKER ASC
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