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