Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
The Polish
.
Toggle Highlighting
SQL
USE plwiki_p; SELECT page_title#, el_to FROM page JOIN externallinks ON page.page_id = externallinks.el_from WHERE el_to IN( 'http://www.kadra.pl/index.php?dzial=his_rep&litera=A-B', 'http://www.kadra.pl/index.php?dzial=his_rep&litera=C-F', 'http://www.kadra.pl/index.php?dzial=his_rep&litera=G-J', 'http://www.kadra.pl/index.php?dzial=his_rep&litera=K', 'http://www.kadra.pl/index.php?dzial=his_rep&litera=L-M', 'http://www.kadra.pl/index.php?dzial=his_rep&litera=N-R', 'http://www.kadra.pl/index.php?dzial=his_rep&litera=S', 'http://www.kadra.pl/index.php?dzial=his_rep&litera=S-Z' ) AND page_namespace = 0 GROUP BY page_title#, el_to ORDER BY page_title#, el_to; ; SELECT el_to, COUNT(*) AS counting FROM page JOIN externallinks ON page.page_id = externallinks.el_from WHERE el_to LIKE 'http://www.cvk.gov.ua/pls/%' AND page_namespace = 0 GROUP BY el_to ORDER BY counting DESC, el_to;
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...