Seit 1991 sorgt das Label ROXY für einen einzigartigen Beach und Sportswear Lifestyle nur für uns Mädels. Mit den bunten Prints und tollen, angesagten Schnitten ist Frau in jeder Lebenslage topgestylt. ROXY IS NATURALLY BEAUTIFUL, FUN AND ALIVE... [... weitere Informationen]
select p.products_image, p.products_date_added, pd.products_name, pd.products_name_clean, p.products_id, p.manufacturers_id from products p join products_description pd using (products_id) join products_to_stores p2s using (products_id) join products_to_categories p2c using (products_id) join categories c using (categories_id) join manufacturers m using (manufacturers_id) left join specials s using (products_id) where pd.language_id = '2' and products_quantity > 0 and products_image != '' and products_status and c.categories_status and p2s.store_id = '1' and m.manufacturers_id = '44' and p2c.categories_id = '269' group by products_id order by limit 0, 100
[TEP STOP]