3065 - Expression #2 of ORDER BY clause is not in SELECT list, references column 'jangoz_store.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT
from products p,
p.products_status = '1'
and f.status = '1'
and p.products_id = f.products_id
and pd.products_id = f.products_id
and pd.language_id = '1'
order by rand(),p.products_date_added DESC, pd.products_name limit 6