A Database Error Occurred

Error Number: 1055

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

SELECT idBrand, COUNT(*) AS `numrows`, CEIL( (SELECT `ProductPrice` / `Value` * (SELECT `Value` FROM `currencies` WHERE `Currency` = 'eur') FROM `currencies` WHERE `Currency` = `ProductCurrency`) ) ProductPriceConv FROM (`products`) INNER JOIN `brand` ON `idBrand` = `Brand_idBrand` LEFT JOIN `models` ON `idModels` = `Models_idModels` INNER JOIN `users_groups` ON `users_groups`.`user_id` = `products`.`users_id` WHERE `ProductMaterial` = '1' AND `idModels` = '41' AND `ProductStatus` = 1 GROUP BY `idBrand` ORDER BY `numrows` desc LIMIT 5

Filename: /var/www/html_models/clock_model.php

Line Number: 151