In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'scoadmin_fsb.x.id'; this is incompatible with sql_mode=only_full_group_by(No Description) sql: SELECT COUNT(p.id) FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0 AND o.percentagesaved > 0 AND o.price > 200 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) AND 1 = 1 ORDER BY p.salesrank DESC LIMIT 50