Der Göteborger Daniel Mänd gründete 2001 das Label ELVINE unter dem Leitspruch „Sophisticated Clothes for unsophisticated behaviour“ unter dem Vorsatz, seine streetlastigen Klamotten mit einem intelligenten Image von gängigen Stereotypen zu lösen. Also haltet die Augen und Ohren offen und seit gespannt….. [... 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 = '168' and p2c.categories_id in (245, 246, 210, 211, 212, 302, 355, 356, 388) group by products_id order by limit 0, 100
[TEP STOP]