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