1
SELECT DISTINCT rc.id AS revocation_candidate_id,
2
rc.certificate_der,
3
rc.issuer_id,
4
srr.sent_at,
5
rpt.publication_time,
6
oh.revocation_timestamp,
7
(rpt.publication_time - oh.revocation_timestamp) AS publication_delay,
8
(rpt.publication_time - srr.sent_at) AS time_to_effective_revocation
9
FROM (((revocation_candidates rc
10
JOIN ocsp_history oh ON ((rc.id = oh.revocation_candidate_id)))
11
JOIN successful_revocation_requests srr ON ((srr.id = rc.revocation_request_id)))
12
JOIN revocation_publication_time rpt ON ((rpt.revocation_candidate_id = rc.id)))
13
WHERE (oh.revocation_timestamp IS NOT NULL);