SQL | select * from site_brand where grp_id = 'gboy' and status != '2' and ( left(brandcode,3) != '008' and left(brandcode,3) != '009' and left(brandcode,3) != '010' and left(brandcode,3) != '011' and left(brandcode,3) != '014' and left(brandcode,6) != '008003' and left(brandcode,6) != '014005' and left(brandcode,6) != '008005' and left(brandcode,6) != '010004' and left(brandcode,6) != '014015' and left(brandcode,6) != '014022' and left(brandcode,6) != '014023' ) and brandcode LIKE '021004001%' order by wdate%20asc limit 0, 40 |