Graph links — credibility >= 5 pairs

Custom SQL query returning 1,463 rows (hide)

SELECT el.event_id_1, el.event_id_2, el.distance_km, el.days_apart, el.source_1, el.source_2
FROM event_links el
JOIN events e1 ON e1.id = el.event_id_1
JOIN events e2 ON e2.id = el.event_id_2
WHERE e1.credibility_score >= 5 AND e2.credibility_score >= 5
ORDER BY e1.credibility_score + e2.credibility_score DESC
LIMIT 3000

Edit SQL