projects
/
websub-hub
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
b6e9c21da388e240087ae243e949883a0533d620
[websub-hub]
/
topic-get-by-url.sql
1
-- excluding content field
2
SELECT
3
id
,
4
created
,
5
url
,
6
lease_seconds_preferred
,
7
lease_seconds_min
,
8
lease_seconds_max
,
9
publisher_validation_url
,
10
content_hash_algorithm
,
11
is_active
,
12
is_deleted
,
13
last_publish
,
14
content_fetch_next_attempt
,
15
content_fetch_attempts_since_success
,
16
content_updated
,
17
content_hash
,
18
content_type
,
19
http_etag
,
20
http_last_modified
21
FROM
topic
22
WHERE
url
=
:topicUrl