| 0.0015 | SELECT L.list_id, COUNT(DISTINCT(JTL.title_id)) AS total, title, prefix, timestamp
FROM `ml_lists` `L`
LEFT JOIN `ml_junction_titles_lists` `JTL` ON `L`.`list_id` = `JTL`.`list_id`
GROUP BY `L`.`list_id`
ORDER BY `timestamp` DESC
LIMIT 30, 10 ?>
|