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','7
6544','2217563','8716604','52305','14560905','115486','57507','72994','748073','52977','11746542','69114','751812','11527713','63090',
'562115','636459','14291072','22738321','667679','45499','76646','63515','11462053','127554','14082696','3076139','56191','754324','46
                       662','247296')
GROUP BY rev_id
ORDER BY page_title DESC;

SQL

Checking query status...