Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
trwiki:Top 1000 editors by article count
by
Evolutionoftheuniverse
This query is marked as a draft
This query has been published
by
Evolutionoftheuniverse
.
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
Toggle Highlighting
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') 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;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...