Top » Catalog » Wine

Wine

Promo
Promo
Sparkling
Sparkling
France
France
Spain
Spain
Italy
Italy
New Zealand
New Zealand
Portugal
Portugal
Switzerland
Switzerland
Germany
Germany
Greece
Greece
Chili
Chili
Argentina
Argentina
South Africa
South Africa
Australia
Australia
California
California

3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'db1001888_shop.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd, products_to_categories p2c, categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '23' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9

[TEP STOP]