Every A$ purchase gives you gifts!
Invalid query 1220bx4: select count(*) from (
select infomostpopular3.*
, if (length(ttt.id) > 0, ttt.grp, ttt2.grp) as grp
, if (length(ttt.id) > 0, ttt.name, ttt2.name) as name
FROM infomostpopular3
left join product as ttt on infomostpopular3.productid = ttt.id
left join productnew as ttt2 on infomostpopular3.productid = ttt2.id
where
not (productid between 3000 and 3010)
and not (productid between 7100 and 7199)
and not (productid >= 20000)
and not (productid = 8000) and
( (productid between 2000 and 2999) or (productid between 4800 and 4899) or (productid>=18000 and productid<18899)
or (productid between 5000 and 5599) or (productid between 4000 and 4099) or (productid between 4200 and 4299)
or (productid between 4400 and 4499) or (productid between 4600 and 4699)
or (productid between 7000 and 7099)
or (productid between 10 and 999)
or (productid between 1000 and 1999)
or (productid between 6800 and 6899)
or (productid between 6000 and 6499)
)
) as t0
where 1