Database Error

A Database Error Occurred

Error Number: 1055

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ortodonzia.regions.provincia' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT regions.sigla, regions.provincia, laboratori.coords, COUNT( laboratori.id ) AS count FROM laboratori LEFT JOIN regions ON laboratori.prov = regions.sigla GROUP BY prov ORDER BY count DESC LIMIT 30

Filename: /var/virtual/ortodonzia/htdocs/models/query.php

Line Number: 67