| SQL |
SELECT DISTINCT subtyp2, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='CLOTHING AND FOOTWEAR' and typ='WOMENS' and subtyp1='Footwear' and upper(subtyp2)<>'EMPTY' and style_id IN (60,154,159,170,171,172,174,175,180,378,388,390,392,798,810,814,821,822,823,826,1556,1557,1559,1560,1634,1636,1802,1805,1806,1812,1813,1814,1816,1817,1825,1829,1830,1838,1842,1849,1850,1851,1865,1869,1870,1882,1883,1885,1886,1887,1888,1889,1893,1894,1895,1896,1898,1945,1950,1951,1952,1956,1978,1979,1987,1992,1994,1995,1998,2003,2006,2188,2195,2362,2441,2442,2443,2444,2445,2446,2849,2850,2855,2864,2866,3161,3258,3259,3260,3309,3310,3314,3315,3318,3320,3324,3326,3332,3338,3341,3343,3344,3345,3347,3352,3411,3452,3676,3690,4217,4316,4330,4353,4354,4356,4364,4373,4388,4960,4963,4964,4972,4980,4982,4991,4998,4999,5005,5019,5021,5022,5030,5034,5213,5280,5281,5306,5908,8142,8152,8154,8174,8178,8183,8186,8188,8192,8194,8196,8201,8202,8203,8204,8208,8210,8241,8242,8246,8253,8261,8262,8265,8266,8271,8272,8273,8274,8275,8276,8278,8279,8280,8283,8320,8327,8329,8807,8808,8810,8812,8816,8819,8823,8826,8830,8883,8891,8920,8938,8941,8952,8953,8954,8980,9032,9033,9034,9035,9039,9040,9050,9051,9054,9059,9071,9072,9074,9130,9259,9261,9263,9265,9266,9268,9499,9500,9506,9525,9780,9781,9782,9905,9907,9909,10236,10238,10243,10250,10433,10434,10435,10921,10930,10933,10934,11227,11288,11289,11290,11304,11348,11477,11529,11536,11537,11625,13949,14143,14200,14425,14426,14427,14528,14601,14755,14793,14794,14795,14819,14828,14829,14830,15055,15213,15214,15215,15216,15247,15249,803,1818,1819,1821,1822,1912,1913,1914,1916,1923,1924,1931,1933,2002,4048,8790,8969,8970,8986,8997,9131,9507)
GROUP BY subtyp2 |
Acorn
Wms Moc Slipper
Altra
Wms Paradigm 4
Altra
Wms Lone Peak 4 Low Rsm
Altra
Wms Paradigm 4.5
Altra
Wms Grafton
Altra
Wms Torin 4 Plush
Altra
Wms Lone Peak 4.5 Low
Altra
Wms Tokala 2 Slip- On
Altra
Wms Torin 4.5 Plush
Asolo
Wms Drifter Evo Gv
Astral
Wms Brewess 2.0
Astral
Wms Tr1 Junction
