3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'shop_.p.items_date_added' which is not in SELECT list; this is incompatible with DISTINCT
select distinct p.items_id, p.items_picture, p.items_tax_class_id, p.items_price, p.items_model from items p, items_to_categories p2c, categories c where p.items_status=1 and p.items_id = p2c.items_id and c.categories_id = p2c.categories_id and c.categories_status=1 AND (p.items_picture != 'alle/nopic.gif' AND p.items_picture != '') AND (to_days(items_date_available_end) IS NULL OR (to_days(items_date_available_end) IS NOT NULL AND to_days(now()) <= to_days(items_date_available_end))) order by p.items_date_added desc limit 10
[TEP STOP]
|
