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
Larske
.
Toggle Highlighting
SQL
USE svwiki_p; DESCRIBE geo_tags; /* SELECT * FROM user WHERE user_id = 649138 */ /* SELECT * FROM logging WHERE log_user=0 AND log_action='create' AND (log_title LIKE '%Ogrodzeni%' OR log_title LIKE '%Sztachety%') AND log_namespace=0 AND LENGTH(log_title)>0 ORDER BY LENGTH(log_title) */ /* SELECT * FROM categorylinks INNER JOIN page on cl_from=page_id WHERE cl_to = page_title AND page_namespace = 14 */ /* SELECT * FROM page WHERE page_id = 1441071 */ /* SELECT * FROM pagelinks WHERE pl_title LIKE '%Upper_Bavaria%' OR pl_title LIKE '%Lower_Bavaria%' OR pl_title LIKE '%Upper_Palatinate%' OR pl_title LIKE '%Upper_Franconia%' OR pl_title LIKE '%Swabia' OR pl_title LIKE '%Middle_Franconia%' OR pl_title LIKE '%Lower_Franconia%' /* /* SELECT rc_timestamp AS Tid, CONCAT('[[',REPLACE(rc_title,'_',' '),']]') AS Artikel, CONCAT('align="right"|{{nts|',page_len,'}}') AS Storlek, GROUP_CONCAT(cl_to) AS Kategori, rc_user_text AS Skapare FROM recentchanges INNER JOIN categorylinks ON rc_cur_id=cl_from INNER JOIN page on cl_from=page_id WHERE rc_new=1 AND rc_namespace=0 AND cl_to LIKE '%chackspelare%' GROUP BY rc_timestamp, rc_title, rc_user_text ORDER BY rc_timestamp */ /* SELECT rc_user_text AS användare, COUNT(*) AS antal_red, SUM(IF(rc_new_len>rc_old_len+19,1,0)) AS antal_plusred, SUM(IF(rc_new_len>rc_old_len+19,rc_new_len-rc_old_len,0)) AS volym_plusred, SUM(IF(ABS(rc_new_len-rc_old_len)<20,1,0)) AS antal_putsred, SUM(IF(ABS(rc_new_len-rc_old_len)<20,ABS(rc_new_len-rc_old_len),0)) AS volym_putsred, SUM(IF(rc_new_len<rc_old_len-19,1,0)) AS antal_minusred, SUM(IF(rc_new_len<rc_old_len-19,rc_old_len-rc_new_len,0)) AS volym_minusred FROM recentchanges WHERE rc_title='Artikelnomineringar' AND rc_namespace=4 AND rc_type<5 GROUP BY användare ORDER BY volym_plusred DESC */ /* SELECT tl_title, COUNT(page_id) AS antal FROM templatelinks INNER JOIN page on tl_from=page_id WHERE tl_title LIKE 'Illustrationsbehov%' AND tl_namespace=10 AND page_namespace=0 GROUP BY tl_title ORDER BY tl_title */ /* SELECT page_title, rev_timestamp, rev_user_text FROM categorylinks INNER JOIN page ON cl_from=page_id INNER JOIN revision on page_id=rev_page WHERE cl_to = 'Mallar_för_illustrationsbehov' AND rev_parent_id=0 ORDER BY rev_timestamp */ /* SELECT * FROM recentchanges WHERE rc_user_text LIKE 'Larske%' */ /* SELECT el_to FROM externallinks WHERE el_to LIKE '%www.iucnredlist%' AND LENGTH(el_to)>27 */ /* SELECT NOW(); SELECT COUNT(*) FROM externallinks WHERE el_to LIKE '%www.iucnredlist%'; SELECT NOW(); SELECT COUNT(*) FROM externallinks WHERE el_to LIKE '%oldredlist%'; SELECT NOW(); */ /* SELECT rev_user_text, rev_timestamp FROM revision WHERE rev_comment LIKE '%WP:HG%' * /* SELECT log_action,log_title, log_user, user_name, log_timestamp, log_params FROM logging INNER JOIN user ON log_user=user_id WHERE #log_action = 'block' log_timestamp > '20160701000000' #AND log_timestamp < '20180201000000' #AND log_title = '213.204.35.226' AND log_params LIKE '%06-15%' #AND log_title LIKE '%:%' #AND LENGTH(log_title)>30 #AND SUBSTR(log_title,5,1)=':' #log_timestamp > '20180518000000' ORDER BY log_timestamp DESC #GROUP BY log_title #ORDER BY log_title */
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...