Men's Winter Thick And Padded Warm Zip Up Hooded Jacket Best Sellers

$79.99 USD

Here’s an 800+ word product description for the Men's Winter Thick and Padded Warm Zip-Up Hooded Jacket, targeting the New Zealand audience, complete with SEO headings, keywords, and meta tag:

Men's Winter Thick and Padded Warm Zip-Up Hooded Jacket – The Ultimate Cold-Weather Essential

Stay Warm, Comfortable, and Stylish This Winter

Combat the winter chill with the Men's Winter Thick and Padded Warm Zip-Up Hooded Jacket, a must-have for those cold New Zealand days. Designed with comfort, functionality, and style in mind, this jacket combines premium insulation, a soft inner lining, and a protective hood to keep you cozy no matter the weather.

Whether you're braving Wellington's windy streets, exploring Auckland’s winter markets, or heading out for a hike in the South Island, this jacket is your ultimate winter companion. Its sleek design and practical features make it a best-seller among men who value warmth without compromising on style.

Why Choose the Men's Winter Thick and Padded Zip-Up Hooded Jacket?

1. Superior Warmth and Insulation

This jacket is crafted with high-quality padding that locks in heat, ensuring you stay warm even during the coldest days. The thick construction provides excellent insulation, making it ideal for New Zealand’s winter conditions.

2. Stylish Design for Everyday Wear

The modern zip-up design and hooded silhouette combine practicality with a fashionable edge. This jacket is versatile enough to pair with casual or semi-formal outfits, making it a great choice for work, weekends, or outdoor adventures.

3. Adjustable and Protective Hood

The jacket features a padded hood for added protection against wind and rain. The adjustable drawstrings allow you to customize the fit, ensuring maximum comfort and warmth during chilly days.

4. Durable and Weather-Resistant Materials

Built for New Zealand’s unpredictable weather, this jacket is made with durable, water-resistant fabric that shields you from light rain and snow. Its sturdy construction ensures long-lasting wear, even in harsh conditions.

5. Practical Storage Options

Equipped with multiple zippered pockets, this jacket allows you to securely store your essentials, such as your phone, wallet, or gloves. The functional design ensures convenience without compromising style.

Key Features of the Men's Winter Thick and Padded Hooded Jacket

Exceptional Comfort

The jacket’s soft inner lining provides a cozy feel against the skin.
Elasticized cuffs and hem trap heat, keeping you warm and comfortable.

All-Day Wearability

Lightweight yet heavily padded, this jacket offers warmth without feeling bulky.
The zip-up closure allows for easy layering over sweaters or thermals.

Built for Outdoor Adventures

Perfect for hiking, skiing, or simply running errands in winter weather.
With its water-resistant fabric, this jacket is built to withstand New Zealand’s wet and windy climate.

Available in Multiple Sizes and Colors

Choose from a range of sizes to ensure the perfect fit.
Classic color options like black, navy, and grey complement any wardrobe.

Why It’s a Best-Seller in New Zealand

Designed for New Zealand’s Winters

This jacket is tailored to meet the needs of Kiwi men, providing reliable warmth and durability to withstand New Zealand’s unique winter conditions. From the chilly mornings of Christchurch to the frosty evenings of Dunedin, this jacket has you covered.

Perfect Blend of Style and Functionality

Its modern design appeals to men of all ages, while its practical features make it an indispensable winter essential. It’s no surprise that it has become a top-rated jacket across New Zealand.

Great Value for Money

Despite its premium quality, this jacket is priced competitively, offering exceptional value for those looking to invest in durable, stylish winterwear.

How to Style the Men's Winter Hooded Jacket

Casual Everyday Look:
- Pair with jeans, a woolen sweater, and boots for a classic winter outfit.
Outdoor Adventures:
- Wear with thermal pants, hiking boots, and a beanie for a day of exploring the outdoors.
Semi-Formal Vibes:
- Layer over a button-up shirt and chinos for a polished yet warm look.

