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 (764,825,856,2136,2138,2145,2696,2697,2791,3327,3331,3351,3641,3675,3685,3687,4938,4970,5643,5644,5719,5752,5851,7437,8140,8150,8166,8326,8664,10334,10338,10501,10631,10687,10926,11362,11627,14075,14076,14782,14806,15376,15424,15425,15499,15514,15515,15852,16726,16858,16860,16865,16867,16932,16957,16993,16996,17003,17391,17648,17702,17709,17710,17713,17934,18286,18430,18573,19041,19066,19067,19230,19255,19383,19577,19884,19992,20000,20001,20004,20006,20029,20049,20089,20321,20385,20417,20418,20475,20503,20567,20601,20971,20992,21252,21393,21394,21583,21713)
GROUP BY subtyp1 |