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
Base
.
Toggle Highlighting
SQL
select concat("[[user:", p.page_title, "|]]") as local_userpage, concat("[[m:user:", p.page_title, "|]]") as global_userpage from mkwiki_p.page p join mkwiki_p.revision r on p.page_namespace = 2 and p.page_is_redirect = 0 and r.rev_id = p.page_latest and r.rev_sha1 in ( -- variations of "new user" template, -- see [[:mk:Корисник:BaseBot/DB queries/Userpages with the same content]] "9gjapc8j4pyngy0d91nro36cp9tn90l", "5310sl7cmxv6uf7uax80z29gom1lp0d", "mz50m5qkhhb34ap5bb35hleqmmfps4a", "8wofacywi0uziyq9h97pzc3j0v9250g", "dzabxfjf08kd3o0htau9sdkydl66yzc", "dyzbtzne3jtn8n061qqyvfe6gib9jmy", "791991fuquqvlep709dgd708thay8om", "djyko25f1s9p0bcg6zydzn5ctwmxaeu", "bbptvtdqi7bezju520md30bgm0yhei6", "7b3bjoix3fb3qq5av7yki4jjhky8e87", "k3d14f7g0i9bb8xey0y98ymd7nx5e7k", "h83rxc5u2f03qwkff3uz40bqu481v6p", "2byx0tegsvll3fso1s5ogwcfau6we1l" ) join metawiki_p.page mp on mp.page_namespace = 2 and mp.page_is_redirect = 0 and mp.page_title = p.page_title order by p.page_title asc
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...