SQL | select * from dressup_brand where 1 and status != '4' and ( left(brandcode,3) != '044' or left(brandcode,6) != '002' or left(brandcode,3) != '044' or left(brandcode,6) != '004' or left(brandcode,3) != '044' or left(brandcode,6) != '003' or left(brandcode,3) != '044' or left(brandcode,6) != '001' or left(brandcode,3) != '016' or left(brandcode,6) != '001' or left(brandcode,9) != '002' or left(brandcode,3) != '049' or left(brandcode,6) != '002' or left(brandcode,9) != '002' or left(brandcode,3) != '049' or left(brandcode,6) != '002' or left(brandcode,9) != '001' or left(brandcode,3) != '044' or left(brandcode,3) != '049' or left(brandcode,3) != '049' or left(brandcode,6) != '002' or left(brandcode,3) != '049' or left(brandcode,6) != '003' or left(brandcode,3) != '049' or left(brandcode,6) != '005' ) and brandcode LIKE '014007%' and brandname != 'gboy_test' order by company%20asc limit 0, 24 |