A Database Error Occurred

Error Number: 3065

Expression #1 of ORDER BY clause is not in SELECT list, references column 'mirabhay_mbc.lev.sticky' which is not in SELECT list; this is incompatible with DISTINCT

SELECT DISTINCT `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` = '7' AND `lev`.`id` IN ('15', '16', '17') AND `l`.`status` = '1' AND `u`.`status` = '2' ORDER BY `lev`.`sticky` desc, `l`.`creation_date` desc, `l`.`order_date` desc