Untitled query #16646

SQL

SELECT CONCAT('[[',
				(CASE log_namespace
					WHEN 0 THEN ''
					WHEN 2 THEN 'User:'
					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,
        logging_logindex.*
FROM logging_logindex
WHERE log_type = 'move'
	AND log_namespace IN (0, 2, 118) -- source in :, User:, or Draft:
	AND log_params RLIKE 'target";s:[0-9]+:"Wikipedia:' -- destination in Wikipedia:
ORDER BY log_timestamp DESC
LIMIT 5;
SQL

Checking query status...
