[class] /var/jfmall/inc/dbconn.php
[excute]
질의가 ?패???니??
select
TG.idx,
TG.sid,
TG.code,
TG.name_ko as name,
TG.cprice_ko as cprice,
(CASE WHEN TGP.price>0 THEN TGP.price ELSE TG.price_ko END) as price,
TG.inprice_ko as inprice,
TG.opt_div,
TG.thumbnail1,
TG.product_class
from t_goods as TG LEFT JOIN (select * from t_goods_price where uid='') as TGP ON TG.idx=TGP.gidx
where status in (1,2) and new>0 order status asc, by name_ko asc limit 0, 20
1064 : 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 'status asc, by name_ko asc limit 0, 20' at line 18
