|Shop By Material
||Shop By Gender
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'rebelcol_rebelsto.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_status = '1'
and p.products_id = pd.products_id
and p.products_id = p2c.products_id
and pd.language_id = '16'
and p2c.categories_id = '274'
order by p.products_date_added DESC limit 0, 68