| SQL |
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount
FROM web_all_products
WHERE dept='PADDLESPORTS' and typ='ACCESSORIES' and upper(subtyp1)<>'EMPTY' and style_id IN (22,23,29,30,31,33,34,38,383,384,386,394,396,397,477,500,956,957,1431,1454,1479,1488,1504,1530,1534,1536,1645,1663,1664,1665,1668,1672,1673,1675,1677,1678,1679,1689,1690,1693,1702,1706,1707,1708,1709,1710,1711,1715,1720,1723,1724,1728,1729,1733,1735,1739,1740,1743,2832,4078,4494,4495,4496,4497,4498,4500,4501,4502,4503,4505,4506,4507,4508,4509,4510,4511,4512,4514,4515,4516,4828,4830,4831,4834,4835,4855,4856,5117,5118,5119,5120,5121,8345,8396,8405,8410,8417,8440,8444,8445,8446,8447,8452,8463,8466,8471,8473,8475,8476,9185,9186,9187,9188,9189,9190,9191,9192,9193,9194,9195,9196,9197,9200,9201,9202,9204,9205,9273,9276,9318,9319,9321,9329,9332,10995,10998,11002,11004,11008,11009,11090,11098,11099,11100,11101,11106,11107,11110,11111,11112,11113,11118,11121,11122,11125,11126,11127,11128,11129,11130,11131,11132,11133,11134,11135,11136,11137,11138,11139,11149,11151,13897,14268,14754,14802,14803,14804,14805,15019,15025,15026,15132,15133,15272,15273,15274,32,36,1503,1505,1531,1662,1699,1705,1721,1727,2831,3278,4035,4063,5789,5790,5791,8363,8457,8458,8460,8479,9183,9184,9285,9320,9322,9323,9325,9326,9327,9328,9330,9333,9335,9336,9339,11092,11093,11103,11109,11115,11119,11120,11145,11146,11147,11148,11150,11357,11460)
GROUP BY subtyp1 |
ACCENT PADDLES
Infinity Hybrid Paddle
ACCENT PADDLES
Advantage Hybrid Sup Paddle
ACCENT PADDLES
Energy Hybrid Paddle
ACCENT PADDLES
Energy Carbon Paddle
ACCENT PADDLES
Wahoo Kids Kayak Paddle
ACCENT PADDLES
Advantage 720 Sup Paddle
ACCENT PADDLES
Advantage 780 Sup Paddle
ACCENT PADDLES
Advantage Carbon Adj Paddle
Astral
Wms Layla Pfd
Astral
Ytv Pfd
Astral
Ringo Pfd
Astral
Abba Pfd
