Jump to content

Wikipedia:List of lists/uncategorized/How to update

From Wikipedia, the free encyclopedia

DROP TABLE IF EXISTS temp_lists;

CREATE TABLE temp_lists
SELECT CONCAT('#[[',cur_title,'|',REPLACE(REPLACE(cur_title,'List_of_',''),'_',' '), ']]') AS List_of_lists, cur_title, cur_id
FROM `cur`
WHERE ( cur_title LIKE 'List_of%' 
     OR cur_title LIKE 'Table_of%' 
     OR cur_title LIKE 'Lists_of%' )
AND cur_namespace=0
AND cur_is_redirect=0
ORDER BY Lower(cur_title)
LIMIT 100000;

DELETE 
FROM temp_lists
USING temp_lists, categorylinks
WHERE temp_lists.cur_id=cl_from
AND cl_to LIKE 'Lists%';


DELETE 
FROM temp_lists
USING temp_lists, categorylinks
WHERE temp_lists.cur_id=cl_from
AND ( 
cl_to = 'Episode_lists'		OR 
cl_to = 'Lines_of_succession'	OR 
cl_to = 'Timelines'		OR 
cl_to = 'Topic_lists'		OR 
cl_to = '%timelines'		OR 
cl_to = 'Regional_bird_lists'	OR 
cl_to = 'List_of_pieces');


DELETE 
FROM temp_lists
USING temp_lists, categorylinks
WHERE temp_lists.cur_id=cl_from
AND cl_to LIKE 'Lists%';

SELECT List_of_lists
INTO OUTFILE 'wp_uncategorizedlists.txt'       #change this to your drive/path/filename
FROM temp_lists
LIMIT 10000;