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