Els rols que s'han escrit a Tadaima

rols.sql

SELECT DATE_FORMAT(FROM_UNIXTIME(post_time), '%d/%m/%Y %T'), username, forum_name, topic_title, (
	SELECT COUNT(topic_id)
    FROM posts as b
    WHERE topic_id = posts.topic_id AND post_time <= posts.post_time
), CAST(CONCAT('https://tadaima.cat/topic', posts.topic_id, '.html#p', posts.post_id) AS CHAR) AS url
FROM posts
LEFT JOIN users on poster_id = user_id
LEFT JOIN topics on posts.topic_id = topics.topic_id
LEFT JOIN forums on topics.forum_id = forums.forum_id
WHERE posts.forum_id IN (39, 40, 41, 42)
ORDER BY post_time ASC