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 LIKE '%http://bazhum.icm.edu.pl/bazhum/download/bwmeta1.element.dl-catalog-d9f053c1-bb9e-4cbb-86e2-513872c80670/full-text/match1056679335026204900.pdf%' #'%.google.%/url?%'#'%.google.%/url?&url=%' 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://bazhum.icm.edu.pl/bazhum/download/bwmeta1.element.dl-catalog-d9f053c1-bb9e-4cbb-86e2-513872c80670/full-text/match1056679335026204900.pdf%' 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...