SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='MENS' and upper(subtyp1)<>'EMPTY' and style_id IN (1562,1563,1965,1975,1976,1996,1997,3327,3346,3349,3351,3354,4218,4962,4970,4973,4989,4990,4992,4993,5004,9784,11291,11293,11626,14072,14075,14076,15447,15448,15503,15696,16582,16725,16726,16858,16865,16932,16935,16957,16993,16995,17391,17610,17820,18510,18539,18901,19041,19057,19066,19073,19124,19383,19577,19612,19884,19998,20000,20001,20004,20006,20210,20212,20503,20603,20971,20992,21001,21393,21394,21608,21713)
GROUP BY subtyp1 |