1 -- meta data with subscriber count
6 extract(epoch
FROM lease_seconds_preferred
) AS lease_seconds_preferred
,
7 extract(epoch
FROM lease_seconds_min
) AS lease_seconds_min
,
8 extract(epoch
FROM lease_seconds_max
) AS lease_seconds_max
,
9 t.publisher_validation_url
,
10 t.content_hash_algorithm
,
14 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
> now()) s
ON t.
id = s.topic_id
23 ORDER BY subscribers
DESC, t.created
DESC