A Database Error Occurred

Error Number: 1055

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

SELECT substr(cpvs,1,3) as cpv, COUNT(id) as ilosc FROM ( SELECT id, cpvs FROM ogloszenia_2013_01 WHERE cpvs NOT LIKE 'c2411%' AND cpvs LIKE '%c2411%' UNION ALL SELECT id, cpvs FROM ogloszenia_2013_02 WHERE cpvs NOT LIKE 'c2411%' AND cpvs LIKE '%c2411%' UNION ALL SELECT id, cpvs FROM ogloszenia_2013_03 WHERE cpvs NOT LIKE 'c2411%' AND cpvs LIKE '%c2411%' UNION ALL SELECT id, cpvs FROM ogloszenia_2013_04 WHERE cpvs NOT LIKE 'c2411%' AND cpvs LIKE '%c2411%' UNION ALL SELECT id, cpvs FROM ogloszenia_2013_05 WHERE cpvs NOT LIKE 'c2411%' AND cpvs LIKE '%c2411%' UNION ALL SELECT id, cpvs FROM ogloszenia_2013_06 WHERE cpvs NOT LIKE 'c2411%' AND cpvs LIKE '%c2411%' UNION ALL SELECT id, cpvs FROM ogloszenia_2013_07 WHERE cpvs NOT LIKE 'c2411%' AND cpvs LIKE '%c2411%' UNION ALL SELECT id, cpvs FROM ogloszenia_2013_08 WHERE cpvs NOT LIKE 'c2411%' AND cpvs LIKE '%c2411%' UNION ALL SELECT id, cpvs FROM ogloszenia_2013_09 WHERE cpvs NOT LIKE 'c2411%' AND cpvs LIKE '%c2411%' UNION ALL SELECT id, cpvs FROM ogloszenia_2013_10 WHERE cpvs NOT LIKE 'c2411%' AND cpvs LIKE '%c2411%' UNION ALL SELECT id, cpvs FROM ogloszenia_2013_11 WHERE cpvs NOT LIKE 'c2411%' AND cpvs LIKE '%c2411%' UNION ALL SELECT id, cpvs FROM ogloszenia_2013_12 WHERE cpvs NOT LIKE 'c2411%' AND cpvs LIKE '%c2411%') t GROUP BY substr(cpv,1,3)

Filename: models/Raporty_model.php

Line Number: 179