Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Uhai
.
From main space, draft space, or user space. Users with 500 or more edits are excluded from the results. To do: -Look at removing entries that redirect into project space
Toggle Highlighting
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') 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
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...