Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dronesdi_drones.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     = '1914'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC