Sonderangebot

0 -

select cd.*, cd.categories_id, cd.categories_name, s.stores_url, p.products_tax_class_id, p.products_id, pd.products_name, pd.products_head_title_tag, pd.products_head_keywords_tag , p.products_price, p.products_image FROM products p, products_description pd, products_to_categories p2c, categories_to_stores c2s, stores s, categories_description cd WHERE c2s.stores_id= AND p2c.categories_id = cd.categories_id AND cd.language_id=2 AND c2s.categories_id=p2c.categories_id AND p.products_id = p2c.products_id AND p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '2' and s.stores_id=c2s.stores_id order by p.products_ordered desc limit 1

[TEP STOP]