Specifications

Material: Water-resistant polyester with padded insulation
Design: Zip-up front with padded hood
Fit: Regular fit with adjustable cuffs and hem
Pockets: Two zippered side pockets, one interior pocket
Season: Winter
Colors Available: Black, navy, grey, olive green
Sizes Available: S, M, L, XL, XXL

Who Is This Jacket For?

The Men's Winter Thick and Padded Warm Zip-Up Hooded Jacket is ideal for:

Outdoor Enthusiasts: Men who enjoy hiking, camping, or skiing in cold weather.
Everyday Wearers: Those seeking a stylish yet functional jacket for daily use.
Gift Givers: A thoughtful winter gift for dads, brothers, or friends.
All Ages: From young adults to older men, this jacket suits anyone looking for premium winterwear.

Don’t let the cold weather stop you! Invest in the Men's Winter Thick and Padded Warm Zip-Up Hooded Jacket, designed to keep you cozy, stylish, and protected in New Zealand’s winters. Whether it’s for yourself or a loved one, this jacket is a must-have. Order now and experience unmatched warmth and comfort!

This product description emphasizes the jacket’s warmth, durability, and style, while incorporating high-performing SEO keywords to target New Zealand shoppers effectively.

The product may be provided by a different brand of comparable quality.
The actual product may vary slightly from the image shown.

Read all Disclaimer...

Available in New Zealand at GiftTree NZ, in Australia at GiftTree AU, in Canada at Gift Tree CA, and in the United Kingdom at Gift Tree UK!

Shop amazing plants at The Node – a top destination for plant lovers

Ask a Question Ask a Question

Exception: Unknown column 'product_language' in 'where clause'

Database Query Error (1054)

