- Quarry

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 '%WikiProject%'
AND p.page_title NOT LIKE '%Wikipedia%'
AND p.page_title NOT LIKE '%Articles_for_creation%'
AND p.page_title NOT LIKE '%Articles_for_deletion%'
AND p.page_title NOT LIKE 'Notability%'
AND p.page_title NOT LIKE 'GLAM%'
AND p.page_title NOT LIKE 'Article_Incubator%'
AND p.page_title NOT IN ('DJ', 'Short_popular_vital_articles', 'Sign_up', 'Hypocritic_Oath', 'Education', 'Eleventy-billion_pool_(1)', 'WikiBee', 'Princeton_University_Edit-a-thon_Three', 'Authority_control_integration_project', 'WikiGap_2.0_in_Sudan', 'SWASTHA/Methodology', 'Pages_with_neutrality_problems', 'Deletion_Reform', 'STEM', 'Healthcare_science', 'MEETUP/Lincoln,_MA', 'Art_and_Feminism_@SAAM', 'Gun_use', 'CRUK_Women_in_Cancer_Research_Editathon', 'Workshop/DGCU_Workshop_2', 'WikiConference_/_San_Diego_/_Indigenous_People\'s_Day_2016', 'The_Great_Society_Congress', 'University_of_Dayton_Libraries/Edit-a-thon_1', 'Special_notability_guideline_RFC:Sports', 'LMU_Library_Edit-a-thon_2019', '2ndGAFDEW', 'WiR/Global_Systems_Institute', 'Society_for_Experimental_Biology_Editathons_2023')
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...
