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...
