3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'amarr_dasdw.o.orders_id' which is not in SELECT list; this is incompatible with DISTINCT
in:
[SELECT distinct products_name,products_id,(SELECT products_image FROM products p where p.products_id=op.products_id) products_image,CONCAT(`customers_city`,' ',`customers_state`,' ',`customers_country`) lj FROM orders_products op,orders o WHERE o.orders_id = op.orders_id order by o.orders_id desc limit 1,20]