In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'holsterg_store.x.id'; this is incompatible with sql_mode=only_full_group_by(No Description) sql: SELECT p.id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND parent_id = 0 AND hidden = 0 AND offers > 0 AND p.salesrank <= 4000 AND (p.price >= 1400 AND p.price <= 1000000) AND (SELECT COUNT(pc.id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (26,35,36,32,37,38,39)) > 0 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.salesrank ASC LIMIT 6