The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
#use at your own risk
#no warranty implied or given
#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)
