A Database Error Occurred

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 = '1875' 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