|
Your basket
0 items value: 0,00 EUR 
| ||||||||||||||||||||||||
|
| ||||||||||||||||||||||||
select distinct p.products_image, pd.products_name, pd.products_description, p.products_id, p.products_price, p.products_retail_price, p.products_tax_class_id from products_description pd, products p, products_to_categories p2c, categories c WHERE p2c.categories_id = '143' and p.products_id != '1000' and p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and c.categories_status='1' and p.products_status='1' and pd.products_id=p.products_id and language_id = '1' ORDER BY p.products_date_added DESC limit 5 [TEP STOP] |
