Style #YD5-036
Yummie Farrah Signature Logo Rib Bralette
With its soft Yummie logo elastic underband and removable pads, this nylon ribbed bralette is perfect for everyday wear.
- Super soft elastic underband with debossed logo
- Soft nylon rib fabric
- Removable pads for versatility
- Wire free and closure free
- Wide smoothing back and sides
- Step in or pull over head
Yummie Farrah Signature Logo Rib Bralette
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(14519) AND p.manufacturers_id = '79' 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(14519) AND p.manufacturers_id = '79' AND p2c.categories_id IN () ORDER BY p.products_ordered DESC LIMIT 2
[TEP STOP]