[QUERY TIME: 0.011168956756592s] SELECT `content`.*, (SELECT `content_views`.`views` FROM `content_views` WHERE `content_views`.`content` = `content`.`record_num`) AS `views`, TIMESTAMPDIFF(MINUTE,`content`.`encoded_date`,'2009-04-05 02:53:06') AS hourdiff, (SELECT `images`.`filename` FROM `images` WHERE `images`.`record_num` = `content`.`thumbnail`) AS `thumbfile` FROM `content` WHERE `content`.`enabled` = 1 ORDER BY (`views`/hourdiff) DESC LIMIT 80,20