USE plwiki_p;

​

SELECT r.rev_timestamp, p.page_title, l.el_index AS detector, l.el_to AS url, CONCAT('[[Dyskusja:',p.page_title,']]') AS title

FROM page p, externallinks l, revision r

WHERE

 p.page_namespace = 1 AND l.el_from = p.page_id AND

 l.el_index REGEXP '\\/\\/([a-z]{5,})\.' AND l.el_index NOT LIKE '%org.archive.web%'

 and r.rev_id = p.page_latest

ORDER BY r.rev_timestamp DESC

;