Burgundy LMSHMDK Pantaloncini Donna Pantaloncini A Vita Alta Casual da Donna A Vita Alta in Chiffon con Frange A Vita Alta 44JcYuBn14mL

3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'offee_cvbzx.o.orders_id' which is not in SELECT list; this is incompatible with DISTINCT
[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]