SQL Query ¿¡·¯ÀÔ´Ï´Ù.
Function Name  query
Error  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 '%20wdate%20desc%20 limit 0, 24' at line 8
Error Number  1064
SQL  select a.*, (select count(id) as total from site_shop_order_brand where brandcode = a.brandcode) as order_cnt from site_brand a where 1 and status != '2' and ( left(brandcode,3) != '061' ) and brandcode LIKE '060003%' and ( left(brandcode,6) != '014017' and left(brandcode,6) != '014016' and left(brandcode,6) != '014020' and left(brandcode,6) != '014015' and left(brandcode,9) != '014014001' and left(brandcode,3) != '014' and left(brandcode,6) != '014014' and left(brandcode,6) != '014018' and left(brandcode,9) != '063002003' and left(brandcode,6) != '014019' and left(brandcode,6) != '014021' and left(brandcode,6) != '066001' and left(brandcode,6) != '014022' and left(brandcode,3) != '068' and left(brandcode,3) != '014' ) and (FIND_IN_SET ('p4673', not_cate_id ) = 0 or FIND_IN_SET ('p4673', not_cate_id ) is null) and (FIND_IN_SET (2, etc_result) = 0 or FIND_IN_SET (3, etc_result) != 0) and (pay_goods_use = 1 ) and new_icon=1 order by %20wdate%20desc%20 limit 0, 24
Gboy MySQL Class Ver 2.0.1  ±âŸ ¹®ÀÇ »çÇ×Àº gboy0713@yahoo.co.kr ·Î ¿¬¶ô¹Ù¶ø´Ï´Ù.