deutsch englisch



























 Additional information 


3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'db1010397-marlija.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 , p.delivery_time_id 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 (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