Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'multcop_store.o.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by(No Description) sql: SELECT	n.displayname, o.name
				FROM	productoptionnames	n,
						productoptions		o,
						products			p
				WHERE	n.originalname	= o.name
				  AND	o.product_id	= p.id
				  AND	p.parent_id		= '1177'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC