Wikipedia:People by year/Reports/Multiple cats/SQL

DROP TABLE IF EXISTS temp_botcleancats;

CREATE TABLE temp_botcleancats SELECT p_id, p_title, cur_text, 0 AS oc FROM temp_peopleyr, cur   # see People by year WHERE p_id=cur_id LIMIT 100000;

ALTER TABLE temp_botcleancats ADD KEY (p_id);

Update temp_botcleancats SET oc=1 WHERE cur_text LIKE '%[[Category:_____births%' AND (LENGTH(cur_text) - LENGTH(REPLACE(REPLACE(cur_text, 'births]', ), 'births|', )))/7 >1;

Update temp_botcleancats SET oc=1 WHERE cur_text LIKE '%[[Category:_____deaths%' AND (LENGTH(cur_text) - LENGTH(REPLACE(REPLACE(cur_text, 'deaths]', ), 'deaths|', )))/7 >1;

SELECT CONCAT('#', p_title, '') INTO OUTFILE 'wp_multiplecats.txt' FROM temp_botcleancats WHERE oc <> 0