2000's copyvio patrolling

https://quarry.wmflabs.org/run/506360/output/0/html
https://quarry.wmflabs.org/run/506415/output/0/html
https://quarry.wmflabs.org/run/506416/output/0/html

SQL

USE trwiki_p;
SELECT  CONCAT("[[",page_title,"]]") as Madde, CONCAT("[",el_to,"]") as Link, CONCAT("[[Özel:Fark/",rev_id,"]]") as "Sürüm"
FROM revision
JOIN page ON rev_page = page_id
join externallinks
    on (page_id=el_from)
WHERE page_namespace = 1
    AND rev_actor=3947
	AND rev_id NOT IN (66917,98216,19688444,118354,194554,11743525,46715,46722,12801811,46249,7382471,116934,173872,218704,76544,2217563,8716604,52305,14
560905,115486,57507,72994,748073,52977,11746542,69114,751812,11527713,63090,562115,636459,14291072,22738321,667679,45499,76646,63515,1
                           1462053,127554,14082696,3076139,56191,754324,46662,247296)
ORDER BY page_title DESC;

SQL

Checking query status...