Untitled query #17569

This query is marked as a draft This query has been published by Larske.
SQL

USE svwiki_p;

SELECT CONCAT('[[',REPLACE("_"," ",page_title),']]') AS sida, CONCAT('[[',REPLACE("_"," ",rd_title),']]') AS omdirigeras_till FROM redirect INNER JOIN page ON rd_from=page_id WHERE
rd_title LIKE "%(olika_betydelser)%"
ORDER BY page_title


/*
SELECT * FROM logging INNER JOIN actor ON log_actor=actor_id
WHERE actor_name = 'Lsjbot'
AND NOT log_type = 'move'
*/
/*
WHERE NOT log_type = 'upload'
AND NOT log_action = 'delete'
AND NOT log_type = 'block'
AND NOT log_type = 'protect'
AND NOT log_type = 'move'
AND NOT log_type = 'rights'
AND NOT log_type = 'newusers'
AND NOT log_type = 'renameusers'
AND NOT log_type = 'patrol'
AND NOT log_type = 'abusefilter'
AND NOT log_type = 'contentmodel'
AND NOT log_type = 'course'
AND NOT log_type = 'campus'
AND NOT log_type = 'create'
AND NOT log_type = 'delete'
AND NOT log_type = 'eparticle'
AND NOT log_type = 'import'
AND NOT log_type = 'institution'
AND NOT log_type = 'instructor'
AND NOT log_type = 'lock'
AND NOT log_type = 'managetags'
AND NOT log_type = 'massmessage'
AND NOT log_type = 'merge'
AND NOT log_type = 'online'
AND NOT log_type = 'renameuser'
AND NOT log_type = 'spamblacklist'
AND NOT log_type = 'student'
AND NOT log_type = 'tag'
AND NOT log_type = 'thanks'
AND NOT log_type = 'usermerge'
*/
LIMIT 100

/*
WHERE 
log_action = 'create'
AND log_namespace = 0
AND log_timestamp > '20150101000000'
AND log_timestamp < '20160101000000'
LIMIT 100

/*
SELECT actor_name, log_timestamp, log_title, log_params FROM logging INNER JOIN actor on log_actor=actor_id WHERE 
log_action = 'block'
AND log_timestamp > '20180101000000'
ORDER BY log_timestamp
*/

/*
SELECT log_type, SUBSTRING(log_timestamp,1,8) AS dag, COUNT(*) AS antal FROM logging INNER JOIN actor on log_actor=actor_id WHERE
log_timestamp >= '20191230000000' AND log_timestamp < '20210101000000'
AND (log_type = 'create' OR log_type = 'delete')
AND log_namespace = 0
GROUP BY log_type, dag
ORDER BY dag
*/

/*
SELECT log_type, log_timestamp, log_namespace, log_title, comment_text, actor_name  FROM logging INNER JOIN comment on log_comment_id = comment_id INNER JOIN actor on log_actor=actor_id WHERE
log_action = 'delete'
AND log_timestamp > '20190101000000'
AND comment_text LIKE '%patru%'
ORDER BY log_timestamp DESC
LIMIT 100
*/

/*
SELECT * FROM logging INNER JOIN actor ON actor_id = log_actor WHERE
*/
/*
SELECT actor_name, COUNT(*) AS antal FROM logging INNER JOIN actor ON actor_id = log_actor WHERE
log_timestamp > '20200605000000'
AND log_type = 'create'
AND log_namespace = 2
AND log_title NOT LIKE '%/%'
AND actor_name != REPLACE(log_title,'_',' ')
AND actor_user NOT LIKE ''
GROUP BY actor_name
ORDER BY antal DESC
*/
/*
SELECT actor_name, COUNT(*) AS antal FROM logging INNER JOIN actor ON log_actor=actor_id WHERE
log_timestamp > '20200101000000'
AND log_type = 'block'
GROUP BY actor_name
*/

/*
WHERE user_registration > '20201017000000'
*/

/*
SELECT * FROM ipblocks_restrictions INNER JOIN ipblocks ON ir_ipb_id = ipb_id INNER JOIN page ON ir_value = page_id 
INNER JOIN actor ON ipb_by_actor = actor_id INNER JOIN user on actor_user = user_id INNER JOIN comment ON ipb_reason_id = comment_id
*/

/*
SELECT log_action, COUNT(*) FROM logging WHERE 
log_timestamp>='20180101000000' 
AND log_timestamp<'20200901000000'
AND log_type = 'block'
GROUP BY log_action
*/

/*
SELECT SUBSTR(log_timestamp,1,8) AS dag, COUNT(*) AS antal FROM logging WHERE 
log_timestamp>'2017001010000'
AND log_type = 'block'
GROUP BY dag
ORDER BY dag
*/

/*
SELECT actor_name, COUNT(*) AS skapade_2020 FROM revision INNER JOIN page ON page_id = rev_page INNER JOIN actor ON actor_id = rev_actor WHERE
rev_timestamp >= '20200101000000' AND rev_timestamp < '20200901000000'
AND rev_parent_id = 0
AND page_namespace = 0
GROUP BY actor_name
*/

/*
SELECT actor_name, COUNT(*) AS antal_2011 FROM logging INNER JOIN actor on actor_id = log_actor WHERE 
log_timestamp >= '20110101000000' AND log_timestamp < '20120101000000'
AND log_type = 'delete'
AND log_namespace = 0
GROUP BY actor_name
*/

/*
SELECT * FROM page WHERE 
page_namespace = 14
AND page_title LIKE '%Vitryssland%'
*/

/*
SELECT page_title, COUNT(el_index) AS antal FROM externallinks INNER JOIN page on el_from=page_id WHERE 
el_index LIKE 'http://se.elephant.www%' OR el_index LIKE 'https://se.elephant.www%'
AND page_namespace = 0
GROUP BY page_title
ORDER BY antal DESC, page_title
*/

/*
SELECT rc_timestamp, rc_title, comment_text FROM recentchanges INNER JOIN comment ON rc_comment_id=comment_id WHERE
rc_actor = 356
AND comment_text LIKE '% tas bort %'
*/

/*
SELECT * FROM ipblocks INNER JOIN actor ON ipb_address = actor_name
WHERE ipb_timestamp > '20200420000000'
*/

/*
SELECT * FROM logging
WHERE log_timestamp>'20190101000000'
AND log_type='create'
AND log_namespace=0
*/

/*
SELECT rc_timestamp, rc_actor, rc_namespace, rc_title, rc_new, rc_ip, rc_old_len, rc_new_len FROM recentchanges WHERE
rc_type < 4
AND rc_source = 'mw.edit'
*/

/*
SELECT page_title AS Artikel FROM page LEFT JOIN categorylinks ON page_id=cl_from WHERE
cl_from IS NULL AND page_namespace = 0 AND page_is_redirect = 0
*/
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.
SQL

Checking query status...
