Berlei Ultimate Comfort Strapless Bra

Name: Berlei Ultimate Comfort Strapless Bra
Brand: Gift Tree
Price: 16.79 NZD
Availability: InStock

$16.79 USD

Fabric: Nylon / nylon

When it comes to finding the perfect bra, comfort and support are non-negotiable. For New Zealand women, balancing fashion with function can be challenging, especially when it comes to strapless bras. That’s where the Berlei Ultimate Comfort Strapless Bra comes in – designed to provide superior support, all-day comfort, and a smooth silhouette no matter what you wear.

The Berlei Ultimate Comfort Strapless Bra has earned its reputation as one of the most reliable strapless bras on the market. Whether you’re dressing for a wedding, a cocktail evening in Auckland, a formal event in Wellington, or simply want a supportive option under summer tops in Queenstown, this bra is built to stay in place without slipping or digging into your skin.

Made with soft-touch fabric, hidden underwire, and multiway straps, this bra ensures both flexibility and stability. Berlei’s expertise in lingerie design means you don’t have to compromise between looking stylish and feeling comfortable.

With women in NZ increasingly seeking high-quality, supportive lingerie that fits their lifestyle, this bra stands out as an investment piece for every wardrobe.

Keypoints

Strapless design with superior grip – stays in place all day.
Hidden underwire support – provides lift without discomfort.
Soft-touch fabric – smooth, breathable, and gentle on the skin.
Multiway straps included – convertible to strapless, halter, cross-back, or traditional.
Seamless finish – invisible under clothing, perfect for formal wear.
Available in multiple sizes – from smaller cup sizes to fuller busts.
Neutral colour options – versatile shades that match different outfits.
Trusted Berlei brand – over 100 years of lingerie innovation.

Benefits

1. All-Day Comfort

The Berlei Ultimate Comfort Strapless Bra is designed with soft, breathable materials and cushioned bands that ensure comfort even after hours of wear. Say goodbye to pinching or sliding straps.

2. Superior Support

Unlike many strapless bras that fail with movement, this bra uses Berlei’s signature underwire technology and a silicone grip to keep everything in place – offering confidence and freedom.

3. Multiway Flexibility

With detachable straps, you can wear this bra in four different ways: strapless, halter, cross-back, or standard. This makes it a versatile choice for every outfit in your NZ wardrobe.

4. Seamless Silhouette

Perfect under wedding gowns, bridesmaid dresses, evening gowns, and fitted tops, the seamless design ensures a smooth, invisible look.

5. Designed for All Body Types

Whether you’re petite or fuller-busted, Berlei bras are known for their inclusive sizing. The Ultimate Comfort Strapless Bra is designed to deliver the right balance of shape and support for NZ women of all sizes.

6. Long-Lasting Quality

Berlei has a long-standing reputation for durability. With proper care, this bra retains its elasticity and shape, giving you excellent value for money.

Why You Choose This

Trusted Brand – Berlei is a leading name in lingerie, trusted by women across NZ and globally.
Perfect for NZ Occasions – from weddings in Christchurch, to cocktail events in Auckland, to business functions in Wellington.
Versatile Styling – works seamlessly under strapless dresses, off-shoulder tops, and evening gowns.
Tailored for Comfort & Confidence – no slipping, sliding, or constant readjustment.
Easy to Buy in NZ – available at Farmers NZ, Bendon Outlet, Bras N Things, and online retailers.
Affordable Luxury – with prices typically ranging between $60–$90, it offers premium quality without breaking the bank.

Conclusion

The Berlei Ultimate Comfort Strapless Bra NZ is more than just lingerie – it’s a foundation for confidence, elegance, and ease. It combines innovative support technology, versatile design, and long-lasting comfort, making it the perfect choice for Kiwi women seeking both practicality and style.

Whether you’re preparing for a wedding, attending a formal gala, or simply need a reliable everyday bra for strapless outfits, this Berlei bra is the answer. With its seamless fit, superior grip, and soft-touch fabric, it ensures that you look as good as you feel.

