display history of topic updates on topic details page

[websub-hub] / src / db / sqlite / sql / topic-publish-history.sql

--
SELECT
        (strftime('%s', 'now') - content_updated) / 86400 AS days_ago,
        count(*) AS content_updates
FROM topic_content_history
WHERE
        days_ago <= :daysAgo
AND
        (:topicId IS NULL OR topic_id = :topicId)
GROUP BY days_ago
ORDER BY days_ago
;