Pages mistakenly moved to project space

SQL

SELECT CONCAT('https://en.wikipedia.org/w/index.php?title=Wikipedia:', p.page_title, CASE WHEN p.page_is_redirect THEN '&redirect=no' ELSE '' END) AS 'Page',
CASE WHEN p.page_is_redirect THEN 'Yes' ELSE 'No' END AS 'Is redirect?',
-- u.user_name AS 'Moving user',
-- u.user_editcount 'Edit count',
TIMESTAMP(MAX(l.log_timestamp)) AS 'Moved timestamp'
FROM logging_logindex l
INNER JOIN page p ON p.page_namespace = 4 AND p.page_title = REPLACE(SUBSTRING(l.log_params, LOCATE('Wikipedia:', l.log_params) + 10, LOCATE('"', l.log_params, LOCATE('Wikipedia:', l.log_params)) - LOCATE('Wikipedia:', l.log_params) - 10), ' ', '_')
INNER JOIN actor_user a ON l.log_actor = a.actor_id
LEFT JOIN user u ON a.actor_user = u.user_id
WHERE l.log_type = 'move'
AND l.log_namespace IN (0, 2, 118)
AND l.log_params LIKE '%Wikipedia:%'
AND (u.user_editcount < 500 OR u.user_editcount IS NULL)
AND p.page_title NOT LIKE '%Meetup%'
AND p.page_title NOT LIKE '%Long-term_Abuse%'
AND p.page_title NOT LIKE '%Wikiproject%'
AND p.page_title NOT LIKE '%Wikipedia%'
GROUP BY CONCAT('https://en.wikipedia.org/w/index.php?title=Wikipedia:', p.page_title, CASE WHEN p.page_is_redirect THEN '&redirect=no' ELSE '' END), p.page_is_redirect
ORDER BY MAX(l.log_timestamp) DESC
SQL

Checking query status...
