Products
Filter Cartridge & Accessories->
Industrial Filter->
  Water Dispenser Cooler
  Industrial Housing Filter
  Commercial RO System
  Vending Machine
  Water Treatment System
Home Appliance
Residential->
Outdoor Filter->
Categories Industrial Filter
Water Dispenser Cooler
Water Dispenser Cooler
Industrial Housing Filter
Industrial Housing Filter
Commercial RO System
Commercial RO System
Vending Machine
Vending Machine
Water Treatment System
Water Treatment System
New Products For October
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'aeioustu_osmon.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 = '49' 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 18

[TEP STOP]