投票主题
返回给定用户的当前和已归档投票的主题和创建日期
-- [params]
-- user_id :user
SELECT tvv.topic_id,
tvv.created_at::date AS "投票日期",
CASE WHEN tvv.archive = TRUE THEN '已归档' ELSE '当前' END AS "当前?"
FROM topic_voting_votes tvv
WHERE tvv.user_id = :user
ORDER BY tvv.archive, tvv.created_at