1 -- meta data with subscriber count
6 t.lease_seconds_preferred
,
9 t.publisher_validation_url
,
10 t.content_hash_algorithm
,
14 t.content_fetch_next_attempt
,
15 t.content_fetch_attempts_since_success
,
19 COUNT (s.
id) AS subscribers
21 LEFT JOIN (SELECT id, topic_id
FROM subscription
WHERE expires
> strftime('%s', 'now')) s
ON t.
id = s.topic_id
23 ORDER BY subscribers
DESC, t.created
DESC