Fatal error: Uncaught Exception: Error: Unknown column 'r2.clinic_id' in 'group statement'<br />Error No: 1054<br />SELECT DISTINCT *, cd.name AS name, c.image, (SELECT ct.name FROM clinic_type ct WHERE ct.clinic_type_id = c.clinic_type_id AND ct.language_id = '1') AS clinic_type, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.item_id = c.clinic_id AND r1.status = '1' AND type = 'clinic' GROUP BY r1.item_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.item_id = c.clinic_id AND r2.status = '1' AND type = 'clinic' GROUP BY r2.clinic_id) AS reviews FROM clinic c LEFT JOIN clinic_description cd ON (c.clinic_id = cd.clinic_id) WHERE c.clinic_id = '94' AND cd.language_id = '1' AND c.status = '1' AND c.city_id = '4' in /home/jomo/lik.ua/www/system/library/db/mysqli.php:40 Stack trace: #0 /home/jomo/lik.ua/www/system/library/db.php(24): DB\MySQLi->query('SELECT DISTINCT...', Array) #1 /home/jomo/lik.ua/www/catalog/model/clinic/clinic.php(7): DB->query('SELECT DISTINCT...') #2 /home/jomo/lik.ua/www/catalog/m in /home/jomo/lik.ua/www/system/library/db/mysqli.php on line 40