In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column ''; this is incompatible with sql_mode=only_full_group_by(No Description) sql: SELECT DISTINCT(p.parent_id), p.*, o.price + o.amountsaved as originalprice FROM products p, productoffers o WHERE = o.product_id AND enabled = 1 AND hidden = 0 AND offers > 0 AND IN (SELECT FROM productoffers x WHERE x.product_id = HAVING MIN(x.price)) ORDER BY salesrank ASC LIMIT 4