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://old.stat.gov.pl/gus/5840_11752_PLK_HTML.htm, http://old.stat.gov.pl/gus/5840_13211_PLK_HTML.htm ) AND page_namespace = 0 GROUP BY page_title#, el_to ORDER BY page_title#, el_to; ; /* http://old.stat.gov.pl/cps/rde/xbcr/gus/nsp2002_tabl4.xls http://old.stat.gov.pl/gus/5840_11752_PLK_HTML.htm http://old.stat.gov.pl/gus/5840_13211_PLK_HTML.htm http://old.stat.gov.pl/gus/5840_13647_PLK_HTML.htm http://old.stat.gov.pl/gus/5840_1487_PLK_HTML.htm http://old.stat.gov.pl/gus/5840_2176_PLK_HTML.htm http://old.stat.gov.pl/gus/5840_662_PLK_HTML.htm http://old.stat.gov.pl/gus/5840_rocznik_demograficzny_PLK_HTML.htm http://stat.gov.pl/obszary-tematyczne/ludnosc/ludnosc/stan-i-struktura-ludnosci-oraz-ruch-naturalny-w-przekroju-terytorialnym-w-2012-r-stan-w-dniu-31-xii-2012-r-,6,11.html http://statlibr.stat.gov.pl/exlibris/aleph/a18_1/apache_media/8A1T5G5GLVA1TN64N1VMXBVI16U2IK.pdf http://statlibr.stat.gov.pl/exlibris/aleph/a18_1/apache_media/B3LKS6SQT3M6EJQ2J6ELTQR3SXMS17.pdf http://www.stat.gov.pl/cps/rde/xbcr/gus/l_ludnosc_stan_struktura_31_12_2010.pdf http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_L_ludnosc_stan_struktura_30_06_2008.pdf http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_L_ludnosc_stan_struktura_30_06_2009.pdf http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_L_ludnosc_stan_struktura_30_06_2009.zip http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_l_ludnosc_stan_struktura_30_06_2010.pdf http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_L_ludnosc_stan_struktura_31_12_2008.pdf http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_l_ludnosc_stan_struktura_31_12_2009.pdf http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_l_ludnosc_stan_struktura_31_12_2010.pdf http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_L_powierzchnia_ludnosc_teryt_2010.pdf http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_L_powierzchnia_ludnosc_teryt_2011.pdf http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_ludnosc_stan_struktura_31_12_2007.zip http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_ludnosc_stan_struktura_teryt_1pol2006.zip http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_ludnosc_stan_struktura_teryt_2pol2006.zip http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_nsp2002_tabl4.xls http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_oz_maly_rocznik_statystyczny_2011.pdf http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_oz_wyzn_rel_stow_nar_i_etn_w_pol_2006-2008.pdf http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_powierzchnia_ludnosc_teryt_2008.pdf http://www.stat.gov.pl/cps/rde/xbcr/gus/PUBL_rocznik_gospodarki_morskiej_2007.pdf http://www.stat.gov.pl/gus/45_655_PLK_HTML.htm http://www.stat.gov.pl/gus/45_737_PLK_HTML.htm http://www.stat.gov.pl/gus/45_908_PLK_HTML.htm SELECT el_to, COUNT(*) AS counting FROM page JOIN externallinks ON page.page_id = externallinks.el_from WHERE el_to LIKE '%http://portal.statistics.sk/files/Sekcie/sek_600/Demografia/Obyvatelstvo/tabulky/pocet_obyvatelov/poc_obyv_obce_2010.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...