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