
$24.99
struct | |
---|---|
ACTION | [empty string] |
BRAND | [empty string] |
CHOOSEADDRESS | [empty string] |
CONFIRM | NO |
CURRENTPAGE | 1 |
Color | [empty string] |
DEPT | Clothing and Footwear |
GOTO | [empty string] |
KEYWORD | [empty string] |
NAV_CHOOSER | home |
NEW | [empty string] |
ORDER | [empty string] |
ORDERBY | [empty string] |
PAGE | 1 |
PAYMETHOD | CC |
PERPAGE | [empty string] |
PPSUCCESS | NO |
PRICE | [empty string] |
RATE | [empty string] |
RECEIPT_NUM | [empty string] |
RETURNTO | [empty string] |
RETURN_TO_PAGE | [empty string] |
SALE | [empty string] |
SAVEDCART | NO |
SHIPPING | [empty string] |
SHOP | clothing_and_footwear-mens |
SUBTYP_1 | EMPTY |
SUBTYP_2 | EMPTY |
SUBTYP_3 | EMPTY |
Size | [empty string] |
TITLE | [empty string] |
TYP | Men's |
WEB_TAXONOMY_ID | 673 |
mapping | /clothing_and_footwear-mens |
waterproof | [empty string] |
query | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RESULTSET |
|
|||||||||||||||||||||||||||
CACHED | false | |||||||||||||||||||||||||||
EXECUTIONTIME | 3 | |||||||||||||||||||||||||||
SQL | SELECT subtyp_1, web_url FROM tb_web_taxonomy WHERE dept='CLOTHING AND FOOTWEAR' and typ='MEN''S' and subtyp_1>'' and subtyp_2='EMPTY' and subtyp_1<>'EMPTY' ORDER BY sort_position |
query | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RESULTSET |
|
|||||||||||||||||||||||||||
CACHED | false | |||||||||||||||||||||||||||
EXECUTIONTIME | 25 | |||||||||||||||||||||||||||
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,56,354,359,374,376,391,421,429,430,435,685,688,696,734,756,788,791,793,804,825,856,918,930,941,946,950,953,1305,1561,1562,1563,1565,1572,1578,1580,1581,1585,1827,1831,1832,1840,1853,1854,1859,1863,1890,1892,1903,1904,1905,1906,1907,1909,1928,1930,1936,1944,1946,1947,1965,1975,1976,1996,1997,2007,2124,2136,2137,2138,2141,2145,2146,2147,2149,2156,2162,2174,2182,2196,2205,2211,2214,2217,2219,2221,2222,2223,2232,2235,2240,2342,2362,2696,2697,2781,2787,2810,2821,2823,2829,2915,2960,2977,3001,3073,3092,3094,3095,3098,3104,3245,3258,3260,3327,3331,3342,3346,3349,3351,3354,3379,3406,3408,3412,3515,3528,3529,3544,3550,3589,3599,3604,3619,3620,3623,3637,3640,3641,3664,3666,3669,3675,3685,3686,3687,3689,3692,3797,3918,4048,4218,4256,4279,4291,4319,4320,4387,4784,4785,4788,4789,4798,4799,4801,4846,4847,4848,4898,4918,4923,4934,4936,4937,4938,4948,4954,4956,4962,4964,4970,4973,4979,4981,4989,4990,4992,4993,4995,5002,5004,5018,5027,5225,5235,5236,5269,5270,5273,5299,5300,5304,5309,5316,5324,5327,5330,5339,5346,5358,5360,5362,5364,5405,5433,5449,5451,5471,5479,5550,5551,5552,5553,5571,5625,5640,5643,5644,5645,5652,5653,5662,5694,5696,5697,5706,5718,5719,5722,5731,5733,5742,5744,5752,5753,5763,5772,5773,5777,5851,5864,5865,5866,5868,5875,5876,5878,5882,5883,5884,5900,5918,6062,6064,6146,6176,6257,6309,6312,6337,6357,6502,6558,6988,7014,7109,7256,7437,8011,8014,8030,8077,8140,8150,8151,8191,8195,8199,8200,8207,8218,8251,8269,8281,8282,8318,8326,8328,8517,8559,8623,8639,8664,8799,8849,8854,8869,8911,8919,8990,9022,9045,9046,9060,9063,9130,9145,9149,9260,9264,9265,9266,9268,9377,9392,9399,9400,9415,9427,9460,9544,9575,9597,9598,9624,9626,9827,9837,9906,9910,10140,10241,10254,10281,10286,10332,10334,10338,10433,10434,10435,10501,10608,10631,10687,10699,10718,10720,10729,10860,10926,10935,11291,11293,11316,11319,11321,11362,11475,11476,11557,11588,11589,11626,11627,13901,13959,13960,14072,14075,14076,14099,14101,14124,14199,14205,14281,14282,14283,14299,14374,14424,14540,14619,14620,14624,14634,14648,14674,14677,14678,14683,14684,14690,14692,14727,14731,14732,14734,14737,14738,14782,14806,14807,14817,14818,14833,14836,14837,14838,14839,14842,14846,15043,15105,15196,15197,15248,15376,15424,15425,15447,15448,15450,15499,15503,15512,15514,15515,15518,15523,15539,15557,15558,15559,15560,15561,15574,15635,15638,15641,15642,15643,15663,15693,15694,15698,15732,15739,15740,15743,15744,15745,15746,15747,15748,15749,15844,15845,15852,15908,15912,15914,15946,15958,15994,16001,16015,16021,16022,16112,16120,16121,16122,16148,16157,16162,16169,16170,16216,16217,16248,16338,16353,16383,16418,16510,16511,16512,16580,16582,16599,16602,16607,16626,16635,16655,16670,16672,16676,16677,16689,16725,16726,16728,16768,16769,16780,16781,16786,16787,16802,16804,16812,16813,16822,16827,16832,16845,16858,16859,16860,16865,16867,16878,16932,16934,16935,16949,16951,16953,16957,16959,16962,16963,16979,16985,16992,16993,16995,16996,17001,17003,17032,17144,17169,17170,17174,17184,17287,17288,17348,17349,17391,17392,17397,17399,17473,17484,17486,17488,17490,17522,17610,17612,17624,17646,17648,17720,17806,17807,17808,17811,17820,17851,17853,17854,17859,17923,17924,17928,17931,17935,17971,17973,17975,18016,18025,18037,18041,18042,18043,18047,18132,18137,18141,18153,18154,18155,18156,18177,18192,18227,18228,18234,18235,18264,18278,18279,18281,18282,18295,18335,18336,18380,18381,18423,18489,18494,18495,18496,18508,18509,18510,18522,18533,18534,18535,18539,18655,18657,18674,18693,18695,18705,18706,18707,18708,18709,18741,18742,18744,18745,18774,18800,18803,18809,18812,18914,18915,18924,18928,18930,18931,18935,18955,18974,18975,18981,19041,19057,19066,19067,19069,19071,19072,19073,19079,19082,19087,19094,19105,19124,19125,19157,19158,19159,19184,19185,19192,19194,19195,19198,19199,19200,19207,19208,19230,19250,19251,19253,19254,19255,19259,19260,19261,19262,19263,19264,19265,19266,19267,19268,19269,19270,19271,19272,19273,19274,19275,19276,19277,19279,19280,19281,19282,19309,434,947,952,1575,1576,1615,1616,5813,8912,9028,9355,10740,10874,10875,10877,11356) GROUP BY subtyp1 |
$24.99
$30.00
$82.00
$89.00
$499.00
$300.00
$390.00
$95.00
$39.00
$55.00
$49.00
$36.00
Free Shipping On All Orders Over $99