A PHP Error was encountered

Severity: Notice

Message: Trying to get property of non-object

Filename: controllers/site.php

Line Number: 1003

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /var/www/html/vck.nl/system/libraries/Exceptions.php:166)

Filename: codeigniter/Common.php

Line Number: 356

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by merken.naam' at line 1

select distinct merken.Naam as Merk, count(distinct producten.ProductID) as Cnt from producten join soorten on producten.soortid = soorten.soortid join categorieen on producten.categorieid = categorieen.categorieid join merken on producten.merkid = merken.merkid where producten.soortid= group by merken.naam