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` WHERE `t`.`id` = '1' AND `l`.`status` = '1' AND `u`.`status` = '2') ORDER BY `r`.`rating` desc, `l`.`creation_date` desc