Debug Info:
- Query: 'SELECT * FROM commerce_products WHERE (((`product_id` IN (2359, 2360, 2361, 2371, 2462, 2463, 2573, 2762, 3293, 4107, 4108, 4462, 4531, 4532, 4543, 4633, 4697, 4700, 4701, 4711, 4768, 4769, 4772, 4773, 4927, 4929, 4930, 4932, 4935, 4937, 4939, 5102, 5104, 5105, 5116, 5122, 5123, 5124, 5125, 5126, 5258, 5274, 5842, 5963, 6086, 6107, 6110, 6112, 6158, 6159, 6160, 6161, 6164, 6165, 6166, 6167, 6169, 6170, 6172, 6173, 6174, 6175, 6177, 6178, 6179, 6181, 6182, 6394, 6622, 6623, 6624, 6867, 7055, 7057, 8026, 17243, 17249, 17252, 17256, 17257, 22071, 34801, 34802, 34803, 34804, 34805, 34806, 34807, 35167, 36972, 36974, 40248, 40262, 42294, 42298, 43360, 43364, 44082, 44865, 45248, 46077, 46078, 46079, 46080, 46081, 47098, 48028, 49396, 50346, 50785, 50786, 51109, 51267, 51861, 53830, 53839, 53873, 53887, 54241, 55004, 55334, 55461, 55462, 56356, 59380, 59381, 59382, 59384, 59386, 59387, 59389, 59391, 59393, 59395, 59618, 59620, 59622, 59623, 59625, 59626, 59627, 59628, 59629, 60835, 60864, 63071, 63127, 63140, 63157, 63162, 63188, 63361, 63382, 63388, 63394, 63396, 63404, 63775, 68640, 78653, 85757, 85759, 85761, 85912, 85916, 85927, 85957, 85961, 85964, 85969, 85972, 85976, 85980, 85981, 85990, 85994, 86043, 86047, 86053, 86060, 86066, 86071, 86081, 86085, 86091, 86160, 86168, 86169, 86170, 86172, 86173, 86174, 86177, 86181, 86182, 86183, 86184, 86185, 86186, 86187, 86188, 86189, 86190, 86213, 86219, 86228, 86231, 86232, 86233, 86236, 86244, 86247, 86255, 86258, 87357, 87360, 87370, 87371, 87374, 87377, 87415, 87416, 87418, 87420, 88464, 88595, 88596, 88597, 88599, 90753, 90754, 90755, 90756, 90757, 90758, 90759, 93721, 93722, 93723, 93724, 93725, 93928, 93929, 93930, 93931, 93932, 93933, 93939, 93942, 93947, 93950, 93952, 93964, 93965, 93966, 93967, 93968, 93969, 93970, 94222, 2429, 2431, 2434, 2606, 2623, 2653, 2660, 2687, 2699, 2746, 2756, 2757, 2759, 2777, 2781, 2788, 2798, 2808, 2839, 2840, 2842, 2864, 2865, 2866, 2935, 2936, 2937, 2945, 2963, 3078, 3087, 3176, 3903, 4063, 4064, 4324, 4945, 4957, 5039, 5068, 5161, 5191, 5271, 5274, 5288, 5574, 5969, 8437, 13454, 17226, 25701, 25702, 25704, 25705, 26220, 26225, 27201, 27205, 31097, 32387, 33576, 34796, 34800, 35038, 35812, 35908, 35938, 36095, 36382, 36397, 36416, 36426, 36433, 36440, 36453, 36457, 36553, 36585, 36589, 36590, 36678, 36680, 36682, 36685, 36687, 36703, 36717, 36722, 36728, 36731, 36736, 36739, 36916, 36948, 36951, 36957, 36958, 36961, 36962, 36964, 36967, 36969, 36973, 36975, 36977, 36979, 36981, 36983, 37204, 37205, 37206, 37207, 37208, 37209, 37210, 37212, 37216, 37219, 37222, 37224, 37226, 37227, 37228, 37230, 37233, 37450, 37461, 37462, 37472, 37681, 37687, 37756, 37817, 37901, 38060, 38384, 38523, 38542, 39316, 39440, 39443, 40152, 40361, 40363, 40525, 40526, 40527, 40528, 40529, 40530, 40531, 40533, 40534, 40535, 40545, 40624, 40625, 40627, 40628, 40630, 40631, 40632, 40633, 40638, 40639, 40642, 40643, 40646, 40653, 40662, 40861, 40864, 40877, 40882, 40888, 40892, 40894, 41297, 41987, 42283, 42309, 42527, 42528, 43259, 43601, 44007, 44402, 44415, 44417, 44504, 44509, 44516, 44543, 44738, 44747, 44775, 44783, 44787, 44789, 44907, 44917, 44923, 45128, 45424, 45425, 45427, 45429, 45430, 45431, 45591, 45608, 45612, 45617, 45816, 45819, 45821, 45972, 46059, 46391, 46393, 46395, 46398, 46401, 46402, 46408, 46416, 46422, 46695, 47153, 47295, 48304, 48532, 49075, 49219, 50218, 50331, 50333, 50335, 50336, 50337, 50338, 50373, 50374, 50377, 50379, 50380, 50383, 50384, 50385, 50387, 50738, 50831, 52232, 52291, 52338, 52744, 53026, 53030, 53194, 53348, 53389, 53390, 53564, 53607, 53612, 53616, 53625, 53651, 53655, 53660, 54052, 54109, 54129, 54147, 54161, 54163, 54175, 54295, 54297, 54302, 54308, 54598, 54770, 54788, 54800, 54905, 54906, 54908, 55127, 55233, 55235, 55238, 55239, 55240, 55244, 55245, 55246, 55249, 55250, 55252, 55259, 55332, 55333, 55334, 55336, 55339, 55340, 55341, 55343, 55344, 55346, 55347, 55348, 55349, 55350, 55352, 55369, 55377, 55378, 55380, 55381, 55382, 55400, 55401, 55403, 55404, 55421, 55422, 55423, 55424, 55425, 55453, 55454, 55456, 55457, 55460, 55461, 55462, 55463, 55465, 55467, 55481, 55482, 55483, 55484, 55490, 55491, 55492, 55493, 55508, 55509, 55511, 55512, 55514, 55515, 55522, 55536, 56954, 56959, 56969, 57234, 57328, 57334, 57391, 57402, 57441, 57449, 57451, 57452, 57769, 59123, 59133, 59138, 59139, 59166, 59544, 59547, 59550, 59553, 59574, 59580, 60044, 60331, 60342, 60361, 60503, 60520, 60530, 60644, 60646, 60648, 60649, 60651, 60654, 60657, 60659, 60660, 60667, 60670, 60673, 60676, 60678, 60681, 60683, 60687, 61100, 61227, 61516, 61559, 61937, 61942, 62134, 62142, 62170, 62185, 62204, 62218, 62221, 62228, 62460, 62543, 62547, 62718, 63579, 63997, 64391, 64396, 64397, 64401, 64403, 64406, 64408, 64410, 64412, 64413, 64414, 64416, 64418, 64422, 65503, 65504, 65505, 65507, 65919, 65920, 65921, 65923, 65924, 65926, 65960, 65965, 65976, 65981, 65987, 65991, 65996, 65997, 65999, 66006, 66008, 66011, 66015, 66020, 66022, 66023, 66121, 66244, 68182, 68186, 68187, 68622, 68783, 69223, 70050, 70052, 70053, 70054, 70055, 70056, 70058, 70060, 70069, 70088, 70092, 70151, 70430, 70727, 71115, 71127, 71146, 71155, 71159, 71163, 71593, 71604, 71626, 71635, 71640, 72183, 72209, 72231, 72235, 72238, 72240, 72243, 72245, 72263, 72498, 72503, 72510, 72518, 72540, 72544, 72551, 72566, 72581, 72596, 72602, 72607, 72612, 72615, 72625, 72629, 72632, 72635, 72637, 72647, 72649, 72651, 72653, 72655, 72657, 72661, 72664, 72672, 72674, 72677, 72709, 74542, 84783, 84932, 84951, 86342, 88462, 2483, 2503, 2584, 38698, 38720, 48272, 69338, 72848, 2470, 2483, 2503, 2504, 2505, 2606, 2611, 2617, 2620, 2673, 2755, 2839, 3630, 3633, 3636, 3675, 3677, 3678, 3732, 4140, 4401, 4411, 4534, 5039, 5060, 5296, 5493, 5838, 5842, 6023, 6024, 6907, 7389, 7661, 7846, 7849, 7851, 8424, 31067, 31323, 31935, 31941, 31943, 31944, 31945, 32258, 32259, 32261, 32264, 32270, 32295, 32306, 32323, 32328, 32400, 32401, 32409, 32423, 32424, 32519, 32525, 32530, 34462, 34805, 34806, 35594, 36719, 36726, 36734, 36738, 36949, 36955, 36963, 36965, 36968, 36971, 36976, 36978, 36980, 36984, 37213, 37215, 37218, 37220, 37223, 37225, 37234, 38379, 38390, 38533, 38592, 38602, 38633, 38640, 38698, 38703, 38715, 38720, 38728, 38731, 39017, 39034, 39072, 40242, 40247, 40248, 40250, 40256, 40262, 41139, 41143, 41145, 41203, 41204, 41266, 41267, 41268, 41269, 41270, 41271, 41272, 41273, 41274, 41278, 41283, 41286, 41292, 41293, 41294, 41295, 41296, 41298, 41299, 41300, 41303, 41304, 41309, 41312, 41316, 41319, 41377, 41384, 41987, 41990, 41993, 42000, 42011, 42262, 42288, 42298, 42303, 42313, 42578, 42679, 42681, 42698, 42779, 42783, 42787, 42789, 42899, 42903, 42913, 42924, 43360, 43362, 43938, 43942, 43949, 43958, 44243, 44245, 44246, 44259, 44507, 44517, 44521, 44525, 44738, 44777, 44778, 44779, 44783, 46937, 46992, 47009, 47014, 47037, 47043, 47048, 47055, 47286, 47291, 47311, 47573, 47708, 47798, 47855, 47860, 47861, 47862, 47863, 47865, 47867, 47869, 47872, 47874, 47882, 47971, 48127, 48149, 48150, 48267, 48269, 48270, 48271, 48272, 48883, 49175, 49203, 49212, 49215, 49280, 49328, 49389, 49392, 49394, 49397, 49532, 49794, 50163, 50337, 50660, 50662, 50665, 50666, 50669, 50672, 50673, 50675, 50677, 50679, 50682, 50829, 50846, 51132, 51136, 51137, 51158, 51161, 51254, 51255, 51263, 51264, 51327, 51838, 51965, 51968, 52218, 52219, 52229, 52230, 52238, 52433, 53194, 53389, 53471, 53612, 53656, 54052, 54129, 54147, 54193, 54374, 54480, 54613, 54724, 54804, 54829, 54904, 54907, 54908, 55024, 55224, 55227, 55234, 55236, 55237, 55238, 55240, 55244, 55245, 55246, 55247, 55248, 55249, 55252, 55259, 55333, 55335, 55337, 55381, 55382, 55383, 55400, 55403, 55404, 55423, 55424, 55450, 55454, 55456, 55457, 55458, 55462, 55473, 55474, 55491, 55493, 55495, 55497, 55498, 55500, 55506, 55518, 55525, 55662, 55666, 55674, 55883, 56022, 56032, 56540, 56554, 56555, 56557, 56565, 56591, 56754, 57209, 57423, 57441, 57449, 57452, 57744, 58794, 58797, 60503, 61388, 61391, 61649, 61663, 61769, 61776, 61927, 62378, 62382, 66692, 67003, 67066, 67309, 67318, 67331, 67334, 67381, 67386, 67709, 67754, 67758, 67761, 67776, 67778, 67781, 68192, 68194, 68217, 68289, 68861, 68876, 68902, 69348, 69595, 72267, 72848, 72850, 72860, 72864, 75600, 75609, 75614, 75619, 75664, 75848, 75976, 76274, 76283, 76328, 76331, 76459, 76461, 76464, 76474, 76515, 76519, 77004, 77015, 77016, 77024, 77025, 77026, 77107, 77108, 77245, 77362, 77527, 77593, 78057, 78431, 84825, 84826, 88459, 88460, 88464, 88465, 88592, 88593, 88594, 88596, 88597, 88598, 88599, 89185, 94587, 94625, 94631, 94635, 96036, 2470, 2503, 2504, 2505, 38703, 38731, 56555, 56591, 69885, 2483, 2486, 2503, 2504, 2584, 2870, 2871, 2872, 2875, 2888, 2889, 2890, 3001, 3010, 3793, 44243, 50629, 52433, 67754, 6023, 6024, 38715, 40242, 40250, 47573, 48267, 48269, 48270, 48271, 48883, 61663, 36965, 48271, 61663, 35594, 38533, 38698, 38703, 38728, 38731, 56591, 69886, 77107, 77108, 52229, 52230, 55666, 76461, 38715, 38720, 40242, 41377, 41384, 47708, 48883, 51838, 54724, 54829, 55473, 55474, 55666, 55674, 67758, 68192, 68217, 68861, 77527, 48271, 54374, 55024, 67761, 76459, 40242, 47708, 49794, 50629, 47573, 55883, 66692, 75848, 31935, 31941, 31943, 31944, 31945, 32409, 36719, 36726, 36734, 36738, 36949, 36955, 36963, 36965, 36968, 36971, 36976, 36978, 36980, 36984, 37213, 37215, 37218, 37220, 37223, 37225, 38533, 40242, 42698, 44245, 47855, 48021, 49389, 49392, 55662, 66692, 69888, 69889, 54374, 55024, 47855, 49392, 76461, 31943, 36949, 36955, 36963, 36968, 36971, 36976, 38930, 40617, 54829, 36726, 36738, 38390, 44246, 51968, 54724, 56526, 56554, 56565, 67758, 69595, 77245, 51965, 56540, 5493, 61388, 61391, 61649, 61769, 61776, 69874, 32409, 38533, 40247, 43612, 46501, 51265, 51266, 56591, 76328, 52433, 67754, 4411, 38703, 38720, 31941, 36738, 37225, 38390, 44259, 54804, 55227, 55450, 77245, 31945, 36965, 37225, 38390, 38533, 38698, 38703, 38728, 49392, 4444, 5838, 8424, 8425, 8426, 8427, 8429, 31881, 34227, 37431, 49394, 49397, 51136, 51158, 51161, 51163, 51166, 51254, 51255, 51258, 51260, 51629, 51630, 51633, 67386, 84826, 48883, 38533, 31945, 49389, 49392, 4444, 8426, 51251, 51254, 51255, 51260, 43370, 51161, 51163, 8430, 49394, 8425, 8427, 8429, 8430, 8213, 43370, 49397, 49394, 55890, 31881, 34227, 51163, 67386, 8430, 49394, 55890, 8424, 51158, 51161, 8429, 37431, 51166, 51258, 51158, 51161, 51254, 51255, 51260, 34227, 37431, 51137, 51136, 8425, 37223, 38379, 51264, 51635, 51637, 51639, 51642, 51646, 51648, 51650, 55229, 55883, 49328, 49328, 51263, 51264, 37223, 51264, 96036, 51634, 51635, 51637, 51639, 51642, 51646, 51648, 51650, 51650, 49328, 51650, 732, 1371, 4401, 4411, 4550, 4953, 4978, 5195, 5296, 5387, 5388, 5485, 5487, 5491, 5494, 5496, 5549, 5833, 5838, 5839, 5840, 5928, 6025, 6026, 6027, 6029, 6030, 6031, 6032, 6033, 6034, 6035, 6036, 6038, 6039, 6255, 6860, 6861, 6862, 6863, 6864, 6865, 7018, 7020, 7024, 7026, 7032, 7034, 7664, 8294, 17243, 17249, 17257, 35172, 36460, 37243, 38233, 38381, 38580, 38614, 38633, 38720, 39017, 39034, 39072, 40248, 41139, 41155, 41202, 41204, 41267, 41268, 41269, 41270, 41272, 41273, 41274, 41278, 41293, 41294, 41296, 41297, 41298, 41299, 41300, 41303, 41304, 41309, 41324, 41325, 41326, 41386, 41987, 41993, 42000, 42002, 42011, 42035, 42262, 42283, 42298, 42349, 42788, 43359, 43360, 43361, 43362, 43364, 43365, 43379, 43381, 43384, 43684, 43942, 43949, 43958, 44087, 44500, 44501, 44502, 44507, 44509, 44513, 44521, 44738, 44777, 44960, 44998, 47322, 47578, 48307, 48309, 48315, 48324, 48326, 48540, 49083, 49175, 49689, 50259, 50262, 50327, 50826, 50941, 50943, 50944, 51262, 51327, 51697, 51699, 51700, 51702, 51703, 51704, 51706, 51710, 51712, 51714, 52060, 52073, 52076, 52078, 52080, 52085, 52087, 52091, 52092, 52097, 52100, 52103, 52218, 52219, 52221, 52222, 52224, 52226, 52421, 52426, 52431, 52434, 52437, 52443, 52453, 52454, 52456, 53194, 53341, 53358, 54052, 54904, 54905, 54969, 55227, 55251, 55336, 55343, 55380, 55450, 55462, 55463, 55465, 55474, 56557, 56954, 57335, 57449, 57452, 58782, 60427, 60503, 61450, 63414, 63431, 63437, 67015, 67339, 67348, 67352, 67375, 67724, 67766, 68192, 68728, 68729, 68851, 68858, 68861, 68863, 68864, 68866, 68868, 68872, 68876, 68877, 68881, 68883, 68902, 69079, 69080, 69083, 69087, 69286, 69288, 69292, 73584, 73590, 73597, 73604, 73606, 73611, 73620, 73636, 73640, 73642, 73889, 75638, 76036, 76283, 76464, 77030, 77535, 89185, 92219, 94418, 94622, 94630, 94645, 4978, 5487, 5496, 8294, 43359, 52431, 732, 1371, 4440, 4550, 5839, 7664, 38720, 41386, 47578, 47708, 50327, 52073, 52078, 52087, 52091, 52103, 54969, 68728, 68861, 68868, 68876, 5485, 5496, 36994, 43359, 47990, 50259, 52434, 4462, 17243, 43360, 43361, 43365, 43384, 47999, 48000, 49524, 63431, 63437, 67015, 68728, 68729, 68851, 68861, 68863, 68864, 68866, 68872, 68881, 68883, 4440, 5491, 6025, 6026, 6027, 6029, 6030, 6031, 6032, 6033, 6034, 6035, 6036, 6038, 6039, 6860, 6861, 6862, 6863, 7018, 7020, 7023, 7024, 27960, 38381, 47999, 50941, 52437, 7018, 7020, 7023, 7026, 49689, 49524, 63414, 4978, 43359, 47990, 6255, 50943, 51262, 58782, 47578, 49083, 50944, 55227, 55450, 55474, 56557, 68192, 68858, 49524, 5491, 6864, 6865, 7020, 7023, 7024, 7026, 47999, 48000, 49524, 67015, 68863, 68866, 68872, 68877, 68881, 68883, 4576, 4953, 5195, 5388, 5488, 5838, 6866, 7028, 7032, 7034, 38233, 51261, 52266, 52270, 52279, 52280, 52281, 52282, 52284, 52285, 52286, 52287, 52416, 52418, 52421, 52425, 52426, 52427, 77030, 52266, 52270, 52279, 52280, 52281, 52282, 52284, 52286, 52287, 52418, 52425, 52427, 7028, 43370, 77030, 5195, 5388, 7028, 7032, 7034, 51261, 52270, 52284, 52285, 52286, 52287, 52418, 5388, 7034, 5388, 52282, 5195, 6866, 52279, 52280, 52425, 52427, 6866, 52280, 52285, 52416, 732, 1371, 38381, 732, 1371, 5296, 49524, 5487, 7852, 37236, 38580, 38592, 38602, 42298, 43338, 44501, 44504, 44509, 44516, 44518, 44525, 44736, 44780, 48307, 48309, 49324, 49459, 50662, 50665, 50666, 50669, 50672, 50675, 50677, 50679, 50682, 51262, 51629, 51630, 51633, 51634, 51862, 51864, 51867, 51868, 52108, 52111, 52112, 52114, 52115, 52117, 52118, 52120, 52122, 52124, 53358, 53389, 53452, 53612, 54193, 54266, 54904, 55247, 55251, 55334, 55336, 55339, 55343, 55461, 55462, 55482, 55513, 55522, 56954, 56963, 57335, 58782, 60503, 68186, 75638, 36876, 50662, 50665, 50666, 50672, 50675, 50677, 50679, 50682, 51629, 51630, 51633, 51634, 52108, 52111, 52112, 52114, 52115, 52117, 52118, 52120, 52122, 52124, 69301, 69305, 69307, 49324, 51262, 51862, 51864, 51867, 51868, 53452, 50669) AND (`product_language` IS NULL AND `product_id` != 55462)) AND `product_is_offline` = \'0\') AND `product_deleted_datetime` IS NULL) ORDER BY `product_order` asc, `product_price_base` desc, `product_title` asc LIMIT 0, 8'

in Page /products/ line 2

in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 993

Color:
Size: