| 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 (51,54,55,60,154,170,171,174,175,180,378,388,390,798,799,803,810,814,815,824,826,1556,1560,1805,1813,1814,1816,1817,1818,1821,1822,1825,1829,1830,1838,1842,1849,1850,1851,1870,1884,1885,1886,1887,1888,1889,1894,1895,1916,1923,1924,1934,1942,1951,1952,1956,1987,1992,1994,1995,1998,2002,2003,2006,2195,2362,2441,2442,2443,2444,2445,2446,2850,2855,2866,3258,3259,3260,3309,3310,3315,3318,3324,3326,3338,3343,3344,3345,3347,3352,3411,3676,3690,4048,4217,4316,4330,4356,4783,4960,4963,4964,4972,4980,4991,4998,5005,5019,5021,5022,5026,5034,5280,5281,5306,5908,8152,8192,8196,8203,8208,8210,8241,8242,8266,8271,8272,8274,8275,8276,8278,8279,8283,8327,8329,8807,8808,8816,8826,8861,8952,8986,9034,9039,9040,9071,9074,9130,9131,9259,9261,9263,9265,9266,9268,9499,9500,9782,9783,9905,9907,9909,10236,10243,10250,10433,10434,10933,10934,11227,11288,11289,11290,11348,11477,11529,11536,11537,11625,13923,13949,14074,14143,14200,14204,14206,14425,14426,14427,14571,14648,14722,14725,14726,14728,14729,14730,14755,14793,14794,14795,14819,14829,15055,15090,15194,15198,15199,15215,15247,15249,15375,15408,15426,15428,15430,15431,15432,15434,15446,15502,15637,15639,15656,15657,15704,15729,15734,15735,15736,15762,15763,15764,15765,15881,15913,16119,8790)
GROUP BY subtyp2 |
Acorn
Wms Nordic Moc Slipper
Acorn
Wms Fairisle Hoodback Slipper
Acorn
Wms Camden Recycled Clog
Acorn
Wms Moc Slipper
Altra
Wms Paradigm 4
Altra
Wms Paradigm 4.5
Altra
Wms Grafton
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
