| 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 (3,12,359,374,421,429,435,696,756,764,784,788,793,804,825,856,918,930,946,947,950,953,1561,1562,1563,1565,1578,1579,1580,1581,1585,1753,1754,1827,1831,1832,1840,1859,1890,1892,1903,1904,1905,1906,1907,1909,1928,1936,1944,1946,1947,1965,1975,1976,1996,1997,2124,2136,2137,2138,2141,2145,2146,2147,2148,2156,2162,2182,2196,2205,2221,2222,2223,2232,2235,2240,2362,2696,2697,2777,2790,2791,2821,2829,2915,2922,2945,2977,3001,3073,3088,3092,3094,3095,3098,3104,3246,3258,3260,3327,3331,3346,3349,3351,3354,3379,3406,3407,3408,3496,3497,3515,3529,3549,3550,3589,3599,3604,3620,3623,3625,3637,3638,3641,3664,3666,3669,3675,3685,3686,3687,3689,3692,3797,4218,4279,4291,4387,4788,4789,4798,4799,4803,4846,4847,4854,4898,4918,4936,4938,4954,4956,4962,4964,4970,4973,4989,4990,4992,4993,4995,5002,5004,5221,5225,5235,5236,5249,5269,5270,5279,5298,5299,5300,5301,5302,5304,5309,5313,5316,5324,5330,5337,5339,5346,5360,5362,5364,5405,5438,5449,5451,5454,5471,5479,5550,5551,5552,5553,5643,5644,5645,5652,5653,5662,5671,5696,5697,5706,5718,5719,5722,5731,5744,5752,5753,5763,5772,5851,5864,5865,5868,5874,5875,5876,5882,5884,5900,6062,6176,6357,6502,7014,7437,8011,8075,8140,8150,8151,8166,8251,8318,8326,8328,8560,8623,8639,8664,8802,8814,8820,8854,8867,8904,8919,9021,9022,9045,9046,9060,9063,9069,9130,9145,9149,9260,9264,9265,9266,9268,9377,9392,9399,9400,9460,9518,9544,9575,9598,9626,9784,9837,9849,9915,10254,10281,10286,10334,10338,10433,10434,10435,10501,10608,10631,10687,10718,10720,10729,10736,10760,10788,10841,10856,10874,10877,10926,11291,11293,11316,11318,11319,11321,11362,11376,11475,11557,11578,11589,11592,11626,11627,13911,13959,13961,14072,14075,14076,14099,14101,14124,14140,14255,14256,14281,14282,14283,14287,14374,14382,14489,14619,14620,14648,14674,14677,14678,14683,14684,14692,14727,14731,14732,14734,14737,14738,14782,14806,14818,14836,14839,14842,14846,14962,15105,15135,15196,15197,15213,15316,15376,15424,15425,15447,15448,15450,15496,15499,15503,15512,15514,15515,15518,15539,15557,15558,15559,15560,15561,15635,15638,15641,15642,15643,15696,15698,15732,15743,15744,15745,15746,15747,15748,15749,15793,15844,15852,15912,15914,15945,15958,16013,16015,16017,16019,16021,16022,16112,16120,16121,16122,16125,16148,16157,16169,16170,16215,16216,16219,16221,16248,16353,16354,16418,16420,16422,16423,16510,16511,16512,16580,16582,16607,16655,16670,16671,16672,16675,16676,16677,16685,16725,16726,16728,16768,16786,16787,16802,16804,16813,16822,16827,16832,16845,16846,16858,16860,16865,16867,16932,16934,16935,16949,16951,16957,16959,16962,16963,16993,16995,16996,17003,17032,17170,17174,17194,17199,17218,17348,17349,17391,17399,17484,17486,17488,17490,17592,17610,17612,17646,17648,17680,17702,17709,17710,17713,17719,17720,17806,17808,17811,17820,17859,17926,17927,17934,17935,17971,17972,17975,18002,18016,18037,18041,18042,18047,18132,18137,18138,18141,18153,18154,18155,18177,18188,18190,18192,18227,18228,18234,18236,18239,18250,18279,18282,18283,18286,18295,18336,18346,18378,18380,18381,18423,18430,18466,18496,18497,18498,18509,18510,18522,18535,18539,18540,18573,18655,18669,18672,18673,18709,18740,18741,18774,18803,18809,18811,18845,18901,18924,18928,18931,18935,18947,18951,18954,18955,18974,18975,18978,18980,19041,19057,19066,19067,19069,19071,19073,19079,19082,19105,19124,19125,19139,19157,19184,19185,19192,19198,19200,19207,19208,19230,19253,19254,19255,19260,19262,19264,19266,19267,19268,19269,19273,19277,19279,19280,19282,19309,19349,19353,19354,19355,19383,19411,19412,19492,19497,19515,19516,19517,19518,19577,19589,19612,19731,19750,19841,19860,19861,19875,19879,19882,19884,19931,19951,19954,19992,19998,20000,20001,20004,20006,20029,20049,20052,20053,20054,20078,20089,20090,20134,20156,20179,20185,20186,20188,20210,20212,20221,20261,20262,20267,20268,20292,20293,20294,20296,20298,20299,20321,20326,20327,20328,20329,20330,20335,20339,20342,20373,20374,20376,20378,20382,20385,20403,20409,20417,20418,20465,20475,20495,20498,20503,20522,20567,20568,20593,20596,20597,20601,20603,20635,20636,20691,20694,20695,20696,20735,20752,20760,20843,20857,20878,20879,20880,20881,20882,20883,20902,20913,20934,20971,20976,20977,20978,20979,20980,20983,20992,21001,21020,21021,21061,21067,21069,21071,21075,21076,21078,21079,21080,21082,21084,21243,21244,21245,21246,21247,21248,21249,21250,21251,21252,21253,21254,21255,21256,21257,21258,21260,21261,21267,21268,21270,21274,21275,21287,21289,21290,21291,21367,21369,21371,21372,21373,21374,21375,21376,21377,21378,21379,21380,21381,21382,21383,21385,21386,21387,21388,21391,21392,21393,21394,21451,21569,21570,21573,21574,21575,21577,21579,21580,21583,21584,21586,21587,21589,21593,21607,21608,21634,21647,21713,21715,21741,21825,21842,21843,21871,21872,21874,21879,952,1615,1616,1918,8912,9355,10875,11356,19629)
GROUP BY subtyp1 |
