로고
HOME LOGIN KOREA ENGLISH
COMPANY PRODUCT SERVICE COMMUNITY
[겸호필] [고급필] [황모필] [동양화필] [사군자] [세필] [액자필] [양모필] [특수필]
### [CurrentTime] : 2022/12/07 15:53:03
### [Page] : /product/index.html
### [RefPage] :
### [RefClass] : DB_CLASS Execute
### [ErrMsg] : 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 7
### [ErrMsg] : 1064
### [ErrMsg] :
SELECT
GID, CATENO, (SELECT COMPNAME FROM GOODS_MAKER WHERE COMPNO=G.GMAKECOM) COMPNAME, GNAME, SPECNAME, SPECVALUE, SALE_PR, PRICE, TOTEA, GPOINT, GRECOM, GHIT, GLOW, GSALE, GNEW, GMAKEDATE, GPOINT, SPECNAME, SPECVALUE, GTITLE
FROM GOODS1 G
WHERE TOTEA>0 AND CATENO='010105'

ORDER BY GNAME ASC
LIMIT -10, 10