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 p.*, o.price + o.amountsaved as originalprice FROM products p JOIN productoffers as o ON = o.product_id JOIN products_categories AS pc ON WHERE p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0 AND offers > 0 AND o.percentagesaved > 0 AND o.price > 200 AND IN (SELECT FROM productoffers x WHERE x.product_id = HAVING MIN(x.price)) AND pc.category_id IN (SELECT id FROM categories WHERE bestsellerspecialoffers =1) ORDER BY o.percentagesaved DESC, p.salesrank DESC LIMIT 3