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
Erell
.
Toggle Highlighting
SQL
#USE dewiki_p; use commonswiki_p; #SELECT pl_title, pl_namespace, page_namespace FROM pagelinks INNER JOIN page ON pl_from=page_id WHERE page_title = 'Wolgast' #show tables; #describe image; Select img_name, # if (locate("Date=",img_description) >0, MID(img_description,locate("Date=",img_description)+5,10),"") REGEXP_SUBSTR( img_description,"Date[ ]=") #img_timestamp, img_user_text from image #REGEXP_SUBSTR( ,"Date=%|") as Datum #where img_media_type='BITMAP' and img_major_mime = 'image' and where img_user=120707; #and img_description like "%{{de|1=|%" limit 100; #select * from user where user_name = "Erell"; #describe imagelinks; #describe page_props; #select distinct pp_propname from page_props limit 100; #select pp_value, pp_page from page_props where pp_propname = "templatedata" limit 100;
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...