2000's copyvio patrolling

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_userindex
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')
    AND rev_id NOT IN ('118356','118355','116936','526408','76544','65357','65164','101931','65165','124650','65356','646236','69115','686776','675198','2276
                       7159','22777800','59675','69353','754326','46662')
    AND rev_id!='22767159'
GROUP BY rev_id
ORDER BY page_title DESC;
SQL

Checking query status...
