xxx
select count(*) as cnt
from ( //括号里写你原来的语句
select ...
from ...
where ...
group by season,sex,type,year,itemid,itemname,size,color,unit,price,image
) as t
xxx
select count(*) as cnt
from ( //括号里写你原来的语句
select ...
from ...
where ...
group by season,sex,type,year,itemid,itemname,size,color,unit,price,image
) as t