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