A Database Error Occurred

Error Number: 1054

Unknown column 'r.rating' in 'order clause'

SELECT `l`.`id` FROM (`listings` as l) LEFT JOIN `levels` as lev ON `lev`.`id`=`l`.`level_id` LEFT JOIN `users` as u ON `l`.`owner_id`=`u`.`id` WHERE `l`.`id` IN (SELECT `l`.`id` FROM (`listings` as l) LEFT JOIN `levels` as lev ON `lev`.`id`=`l`.`level_id` LEFT JOIN `types` as t ON `t`.`id`=`lev`.`type_id` LEFT JOIN `users` as u ON `l`.`owner_id`=`u`.`id` LEFT JOIN `listings_in_categories` as lic ON `l`.`id`=`lic`.`listing_id` WHERE `lic`.`category_id` IN ('26') AND `t`.`categories_type` = 'global' AND `l`.`status` = '1' AND `u`.`status` = '2') ORDER BY `r`.`rating` desc, `l`.`creation_date` desc