| SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='MENS' and subtyp1='Footwear' and upper(subtyp2)<>'EMPTY' and style_id IN (56,150,160,164,165,166,167,168,173,177,374,376,387,389,391,788,791,793,804,809,825,843,846,849,851,856,1051,1052,1307,1330,1380,1561,1562,1563,1565,1626,1747,1749,1751,1827,1831,1840,1841,1845,1853,1854,1863,1874,1890,1891,1892,1902,1904,1905,1906,1944,1946,1953,1958,1959,1965,1975,1976,1996,1997,2007,2177,2196,2199,2214,2362,2696,2697,2851,2854,2858,2863,2865,3258,3259,3260,3327,3328,3331,3334,3336,3342,3346,3349,3350,3351,3354,3371,3410,3412,3675,3685,3686,3687,3689,3692,3879,4138,4218,4270,4276,4279,4303,4319,4320,4321,4334,4359,4362,4384,4387,4784,4785,4786,4788,4789,4798,4799,4803,4954,4956,4962,4964,4966,4970,4971,4973,4979,4981,4989,4990,4992,4993,4995,5002,5004,5018,5032,5033,5280,5281,5305,5306,5456,5745,5748,5762,8140,8145,8150,8151,8166,8176,8177,8185,8191,8195,8199,8200,8207,8209,8218,8249,8251,8252,8259,8260,8268,8269,8281,8282,8285,8318,8326,8328,8793,8795,8805,8806,8809,8811,8814,8849,8854,8884,8886,8916,8917,8918,8937,8951,8990,8993,9029,9042,9043,9047,9048,9049,9064,9065,9066,9067,9130,9259,9260,9264,9265,9266,9268,9560,9643,9832,9906,9908,9910,10232,10234,10235,10241,10242,10245,10246,10433,10434,10435,10922,10926,10931,10932,10935,11226,11228,11250,11291,11292,11293,11303,11305,11343,11475,11476,11626,11627,11628,14075,14141,14142,14199,14424,14523,14525,14526,14529,14602,14764,14796,14817,14818,14846,14847,14925,15043,15213,15214,15215,15216,15248,1615,1616,1907,1910,1920,1928,1929,1930,1935,3129,3337,4048,6324,6988,7109,7337,8981,8983,9131)
GROUP BY subtyp2 |
Acorn
Ellsworth Suede Moc Slipper
Altra
Cayd
Altra
Lone Peak 4 Low Rsm
Altra
Paradigm 4.5
Altra
Torin 4
Altra
Escalante 2
Altra
Tushar Boot
Altra
Grafton
Altra
Lone Peak 4.5 Low
Altra
Paradigm 5
Asolo
Fugitive Gtx
Asolo
Power Matic 200 Gv
