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