SELECT boards.id AS board_id, boards.name AS board_name, COUNT(posts.id) AS board_new_posts FROM boards INNER JOIN threads ON (boards.id = threads.board_id) INNER JOIN posts ON (threads.id = posts.thread_id) WHERE posts.hidden = FALSE AND posts.pub_date > last_visit GROUP BY boards.id, boards.name ORDER BY boards.name
- hanabira 0.6.1320- + wakaba + futallaby + futaba -