1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'lacewigc_zc.o.customers_state' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in: [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 6]
|