Speed test - Quarry

SQL

WITH Olympedia AS (SELECT el_from, page_title
  FROM externallinks
  JOIN page ON page_id = el_from
  WHERE page_namespace = 0
  AND (el_index LIKE 'https://org.olympedia%'
       OR el_index LIKE 'http://org.olympedia%')
  GROUP BY el_from)

SELECT Olympedia.page_title, actor_name, rev_timestamp
FROM Olympedia
LEFT JOIN (SELECT Olympedia.el_from, Olympedia.page_title
      FROM externallinks
      JOIN Olympedia ON Olympedia.el_from = externallinks.el_from
      WHERE el_index NOT LIKE 'https://org.olympedia%'
      AND el_index NOT LIKE 'http://org.olympedia%'
      GROUP BY Olympedia.el_from)
AS NotOlympedia ON Olympedia.el_from = NotOlympedia.el_from
LEFT JOIN revision ON rev_page = Olympedia.el_from AND rev_parent_id = 0
LEFT JOIN actor_revision ON actor_id = rev_actor
WHERE NotOlympedia.el_from IS NULL
SQL

Checking query status...
