Wikipedia:Subpages to be moved/How to update


 * 1) use at your own risk
 * 2) no warranty implied or given
 * 3) please improve.

DROP TABLE IF EXISTS slashes;

CREATE TABLE slashes (UNIQUE KEY `cur_id` (`cur_id`)) SELECT cur_title, cur_id FROM cur WHERE cur_is_redirect=0 AND cur_title LIKE '%/%' AND cur_namespace=0 LIMIT 1000;

DELETE FROM slashes USING slashes, links WHERE cur_id=l_to AND l_from LIKE 'Wikipedia:Articles_with_slashes_in_title';

SELECT CONCAT('#',REPLACE (cur_title, '_', ' '),'') AS new_slash_titles FROM slashes ORDER BY Lower(cur_title)