In a world where comfort often takes second place to fashion, Berlei has mastered the art of combining both – and the Ultimate Comfort Strapless Bra proves it. Invest in one today and experience the perfect balance of luxury and support for every NZ occasion.

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 (4006, 4030, 4114, 95259, 97276, 97309, 97321, 97599, 97606, 3992, 4006, 4030, 4031, 4032, 4033, 4138, 4143, 4149, 4152, 4209, 4299, 4385, 5218, 5221, 5224, 5263, 5265, 5266, 5325, 5750, 5751, 6029, 6042, 6175, 6709, 6734, 7005, 7216, 7576, 7580, 7770, 7771, 8689, 9184, 9467, 9670, 9673, 9675, 10282, 54084, 54366, 54930, 55007, 55031, 55048, 55049, 55065, 55081, 79158, 79195, 79201, 79208, 79222, 79234, 79235, 79240, 79273, 79287, 79298, 79310, 79413, 79425, 79497, 79516, 79529, 79566, 79593, 79624, 79635, 79663, 79700, 79706, 79708, 79713, 79716, 79750, 79753, 81956, 82646, 82653, 82655, 82658, 82661, 82666, 82668, 82670, 82674, 82903, 82905, 82908, 82910, 82913, 82915, 82924, 83212, 83218, 83223, 83321, 83328, 83585, 83591, 83597, 83615, 83637, 84079, 84105, 84115, 84120, 84387, 84488, 84490, 84505, 84585, 84589, 84593, 84595, 84698, 84702, 84712, 84723, 85147, 85149, 85721, 85725, 85732, 85740, 86021, 86023, 86024, 86038, 86279, 86290, 86294, 86298, 86499, 86537, 86538, 86546, 86550, 88011, 88145, 88361, 88660, 88662, 88663, 88664, 88667, 88762, 88828, 88970, 89006, 89025, 89083, 89086, 89087, 89228, 89232, 89234, 89235, 89236, 89238, 89239, 89240, 89241, 89242, 89243, 89244, 89247, 89251, 89298, 89300, 89302, 89326, 89327, 89335, 89337, 89338, 89348, 89349, 89365, 89369, 89378, 89379, 89386, 89387, 89388, 89390, 89392, 89403, 89409, 89498, 89502, 89504, 89790, 89796, 90259, 90380, 91022, 92073, 92076, 93522, 94833, 94848, 94874, 95265, 95915, 96246, 96253, 96256, 96270, 96280, 96288, 96294, 96301, 96305, 96331, 96337, 96339, 96341, 96345, 96363, 96366, 96367, 96368, 96372, 96386, 96392, 96397, 96399, 97161, 97266, 97267, 97270, 97273, 97276, 97279, 97281, 97284, 97286, 97288, 97291, 97301, 97305, 97309, 97313, 97314, 97317, 97320, 97321, 97584, 97587, 97588, 97599, 97602, 97603, 97606, 97610, 97613, 97614, 97615, 97616, 97621, 97623, 97624, 97625, 99573, 99634, 99877, 99886, 99899, 99902, 99951, 99956, 100221, 100408, 100535, 100831, 100840, 101775, 101778, 101903, 101905, 101907, 101914, 101958, 101962, 102395, 102406, 102407, 102415, 102416, 102417, 102496, 102497, 103271, 103286, 103291, 103316, 103644, 103654, 103659, 104417, 104466, 104544, 104580, 104727, 104796, 104892, 104936, 105166, 113268, 113269, 117539, 117540, 117544, 117545, 117670, 117671, 117672, 117674, 117675, 117676, 117677, 118266, 123615, 123652, 123659, 123663, 3992, 4030, 4031, 4032, 4033, 79750, 88663, 90259, 96092, 4006, 4012, 4030, 4031, 4114, 4418, 4419, 4420, 4423, 4436, 4437, 4438, 4556, 4566, 5387, 86021, 97276, 97281, 97284, 97309, 97313, 97314, 97317, 97320, 97321, 97584, 97587, 97588, 97621, 97623, 97624, 97625, 7770, 7771, 103659, 82655, 79195, 79753, 90259, 96093, 102496, 102497, 89502, 101905, 55048, 55049, 83321, 83328, 88970, 89025, 89378, 89379, 89502, 89504, 94833, 103659, 104892, 88762, 101903, 88361, 100408, 55062, 79201, 79222, 79234, 79413, 79425, 82646, 82653, 82655, 82658, 82661, 82666, 82668, 82670, 82674, 82903, 82905, 82908, 82910, 82913, 82915, 84505, 86023, 89498, 96095, 96096, 88762, 79208, 101905, 82646, 82653, 82658, 82661, 82666, 89025, 103659, 79287, 79529, 79593, 79700, 79713, 86024, 88662, 88667, 88970, 90198, 95915, 104727, 88660, 97276, 97279, 97281, 97284, 97286, 97288, 97291, 97301, 97305, 97309, 7216, 79310, 79624, 96084, 97266, 97267, 97269, 97270, 97273, 85393, 87938, 90259, 101775, 103659, 97313, 97314, 97317, 97320, 97321, 97584, 97587, 97588, 6042, 97599, 97602, 97606, 97610, 97615, 97616, 82915, 86038, 89006, 89228, 97599, 97602, 97606, 97610, 97615, 97616, 104727, 82655, 82915, 6077, 7576, 10282, 10283, 10284, 10285, 10287, 79235, 82175, 99956, 113269, 6077, 10284, 82175, 85157, 10288, 10283, 10285, 10287, 10288, 10059, 85157, 88365, 99956, 10288, 88365, 10282, 10287, 10283, 82913, 88361, 89230, 96253, 96256, 96366, 96368, 104417, 82913, 96253, 96256, 96270, 96341, 96366, 96367, 96368, 6644, 6730, 6739, 6751, 6752, 6976, 7097, 7098, 7102, 7282, 7307, 7333, 7340, 7341, 7344, 7414, 7416, 7418, 7419, 7425, 7429, 7431, 7462, 7479, 7488, 7500, 7506, 7507, 7508, 7511, 7515, 7516, 7517, 7522, 7525, 7526, 7527, 7528, 7533, 7534, 7535, 7537, 7538, 7591, 7592, 7674, 7797, 7812, 8059, 8060, 8061, 8063, 8180, 8298, 8299, 8300, 8302, 8350, 8367, 8396, 8449, 8478, 8481, 8587, 8588, 8679, 8685, 8889, 9058, 9156, 9157, 9203, 9228, 9250, 9360, 9398, 9406, 9407, 9411, 9535, 9675, 9680, 9956, 9994, 12612, 26734, 45052, 45053, 45069, 50260, 50308, 53850, 54216, 54362, 54363, 54442, 54448, 54499, 54501, 54911, 54932, 54941, 54966, 54991, 55001, 55004, 55006, 55031, 55046, 55066, 55280, 55281, 55449, 55474, 55477, 64461, 64489, 64568, 64577, 64578, 64596, 64610, 64637, 64859, 64862, 64864, 65014, 65015, 65072, 79094, 79097, 79120, 79132, 79136, 79159, 79176, 79193, 79207, 79212, 79245, 79250, 79254, 79294, 79297, 79302, 79303, 79307, 79308, 79347, 79348, 79349, 79351, 79352, 79356, 79359, 79367, 79423, 79430, 79432, 79434, 79528, 79530, 79534, 79535, 79548, 79563, 79570, 79571, 79572, 79614, 79636, 79703, 79715, 79746, 79759, 79779, 79806, 79851, 79876, 80130, 80133, 80135, 80136, 80137, 80153, 82428, 82434, 82601, 82615, 82622, 82691, 82972, 83177, 83461, 83574, 83591, 83597, 83637, 84100, 84327, 84336, 84392, 84397, 84489, 84495, 84496, 84503, 84506, 84507, 84508, 84509, 84512, 84513, 84514, 84524, 84591, 84592, 84596, 84605, 84616, 84623, 84639, 84641, 84654, 84656, 84661, 84662, 84664, 84665, 84666, 84668, 84669, 84671, 84672, 84723, 84802, 84803, 84804, 84808, 84810, 84845, 84849, 84851, 84853, 84860, 84862, 84877, 84879, 84890, 84913, 84914, 84946, 84948, 85043, 85044, 85045, 85126, 85127, 85128, 85130, 85171, 85172, 85173, 85174, 85175, 85176, 85351, 85385, 85386, 85387, 85389, 85394, 85396, 85400, 85403, 85404, 85595, 85618, 85620, 85626, 85705, 85706, 85707, 85737, 85788, 85850, 85851, 85853, 85856, 85858, 85860, 85862, 85866, 85867, 85870, 85871, 85872, 85878, 85881, 85889, 85967, 85968, 85969, 85973, 85992, 86019, 86039, 86040, 86041, 86048, 86057, 86172, 86177, 86178, 86184, 86197, 86198, 86200, 86204, 86206, 86208, 86272, 86274, 86276, 86279, 86284, 86286, 86290, 86291, 86304, 86306, 86314, 86315, 86320, 86321, 86326, 86334, 86336, 86340, 86343, 86345, 86352, 86354, 86394, 86396, 86398, 86399, 86403, 86405, 86413, 86414, 86415, 86416, 86417, 86418, 86419, 86420, 86421, 86422, 86423, 86424, 86425, 86426, 86433, 86438, 86470, 86475, 86482, 86499, 86502, 86506, 86507, 86518, 86522, 86525, 86527, 86535, 86536, 86552, 86554, 86555, 86556, 86633, 86634, 86635, 86636, 86637, 86724, 86783, 86826, 86853, 87147, 87175, 87275, 87361, 87362, 87363, 87364, 87365, 87366, 87369, 87370, 87371, 87373, 87374, 87380, 87386, 87392, 87396, 87403, 87408, 87412, 87418, 87429, 87465, 87507, 87565, 87567, 87568, 87570, 87571, 87572, 87574, 87578, 87582, 87594, 87626, 87640, 87677, 87772, 87775, 87777, 87778, 87779, 87780, 87781, 87843, 87954, 87977, 87982, 88031, 88039, 88062, 88067, 88089, 88109, 88122, 88146, 88152, 88155, 88159, 88172, 88230, 88238, 88256, 88275, 88276, 88304, 88305, 88307, 88308, 88309, 88310, 88311, 88314, 88316, 88319, 88323, 88339, 88347, 88355, 88368, 88374, 88393, 88397, 88405, 88425, 88436, 88476, 88509, 88511, 88632, 88670, 88687, 88719, 88770, 88775, 88789, 88795, 88797, 88841, 88843, 88912, 88966, 88993, 89002, 89012, 89016, 89021, 89053, 89139, 89140, 89141, 89142, 89143, 89144, 89145, 89147, 89149, 89150, 89155, 89156, 89157, 89158, 89164, 89167, 89218, 89232, 89268, 89295, 89297, 89310, 89317, 89320, 89323, 89345, 89350, 89394, 89395, 89397, 89399, 89400, 89401, 89402, 89408, 89413, 89414, 89415, 89416, 89450, 89451, 89452, 89453, 89454, 89455, 89457, 89458, 89459, 89460, 89461, 89462, 89463, 89464, 89465, 89466, 89467, 89468, 89469, 89470, 89471, 89472, 89473, 89474, 89475, 89476, 89477, 89478, 89481, 89482, 89559, 89561, 89562, 89568, 89581, 89582, 89583, 89584, 89629, 89631, 89632, 89633, 89634, 89635, 89636, 89637, 89638, 89645, 89646, 89647, 89648, 89649, 89650, 89651, 89652, 89653, 89654, 89655, 89656, 89657, 89658, 89662, 89663, 89667, 89668, 89669, 89670, 89671, 89672, 89673, 89674, 89761, 89812, 89903, 89908, 89911, 90074, 90076, 90077, 90078, 90079, 90080, 90081, 90082, 90084, 90094, 90095, 90096, 90097, 90110, 90120, 90122, 90123, 90155, 90156, 90157, 90158, 90159, 90160, 90161, 90162, 90163, 90192, 90305, 90308, 90310, 90311, 90316, 90319, 90361, 90372, 90374, 90433, 90434, 90435, 90436, 90437, 90439, 90442, 90445, 90451, 90456, 90460, 90462, 90464, 90466, 90467, 90469, 90472, 90553, 90554, 90559, 90564, 90569, 90570, 90572, 90674, 90677, 90681, 90709, 90710, 90712, 90713, 90717, 90722, 90723, 90727, 90731, 90732, 90733, 90735, 90736, 90841, 90842, 90843, 90844, 90845, 90846, 90847, 90848, 90849, 90850, 90851, 90853, 90854, 90855, 90856, 90857, 90858, 90859, 90862, 90871, 90916, 91020, 91048, 91049, 91050, 91051, 91052, 91053, 91054, 91055, 91056, 91057, 91058, 91059, 91060, 91061, 91062, 91063, 91064, 91065, 91066, 91067, 91068, 91073, 91074, 91077, 91172, 91174, 91175, 91176, 91178, 91179, 91180, 91181, 91182, 91183, 91184, 91185, 91186, 91187, 91188, 91189, 91190, 91191, 91316, 91317, 91319, 91321, 91323, 91326, 91327, 91329, 91330, 91334, 91335, 91336, 91337, 91338, 91339, 91340, 91341, 91342, 91343, 91344, 91389, 91427, 91495, 91496, 91497, 91500, 91501, 91502, 91503, 91505, 91507, 91509, 91511, 91513, 91514, 91515, 91516, 91518, 91621, 91622, 91624, 91625, 91629, 91633, 91634, 91636, 91637, 91639, 91642, 91643, 91644, 91645, 91646, 91647, 91648, 91649, 91650, 91651, 91726, 91727, 91728, 91729, 91730, 91731, 91732, 91733, 91734, 91735, 91736, 91737, 91738, 91739, 91740, 91741, 91742, 91743, 91744, 91745, 91746, 91873, 91874, 91875, 91878, 91881, 91882, 91883, 91884, 91885, 91886, 91887, 91888, 91890, 91891, 91892, 91894, 92018, 92019, 92024, 92029, 92031, 92034, 92035, 92036, 92103, 92104, 92106, 92107, 92108, 92109, 92110, 92111, 92112, 92113, 92115, 92116, 92117, 92118, 92119, 92120, 92121, 92122, 92193, 92202, 92205, 92207, 92208, 92209, 92212, 92214, 92216, 92218, 92219, 92220, 92222, 92223, 92224, 92226, 92230, 92300, 92301, 92302, 92303, 92304, 92305, 92306, 92307, 92308, 92310, 92313, 92314, 92318, 92323, 92324, 92326, 92327, 92328, 92332, 92335, 92339, 92340, 92409, 92410, 92413, 92415, 92416, 92417, 92422, 92425, 92428, 92431, 92443, 92445, 92451, 92452, 92720, 92724, 92730, 92733, 92734, 92778, 92779, 92782, 92783, 92784, 92785, 92786, 92788, 92790, 92826, 92905, 92906, 92909, 92911, 92923, 92928, 92930, 92945, 92947, 92949, 92955, 92969, 92976, 92997, 93000, 93011, 93013, 93016, 93018, 93020, 93141, 93144, 93146, 93147, 93148, 93149, 93152, 93153, 93155, 93156, 93157, 93159, 93170, 93176, 93177, 93180, 93182, 93190, 93213, 93227, 93228, 93230, 93238, 93242, 93248, 93249, 93258, 93271, 93527, 93649, 93656, 93661, 93665, 93708, 93732, 93734, 93736, 93737, 93738, 93739, 93741, 93742, 93743, 93754, 93756, 93757, 93758, 93760, 93761, 93762, 93763, 93764, 93766, 93767, 93769, 93770, 93772, 93774, 93776, 93777, 93778, 93780, 93781, 93784, 93787, 93790, 93792, 93794, 93849, 93851, 93856, 93859, 93862, 93865, 93868, 93872, 93874, 93876, 93879, 93881, 93883, 93886, 93904, 93919, 93921, 93922, 93923, 93925, 93926, 93929, 93935, 93938, 93942, 93947, 93949, 93952, 93954, 93955, 93956, 93958, 93959, 93960, 93962, 93963, 94119, 94123, 94128, 94130, 94131, 94135, 94138, 94142, 94146, 94150, 94160, 94173, 94177, 94179, 94181, 94182, 94189, 94192, 94196, 94199, 94201, 94203, 94206, 94210, 94213, 94216, 94223, 94224, 94298, 94299, 94300, 94302, 94303, 94304, 94307, 94315, 94324, 94327, 94328, 94329, 94332, 94333, 94336, 94339, 94342, 94345, 94349, 94353, 94355, 94357, 94358, 94362, 94364, 94366, 94369, 94370, 94371, 94373, 94374, 94376, 94377, 94391, 94392, 94422, 94427, 94429, 94436, 94437, 94475, 94481, 94483, 94485, 94491, 94494, 94496, 94504, 94507, 94595, 94611, 94669, 94672, 94678, 94685, 94701, 94702, 94703, 94810, 94895, 94897, 94898, 94900, 94902, 94903, 94904, 94905, 94906, 94907, 94908, 94909, 94910, 94911, 94912, 94913, 94915, 94916, 94917, 94918, 94919, 94920, 94921, 94922, 94923, 94924, 94925, 94926, 94927, 94928, 94947, 94949, 94950, 94957, 94958, 94961, 94967, 94970, 94978, 94982, 94985, 94989, 95092, 95097, 95098, 95102, 95190, 95242, 95243, 95268, 95270, 95273, 95278, 95281, 95283, 95290, 95337, 95344, 95357, 95360, 95362, 95363, 95364, 95367, 95405, 95413, 95414, 95421, 95429, 95431, 95437, 95439, 95443, 95448, 95450, 95458, 95465, 95500, 95504, 95507, 95580, 95581, 95585, 95590, 95592, 95606, 95618, 95660, 95743, 95744, 95745, 95903, 95906, 95926, 95931, 96002, 96106, 96107, 96108, 96190, 96216, 96218, 96226, 96232, 96238, 96239, 96242, 96245, 96247, 96251, 96254, 96260, 96274, 96276, 96277, 96297, 96309, 96332, 96336, 96340, 96342, 96348, 96349, 96448, 96480, 96501, 96511, 96516, 96518, 96521, 96561, 96598, 96600, 96602, 96622, 96625, 96628, 96629, 96630, 96631, 96632, 96633, 96634, 96635, 96636, 96637, 96638, 96639, 96641, 96642, 96647, 96649, 96737, 96741, 96752, 96764, 96771, 96773, 96777, 96779, 96838, 96841, 97011, 97012, 97013, 97014, 97015, 97017, 97018, 97019, 97020, 97021, 97023, 97025, 97027, 97033, 97037, 97041, 97045, 97076, 97078, 97079, 97082, 97091, 97092, 97093, 97096, 97098, 97105, 97107, 97110, 97114, 97125, 97129, 97132, 97134, 97135, 97136, 97137, 97138, 97139, 97140, 97141, 97142, 97143, 97145, 97146, 97147, 97148, 97150, 97151, 97152, 97156, 97157, 97160, 97170, 97263, 97292, 97329, 97583, 97597, 97609, 97666, 97862, 98052, 98057, 98063, 98090, 98094, 98215, 98232, 98288, 98289, 98291, 98292, 98297, 98299, 98301, 98304, 98306, 98354, 98363, 98364, 98376, 98381, 98490, 98966, 99067, 99070, 99074, 99079, 99576, 99581, 99582, 99585, 99587, 99589, 99593, 99595, 99597, 99640, 99892, 99897, 99932, 99934, 99944, 100191, 100215, 100276, 100501, 100525, 100529, 100552, 100578, 100597, 100600, 100834, 100845, 100857, 101758, 101769, 101776, 101779, 101916, 102408, 103325, 104455, 104527, 104593, 104808, 104828, 104900, 104918, 105542, 105544, 105683, 105749, 108049, 108050, 108051, 108052, 108053, 108054, 108055, 108056, 108057, 108058, 108059, 108060, 108175, 108203, 108211, 108257, 110417, 110420, 110462, 110467, 113240, 113264, 113265, 113274, 113994, 113995, 113997, 113998, 113999, 114022, 114024, 114025, 114026, 114028, 114029, 115118, 115119, 115120, 115156, 115158, 115162, 115163, 115164, 115168, 115730, 115737, 117301, 117434, 117930, 117947, 117949, 117950, 118089, 122402, 122643, 122649, 122652, 122658, 122676, 122679, 122692, 122748, 122749, 123366, 123367, 123369, 123370, 123371, 123372, 123373, 123374, 123375, 123582, 123585, 123601, 123602, 123607, 123608, 123609, 123610, 123611, 123612, 123613, 123614, 123615, 123616, 123617, 123618, 123619, 123623, 123625, 123646, 123650, 123651, 123652, 123653, 123654, 123658, 123659, 123662, 123663, 123673, 123678, 123682, 123685, 123688, 9676, 55007, 55063, 55446, 55480, 64474, 64631, 84491, 85146, 85147, 85149, 85151, 85165, 86202, 86215, 86766, 92114, 94138, 95242, 6642, 6645, 6648, 6649, 6650, 6652, 6653, 6656, 6664, 6665, 6666, 6667, 7583, 84510, 84512, 85147, 85148, 85170, 6677, 6680, 6685, 6687, 6690, 6692, 6694, 6737, 6740, 6744, 6748, 6754, 6761, 6770, 55480, 6771, 6772, 6773, 6774, 6808, 6809, 6810, 6811, 6812, 6813, 6822, 6826, 6827, 6828, 6829, 86766, 6861, 6863, 6866, 6867, 6868, 6869, 6871, 6872, 6888, 6889, 6903, 85146, 5917, 6890, 6904, 6905, 6906, 6907, 85146, 6908, 6910, 6912, 6914, 6916, 6925, 6926, 6927, 6928, 6929, 6930, 6931, 6938, 6998, 84510, 6932, 6947, 6948, 6949, 6950, 6967, 6968, 6971, 6973, 55446, 64474, 6979, 6981, 6982, 6983, 6984, 6985, 55446, 64474, 7126, 7170, 7171, 7173, 7175, 7176, 7177, 7178, 7179, 7181, 7184, 7287, 7288, 7290, 7291, 7292, 7377, 7378, 7379, 7380, 7406, 7407, 7408, 7409, 7410, 7509, 7512, 7513, 7514, 55446, 84491, 84510, 7584, 7585, 7586, 7587, 7588, 7589, 7590, 8353, 8355, 8358, 8364, 8372, 8396, 8397, 8398, 8399, 9119, 9155, 9681, 46129, 49539, 49540, 54909, 54915, 54938, 55001, 55256, 64568, 64577, 64631, 64637, 64863, 64864, 79120, 79245, 79307, 79423, 79908, 80135, 82965, 82971, 83461, 84855, 84857, 84858, 84859, 84860, 84862, 84874, 84879, 84888, 84986, 85850, 85851, 85852, 85881, 85884, 86188, 86190, 86191, 86211, 86214, 86312, 86391, 86419, 86421, 86422, 86424, 86426, 86433, 86438, 86533, 86534, 86635, 86724, 86981, 87175, 87181, 87370, 87375, 87977, 88031, 88039, 88060, 88122, 88305, 88309, 88310, 88314, 89144, 89454, 89457, 89459, 89462, 89468, 89476, 89478, 89581, 89582, 89583, 89584, 89629, 89635, 89649, 89651, 89652, 89653, 89657, 89673, 89674, 90433, 90434, 90435, 90436, 90437, 90439, 90442, 90445, 90451, 90460, 90464, 90466, 90467, 90841, 90842, 90843, 90845, 90846, 90847, 90848, 90849, 90851, 90852, 90853, 90854, 90855, 90856, 90857, 90859, 91048, 91049, 91050, 91051, 91052, 91053, 91055, 91056, 91057, 91058, 91059, 91060, 91061, 91062, 91063, 91064, 91065, 91066, 91067, 91175, 91176, 91336, 91337, 91341, 91496, 91500, 91502, 91505, 91507, 91509, 91511, 91513, 91514, 91515, 91516, 91518, 91621, 91622, 91625, 91629, 91633, 91637, 91639, 91642, 91643, 91644, 91645, 91646, 91648, 91649, 91650, 91651, 91731, 91737, 91744, 91873, 91875, 91879, 91881, 91882, 91883, 91887, 91888, 92103, 92104, 92105, 92106, 92107, 92110, 92114, 92117, 92118, 92120, 92121, 92202, 92207, 92209, 92212, 92214, 92216, 92219, 92223, 92224, 92300, 92301, 92302, 92303, 92304, 92305, 92306, 92308, 92312, 92314, 92315, 92316, 92318, 92420, 92425, 92428, 92430, 92432, 92452, 92455, 92459, 92460, 92724, 92730, 92731, 92733, 92734, 92777, 92779, 92782, 92784, 92785, 92786, 92787, 92788, 92790, 92947, 92954, 92969, 92976, 92978, 92998, 93000, 93002, 93003, 93005, 93009, 93010, 93011, 93014, 93015, 93016, 93018, 93020, 93152, 93156, 93160, 93212, 93213, 93217, 93220, 93222, 93224, 93227, 93228, 93230, 93231, 93233, 93234, 93238, 93242, 93246, 93249, 93251, 93760, 93761, 93762, 93769, 93770, 93919, 93921, 93944, 94119, 94123, 94128, 94130, 94135, 94142, 94179, 94192, 94199, 94299, 94300, 94301, 94302, 94303, 94304, 94305, 94306, 94307, 94315, 94332, 94353, 94358, 94370, 94376, 94377, 94385, 94389, 94390, 94391, 94392, 94429, 94431, 94433, 94436, 94437, 94446, 94456, 94473, 94477, 94481, 94483, 94484, 94485, 94486, 94491, 94494, 94496, 94507, 95743, 96215, 96269, 96276, 96278, 96323, 96480, 96482, 96490, 96501, 96521, 96561, 96574, 96598, 96600, 96630, 96632, 96634, 96638, 96648, 96651, 96654, 96737, 96741, 97011, 97012, 97013, 97014, 97015, 97017, 97018, 97020, 97021, 97023, 97027, 97032, 97033, 97037, 97041, 97045, 97076, 97078, 97079, 97082, 97093, 97096, 97105, 97114, 97140, 97142, 97145, 97146, 97148, 97151, 97160, 98108, 98202, 98215, 98217, 98364, 123601, 123604, 123616, 123618, 123623, 123650, 7793, 7794, 7798, 7800, 7801, 7802, 7803, 7804, 7805, 8305, 8306, 8395, 8396, 8397, 8398, 8399, 8402, 64568, 79908, 86214, 86312, 86391, 86424, 86635, 87375, 88039, 88060, 90433, 91048, 91049, 91050, 91051, 91052, 91053, 91055, 91056, 91057, 91058, 91059, 91061, 91062, 91063, 91064, 91065, 91066, 91067, 91621, 91625, 91642, 91649, 92300, 92301, 92302, 92303, 92304, 92315, 92316, 92425, 92459, 92724, 92779, 92784, 92998, 93000, 93010, 93011, 93014, 93152, 93246, 94305, 94494, 96215, 98108, 98202, 98215, 98217, 9153, 10149, 10185, 51197, 51202, 54910, 55050, 55051, 55081, 55257, 79263, 79347, 80130, 84524, 84526, 84986, 85866, 86850, 86945, 86948, 86949, 86956, 86957, 86958, 86960, 86961, 86962, 86963, 86964, 86965, 86974, 86976, 86977, 86978, 86979, 86980, 87144, 87145, 87146, 87147, 87148, 87149, 87150, 87151, 87153, 87154, 87155, 87159, 87161, 87163, 87169, 87170, 87171, 87174, 87369, 87403, 89155, 90096, 90097, 90154, 90155, 90156, 90157, 90158, 90159, 90160, 90161, 90162, 90163, 90841, 90842, 90843, 90844, 90845, 90846, 90847, 90848, 90849, 90850, 90851, 90852, 90853, 90854, 90855, 90856, 90857, 90858, 90859, 90860, 91053, 91726, 91730, 91740, 91741, 92110, 92113, 92116, 92117, 92121, 92307, 92451, 94199, 94203, 94298, 94300, 94303, 94329, 94333, 94336, 94353, 94374, 94377, 94382, 94387, 94391, 94392, 94427, 94429, 94431, 94437, 94440, 94452, 94461, 94473, 94477, 94480, 94481, 94485, 94486, 94493, 94494, 94496, 105542, 105544, 105749, 105750, 123365, 123366, 123367, 123368, 123370, 123371, 123372, 123373, 123374, 123375, 9155, 55050, 84986, 85349, 85351, 90841, 90842, 90843, 90844, 90845, 90846, 90847, 90848, 90849, 90850, 90851, 90852, 90853, 90854, 90855, 90856, 90857, 90858, 90859, 90860, 92307, 92451, 94493, 92307, 94927, 82771, 94300, 105542, 80130, 84524, 84526, 84591, 85866, 87169, 87170, 87780, 94203, 94298, 94382, 94461, 105544, 10149, 10185, 10186, 10188, 10190, 51197, 84524, 84526, 90096, 90097, 91741, 94374, 94382, 94387, 94427, 94461, 94480, 91741, 94387, 91741, 55050, 84524, 84526, 91741, 94387, 94427, 94452, 94507, 123365, 123366, 123368, 123370, 84503, 84526, 90096, 94199, 105750, 123365, 123367, 123368, 123369, 123370, 123371, 123372, 123373, 123374, 123375, 10149, 10186, 10188, 10190, 51197, 51202, 55050, 84524, 84526, 86850, 86945, 90096, 90097, 90154, 90155, 90162, 92451, 94387, 123366, 79263, 84591, 92307, 105749, 79297, 79302, 90094, 90095, 96086, 84526, 94199, 94387, 97307, 105749, 86945, 86948, 86949, 86957, 86958, 86959, 86960, 86961, 86962, 86963, 86964, 86965, 86976, 86977, 86978, 86979, 86980, 87144, 87145, 87146, 87147, 87148, 87149, 87150, 87151, 87153, 87154, 87155, 87159, 87161, 87163, 87171, 87465, 90154, 90155, 90156, 90157, 90158, 90159, 90160, 90161, 90162, 90163, 94199, 85878, 87362, 97862, 87465, 90097, 8258, 9153, 9170, 9203, 9250, 9378, 9675, 9676, 46116, 49530, 55474, 79190, 79204, 79257, 79305, 79368, 79563, 79779, 79851, 79852, 79870, 82625, 82686, 82960, 82962, 82963, 84402, 84855, 84856, 84860, 84862, 84863, 84865, 84871, 84873, 84874, 84875, 84877, 84881, 85155, 85850, 86285, 86533, 87565, 87567, 87570, 87575, 87586, 87621, 87626, 87633, 88119, 88122, 88523, 88761, 88770, 90109, 90732, 90733, 90734, 90735, 90736, 90916, 91176, 91878, 91879, 91881, 91882, 91883, 91884, 91885, 91886, 91887, 91888, 91889, 91890, 91891, 91892, 92906, 92909, 92911, 92915, 92923, 92928, 92930, 92945, 92956, 92969, 93761, 93762, 93763, 93764, 93766, 93767, 93769, 93770, 93772, 93774, 93776, 93780, 93784, 93787, 93790, 93792, 93919, 93921, 93922, 93923, 93925, 93926, 93929, 93935, 93938, 93942, 93947, 93952, 93954, 93955, 93956, 93958, 93959, 93960, 93962, 93963, 94372, 94375, 94381, 94477, 94595, 95458, 96630, 96752, 96764, 96771, 96773, 96775, 96777, 96779, 96838, 96841, 97019, 97081, 97583, 97682, 98094, 98363, 9286, 9288, 9290, 9456, 9459, 79368, 82687, 91884, 79257, 79870, 87570, 87586, 87621, 87633, 91878, 92956, 92969, 94372, 96752, 96779, 96841, 9360, 9378, 9535, 82686, 82687, 87575, 91879, 91881, 91882, 91883, 91884, 91885, 91886, 91887, 91888, 91889, 92969, 93762, 93763, 93764, 93766, 93767, 93769, 94381, 95458, 8832, 9051, 46116, 53876, 64867, 87575, 88770, 88775, 91879, 91882, 91885, 91886, 91888, 91889, 92906, 92909, 92911, 92915, 92923, 92928, 92930, 92945, 96630, 85155, 86285, 87575, 82686, 87621, 87633, 88119, 88523, 91883, 93760, 93761, 93762, 93763, 93764, 93766, 93767, 93769, 93770, 93772, 93774, 93776, 93780, 93781, 93784, 93787, 93790, 93792, 93794, 93919, 93921, 93922, 93923, 93925, 93926, 93929, 93935, 93938, 93942, 93947, 93952, 93954, 93955, 93956, 93958, 93959, 93960, 93962, 93963, 94372, 9051, 46127, 49534, 82687, 87565, 87575, 88122, 88966, 90731, 90732, 90733, 90734, 90735, 90736, 90916, 91172, 98363, 9378, 87626, 87633, 91883, 46125, 88122, 53862, 79257, 87570, 87621, 88761, 88770, 91878, 92956, 92969, 96773, 96779, 91879, 8306, 8315, 8316, 8317, 8321, 8325, 8328, 8329, 8331, 8333, 8336, 8338, 8340, 8350, 8353, 8355, 8357, 8358, 8364, 8367, 8372, 8395, 8396, 8397, 8398, 8399, 8400, 8401, 8402, 8410, 8411, 8412, 8413, 8414, 8415, 8434, 8437, 8438, 8439, 8449, 8450, 8451, 8452, 8454, 8456, 8490, 8491, 8518, 8519, 8522, 8524, 8525, 8529, 8530, 8589, 8590, 8591, 8633, 8634, 8635, 8771, 8778, 8780, 8782, 8783, 8786, 8788, 8789, 8790, 8791, 8792, 8793, 8794, 8822, 8825, 8827, 8829, 8831, 8837, 8838, 9404, 9405, 9406, 9407, 9408, 9409, 9410, 9411, 9412, 64568, 64577, 82112, 82115, 82428, 82434, 83461, 84857, 84858, 84859, 84860, 86191, 86394, 86396, 86398, 86399, 86400, 86403, 86405, 86413, 86414, 86415, 86416, 86417, 86418, 86419, 86420, 86421, 86422, 86423, 86424, 86425, 86429, 86433, 86438, 86470, 86475, 86482, 86527, 88039, 88060, 88789, 88797, 89218, 90433, 90462, 91048, 91049, 91050, 91051, 91052, 91054, 91055, 91056, 91057, 91058, 91059, 91060, 91061, 91062, 91064, 91065, 91066, 91067, 91495, 91511, 91621, 91625, 91642, 91649, 92300, 92301, 92302, 92303, 92304, 92459, 92724, 92779, 92784, 92790, 92998, 93000, 93010, 93011, 93246, 94494, 8306, 8350, 8353, 8355, 8357, 8358, 8364, 8367, 8372, 8395, 8397, 8398, 8399, 8400, 8401, 8402, 8410, 8411, 8413, 8414, 8518, 8519, 8522, 8524, 8525, 8529, 8530, 8589, 8590, 8591, 8633, 8634, 8635, 8778, 8780, 8782, 8786, 8788, 8790, 8791, 8794, 8822, 8825, 8827, 8829, 8831, 8837, 82112, 82115, 88060, 90433, 90462, 91048, 91049, 91050, 91051, 91052, 91054, 91055, 91058, 91059, 91060, 91061, 91064, 91065, 91066, 91067, 91495, 91511, 91621, 91622, 91624, 91625, 91629, 91636, 91637, 91639, 91642, 91643, 91644, 91645, 91646, 91647, 91649, 91650, 91651, 92300, 92301, 92302, 92303, 92304, 92425, 92459, 92724, 92779, 92784, 92790, 92998, 93000, 93011, 93246, 94494, 8306, 8400, 8401, 8402, 8410, 8411, 8412, 8413, 8414, 8415, 8434, 8437, 8438, 8439, 8449, 8450, 8451, 8452, 8454, 8456, 8490, 8491, 8518, 8519, 8522, 8524, 8525, 8529, 8591, 8778, 8783, 64568, 92303, 8410, 8411, 8412, 8413, 8414, 8415, 8434, 8437, 8438, 8439, 8449, 8450, 8451, 8452, 8454, 8456, 8490, 8491, 8518, 8519, 8522, 8524, 8525, 8529, 8530, 8589, 8590, 8591, 8633, 8634, 8635, 8780, 8782, 8783, 8786, 8789, 8792, 8793, 8822, 8825, 8827, 8829, 8831, 8837, 8838, 9405, 9406, 9407, 9408, 9409, 9411, 9412, 82112, 83461, 86394, 86396, 86398, 86399, 86400, 86403, 86405, 86413, 86414, 86415, 86416, 86417, 86418, 86419, 86420, 86421, 86422, 86423, 86424, 86425, 86429, 86433, 86438, 86470, 86475, 86482, 92300, 92301, 92302, 92303, 92304, 8491, 8530, 8589, 8590, 8591, 8633, 8634, 8635, 8771, 82112, 90462, 91495, 8778, 8780, 8782, 8783, 8786, 8788, 8789, 8790, 8791, 8792, 8794, 8822, 8825, 8827, 8829, 8831, 8837, 8838, 9404, 9405, 9406, 9407, 9408, 9409, 9410, 9411, 9412, 82115, 86396, 86398, 86399, 86400, 86403, 86405, 86413, 86414, 86415, 86416, 86417, 86418, 86419, 86420, 86421, 86422, 86423, 86424, 86425, 86429, 86433, 86438, 86470, 86475, 86482, 88060, 90433, 91059, 91511, 92300, 92301, 92302, 92303, 92304) AND (`product_language` IS NULL AND `product_id` != 123659)) 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