SQL | select * from nareshop.payshop_brand_total where ( grp_id = 'pay_biz' or grp_id = 'pay_biz' ) and left(brandcode,3) = '004' and ( status = '1' or status = '3' ) and ( left(category, 3) = '' or left(category1, 3) = '' or left(category2, 3) = '' or left(category3, 3) = '' or left(category4, 3) = '' or left(category5, 3) = '' or left(category6, 3) = '' or left(category7, 3) = '' or left(category8, 3) = '' or left(category9, 3) = '' ) and (sellprice != '' and sellprice is not null) order by wdate%20%20desc limit 0, 20 |