Error Number: 1054
Unknown column 'a.other_columns_to_group_by' in 'group statement'
SELECT a.*, cities.city, cities.state, cities.county, ac.advisor_url,ac.category_id, (SELECT AVG(rating) FROM advisors_feedbacks WHERE advisor_id = a.advisor_id) as avg_ratings FROM advisors as a INNER JOIN advisor_cities as ac ON a.advisor_id = ac.advisor_id INNER JOIN cities ON ac.city_id = cities.city_id AND cities.county_id = '872' GROUP BY ac.advisor_id, a.advisor_id, a.first_name, a.last_name, a.other_columns_to_group_by ORDER BY a.first_name, a.last_name;
Filename: /www/wwwroot/inkozi.com/models/advisor_model.php
Line Number: 513