User:Narutolovehinata5/SPP BLP

Overview

This report lists semi-protected biographies of living persons with a duration of at least a week from the time of running. It was generated on the toolserver by TB (talk) 19:14, 11 January 2013 (UTC)

Report

• Chaz_Bono
• Perizaad_Zorabian
• John_Prescott
• Johnny_Weir
• Catherine_Crier
• Steven_McGeady
• Dennis_Hood
• Illeana_Douglas
• Yelena_Dembo
• Disappearance_of_Madeleine_McCann
• Alison_Weir
• Michael_Schindhelm
• Andrew_Peach
• Carl_Hewitt
• Keith_Henson
• Lester_Coleman
• Kimber_James
• Daniel_Tosh
• Justin_Bieber
• Solomon_Trujillo
• Chester_Yorton
• Lila_Rose
• Fashion_Bomb
• Bettina_Wulff
• Christopher_Monckton,_3rd_Viscount_Monckton_of_Brenchley

Regenerating

-- Identify all pages that are semi-protected either indefinitely or for at least 7 days
CREATE VIEW spp AS
SELECT page_id, page_namespace, page_title
FROM enwiki_p.page
INNER JOIN enwiki_p.page_restrictions ON pr_page = page_id
WHERE pr_type = 'edit'
AND   pr_level = 'autoconfirmed'
AND  ( pr_expiry = 'infinity'
OR     str_to_date( pr_expiry, '%Y%m%d%H%i%s' ) > date_add( now(), interval 7 day ) );

-- Semi-protected biographies of living persons
SELECT concat( '*[[', page_title, ']]' )
FROM spp
INNER JOIN enwiki_p.categorylinks ON cl_from = page_id
WHERE cl_to = 'Biography_articles_of_living_people'
AND   page_namespace = 1;