A topic for testing previews
This is a reply to a post
SELECT tag.topic_id,
MAX(p.created_at) AS reltime$Last_Post
FROM topic_allowed_groups tag
LEFT JOIN groups g ON g.id = tag.group_id
JOIN posts p ON p.topic_id = tag.topic_id
JOIN topics t ON t.id = tag.topic_id
WHERE g.name = 'sales'
AND t.deleted_at ISNULL
GROUP BY tag.topic_id
ORDER BY MAX(p.created_at) DESC
This is a reply to see what the reviewable looks like.