Initial release

[websub-hub] / src / db / sqlite / sql / subscriptions-by-topic-id.sql

diff --git a/src/db/sqlite/sql/subscriptions-by-topic-id.sql b/src/db/sqlite/sql/subscriptions-by-topic-id.sql
new file mode 100644 (file)
index 0000000..e6fdd39
--- /dev/null
+++ b/src/db/sqlite/sql/subscriptions-by-topic-id.sql
@@ -0,0 +1,4 @@
+SELECT *
+FROM subscription
+WHERE topic_id = :topicId
+AND expires > strftime('%s', 'now')