Wer kennt Nike nicht? Gegründet wurde das Sportlabel 1972 in Oregon. Nachdem Nike anfangs keinen großen Anhang fand, mauserte sich das Label zu dem Sport Label überhaupt. Die Kultigen Schuhe aus den 70 ern und 80 ern wurden zu begehrten Sammelobjekten und Nike schafft es jedes Jahr neue kultige Modelle auf den Markt zu werfen. [... 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 = '41' and p2c.categories_id = '248' group by products_id order by limit 0, 100
[TEP STOP]