Voci a cui potrebbe mancare il template Bio

SQL

USE itwiki_p;
SELECT page_title
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_id NOT IN			
  (SELECT DISTINCT cl_from
   FROM categorylinks, pagelinks
   WHERE cl_to = pl_title
   AND pl_namespace = 14
   AND pl_from = 4195411)
AND page_id IN
(SELECT cl_from
FROM categorylinks
 WHERE cl_to LIKE 'Nati\_%'
 OR cl_to LIKE 'Giocatori\_di\_%'
 OR cl_to LIKE 'Alpinisti\_%'
 OR cl_to LIKE 'Apneisti\_%'
 OR cl_to LIKE 'Arcieri\_%'
 OR cl_to LIKE 'Arrampicatori\_%'
 OR cl_to LIKE 'Atleti\_%'
 OR cl_to LIKE 'Base_jumper\_%'
 OR cl_to LIKE 'Bobbisti\_%'
 OR cl_to LIKE 'Boccisti\_%'
 OR cl_to LIKE 'Professionisti\_di\_%'
 OR cl_to LIKE 'Calciatori\_%'
 OR cl_to LIKE 'Calciatrici\_%'
 OR cl_to LIKE 'Canoisti\_%'
 OR cl_to LIKE 'Canottieri\_%'
 OR cl_to LIKE 'Cestisti\_%'
 OR cl_to LIKE 'Ciclisti\_%'
 OR cl_to LIKE 'Copiloti\_di\_rally\_%'
 OR cl_to LIKE 'Crickettisti\_%'
 OR cl_to LIKE 'Culturisti\_%'
 OR cl_to LIKE 'Deltaplanisti\_%'
 OR cl_to LIKE 'Driver_ippici\_%'
 OR cl_to LIKE 'Fantini\_%'
 OR cl_to LIKE 'Ginnasti\_%'
 OR cl_to LIKE 'Golfisti\_%'
 OR cl_to LIKE 'Hockeisti\_%'
 OR cl_to LIKE 'Indoor_rowers\_%'
 OR cl_to LIKE 'Nuotatori\_%'
 OR cl_to LIKE 'Orientisti\_%'
 OR cl_to LIKE 'Pallamanisti\_%'
 OR cl_to LIKE 'Pallanuotisti\_%'
 OR cl_to LIKE 'Pallavolisti\_%'
 OR cl_to LIKE 'Pallonisti\_%'
 OR cl_to LIKE 'Paracadutisti\_%'
 OR cl_to LIKE 'Pattinatori\_%'
 OR cl_to LIKE 'Pentatleti\_%'
 OR cl_to LIKE 'Piloti\_%'
 OR cl_to LIKE 'Powerlifter\_%'
 OR cl_to LIKE 'Pugili\_%'
 OR cl_to LIKE 'Rugbisti\_%'
 OR cl_to LIKE 'Schermidori\_%'
 OR cl_to LIKE 'Sciatori\_%'
 OR cl_to LIKE 'Shootfighter\_%'
 OR cl_to LIKE 'Skater\_%'
 OR cl_to LIKE 'Skeletonisti\_%'
 OR cl_to LIKE 'Slittinisti\_%'
 OR cl_to LIKE 'Snowboarder\_%'
 OR cl_to LIKE 'Sollevatori\_%'
 OR cl_to LIKE 'Speedcuber\_%'
 OR cl_to LIKE 'Surfisti\_%'
 OR cl_to LIKE 'Tennistavolisti\_%'
 OR cl_to LIKE 'Tennisti\_%'
 OR cl_to LIKE 'Tiratori\_%'
 OR cl_to LIKE 'Triatleti\_%'
 OR cl_to LIKE 'Tuffatori\_%'
 OR cl_to LIKE 'Velisti\_%')
 AND page_id NOT IN
(SELECT cl_from
FROM categorylinks
 WHERE cl_to LIKE '%immaginari')
AND page_id NOT IN 
	(SELECT tl_from
    FROM templatelinks
	WHERE tl_namespace = 10
	AND tl_title IN ('Bio'));
SQL

Checking query status...
