Style #S1382
Royce Aerocool Sports Bra
This product is currently not available for purchase.
The UK’s first wirefree, high-impact sports bra for G-K cup sizes. Aerocool is
an innovative sports bra designed to provide exceptional support for larger
cup sizes. The internal side sling holds boobs in place to minimise bounce
and movement and the optional racerback provides additional support.
- Designed to provide exceptional support
- Keeps breasts in place
- Cross back
Fabric Content: 77% POLYESTER, 16% NYLON, 7% ELASTANE
Royce Aerocool Sports Bra
We Recommend
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY p.products_ordered DESC LIMIT 2' at line 15
SELECT DISTINCT(p.products_id), p.products_model, p.manufacturers_id, p.products_url, p.products_reviews_average, p.products_reviews_count, p.products_price, p.products_final_sale, p.products_min_quantity, s.specials_new_products_price, pei.products_extra_image, pei.pei_width, pei.pei_height, m.manufacturers_name, m.manufacturers_url, m.manufacturers_image, pd.products_name, pd.products_description, psc.size_chart_file FROM products p LEFT JOIN specials s ON (s.products_id=p.products_id AND s.status=1) LEFT JOIN products_to_categories p2c ON (p.products_id=p2c.products_id) LEFT JOIN products_description pd ON (p.products_id=pd.products_id AND pd.language_id='1') LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_extra_images pei ON (p.default_images_id=pei.products_extra_images_id) LEFT JOIN products_size_chart psc ON (psc.products_size_chart_id=p.products_size_chart_id) WHERE p.products_status = '1' AND p.products_id NOT IN(18947) AND p.manufacturers_id = '198' AND p2c.categories_id IN () ORDER BY p.products_ordered DESC LIMIT 2
[TEP STOP]
SELECT DISTINCT(p.products_id), p.products_model, p.manufacturers_id, p.products_url, p.products_reviews_average, p.products_reviews_count, p.products_price, p.products_final_sale, p.products_min_quantity, s.specials_new_products_price, pei.products_extra_image, pei.pei_width, pei.pei_height, m.manufacturers_name, m.manufacturers_url, m.manufacturers_image, pd.products_name, pd.products_description, psc.size_chart_file FROM products p LEFT JOIN specials s ON (s.products_id=p.products_id AND s.status=1) LEFT JOIN products_to_categories p2c ON (p.products_id=p2c.products_id) LEFT JOIN products_description pd ON (p.products_id=pd.products_id AND pd.language_id='1') LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_extra_images pei ON (p.default_images_id=pei.products_extra_images_id) LEFT JOIN products_size_chart psc ON (psc.products_size_chart_id=p.products_size_chart_id) WHERE p.products_status = '1' AND p.products_id NOT IN(18947) AND p.manufacturers_id = '198' AND p2c.categories_id IN () ORDER BY p.products_ordered DESC LIMIT 2
[TEP STOP]