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 (374,825,1562,1563,1565,1965,1975,1976,1997,2696,3346,3349,3354,4218,4387,4954,4956,4962,4970,4973,4989,4990,4992,4993,4995,5002,5004,6502,7437,8140,8150,8166,8251,9784,10254,11293,11626,14072,14075,14076,14648,15105,15316,15424,15425,15447,15448,15450,15503,15518,16510,16580,16582,16725,16726,16858,16932,16934,16935,16957,16962,17003,17032,17612,17646,17820,17859,18430,18510,18655,18901,19066,19067,19073,19125,19207,19208,19230,19383,19612,19750,19884,19992,20000,20004,20006,20089,20212,20597,20603,20752,20971,20992,21001,21393,21394,21607,21713)
GROUP BY subtyp1 |