3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'projectorsquare_db2024.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT
select distinct p.products_id, p.products_image,p.manufacturers_id, p.products_tax_class_id, p.products_price as products_price, pd.products_name from products p, products_description pd left join products_to_categories p2c using(products_id) left join categories c using(categories_id) where p.products_id = pd.products_id and c.parent_id = '179' and p.products_status = '1' and find_in_set('179', products_hide_from_groups) = 0 and find_in_set('179', categories_hide_from_groups) = 0 and pd.language_id = '1' order by p.products_date_added desc limit 9
[TEP STOP]
| |
U.A.E
Yemen
Iraq
Saudi Arabia
Kuwait
Bahrain
Qatar
India
Lebanon
Jordan
Libya
Egypt
Oman
.png "Charge & Sync Carts")
