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
Edgars2007
.
Can be some other Wikipedia's stats, if I need them
Toggle Highlighting
SQL
USE lvwiki_p; SELECT Concat('* [[Veidne:',tl_title,']] - '), COUNT(tl_title) FROM templatelinks where tl_namespace=10 and tl_title like "%Infokaste%" and tl_title like "%infokaste%"# and tl_from_namespace=0 #and tl_title not like "VietasKarte/dati%" and tl_title not like "%/doc" group by tl_title order by COUNT(tl_title) desc /* ruwiki: tl_title not like "Statistical/%" frwiki: tl_title not like "Infobox/%" and tl_title not like "Country_data/%" and tl_title not like "Carte/données%" eswiki and tl_title not like "Zona_de_pruebas/%" and tl_title not like "%/doc" plwiki and tl_title not like "Wikidane/%" and tl_title not like "Kalendarium/%" and tl_title not like "%/opis" lvwiki and tl_title not like "VietasKarte/dati%" */
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...