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 FROM page JOIN externallinks ON page.page_id = externallinks.el_from WHERE el_to LIKE '%http://stat.gov.pl/download/gfx/portalinformacyjny/pl/defaultaktualnosci/5468/6/12/1/ludnosc.pdf%' #WHERE el_to LIKE '%google.%/url?%' AND page_namespace = 0 GROUP BY page_title ORDER BY page_title; SELECT el_to, COUNT(*) AS counting FROM page JOIN externallinks ON page.page_id = externallinks.el_from WHERE el_to LIKE '%http://stat.gov.pl/download/gfx/portalinformacyjny/pl/defaultaktualnosci/5468/6/12/1/ludnosc.pdf%' #WHERE el_to LIKE '%.google.%/url?%' 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...