[QUERY TIME: 0.011521100997925s] SELECT `content`.*, (SELECT `content_views`.`views` FROM `content_views` WHERE `content_views`.`content` = `content`.`record_num`) AS `views`, TIMESTAMPDIFF(MINUTE,`content`.`encoded_date`,'2009-05-31 03:52:30') 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 140,20