In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'easycash_bbs.x.id'; 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 p.id = o.product_id
AND enabled = 1
AND hidden = 0
AND offers > 0
AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price))
ORDER BY salesrank ASC LIMIT 6
Fatal error: Call to a member function getFullArray() on a non-object in /home/easycash/public_html/beautybodyshop.co.uk/library/products.php on line 3440