enwiki moves from ns0:, User:, or Draft: to Project:

Fork of enwiki moves from ns0:, User:, or Draft: to Project: by Train2104

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

https://en.wikipedia.org/w/index.php?title=Wikipedia:Request_a_query&diff=774087516&oldid=769213071

Postprocessed results available at [[en:w:User:Cryptic/query/16647]].

SQL

SELECT CONCAT('[[',
				(CASE log_namespace
					WHEN 0 THEN ''
                    WHEN 2 THEN 'User:'
					WHEN 3 THEN 'User talk:'
					WHEN 118 THEN 'Draft:'
					ELSE CONCAT('{{ns:', log_namespace, '}}:')
				END),
				log_title,
				']]') AS 'Moved from',
		log_params,
        CONCAT('[[User:', log_user_text, '|]]') AS 'Moved by',
        log_comment,
        log_timestamp
FROM logging_logindex
WHERE log_type = 'move'
	AND log_namespace IN (0,2,3,118)
	AND log_params RLIKE 'target";s:[0-9]+:"Wikipedia talk:'
    AND log_params NOT RLIKE 'target";s:[0-9]+:"Wikipedia talk:Articles for creation/'
ORDER BY log_timestamp DESC;

SQL

Checking query status...