SQL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'kotemot_db.cp.producer_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /home/admin/kotemot.com/public_html/plugins/dao/classes/modules/catalog/mapper/Catalog.mapper.class.php line 0
Array
(
[code] => 1055
[message] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'kotemot_db.cp.producer_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[query] => SELECT
cp.*,
count(cp.producer_name) as count
FROM
prefix_catalog_producer as cp,
prefix_catalog_item as i
WHERE
i.producer_id=cp.producer_id
AND
i.item_publish=1
AND
i.catalog_id=5
GROUP BY
cp.producer_name
ORDER BY
count desc
LIMIT 0, 70
[context] => /home/admin/kotemot.com/public_html/plugins/dao/classes/modules/catalog/mapper/Catalog.mapper.class.php line 0
)