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