Where's the bug?

Question

http://www.neighborrow.com is currently displaying this error:

Warning (512): SQL Error: 1054: Unknown column 'User.rating' in 'order clause' [CORE/cake/libs/model/datasources/dbo_source.php, line 527]

Where's the error in this query?

SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, 
`User`.`password`, `User`.`phone`, `User`.`address`, `User`.`city`, `User`.`zip`, 
`User`.`region`, `User`.`verified`, `User`.`residence_id`, `User`.`rating_id`, 
`User`.`facebook_id`, `Residence`.`id`, `Residence`.`residence` FROM `users` AS `User` 
LEFT JOIN `residences` AS `Residence` ON (`User`.`residence_id` = `Residence`.`id`)  
WHERE `User`.`first_name` IS NOT NULL   ORDER BY `User`.`rating` DESC  LIMIT 5 

Answer 1

You don't have the column "rating" in your "User" table.

The "error" is at:

User::get_top() - APP/models/user.php, line 134

according to your site, at least that's where it's called from.