1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'poputrad_site.o.customers_state' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[select distinct op.products_id,o.customers_state,o.customers_country from orders o, orders_products op, products p where o.orders_id = op.orders_id and op.products_id = p.products_id and p.products_status = '1' group by products_id order by o.date_purchased desc limit 10]