Fix in cb_erreur() to print the payment name in the error mail.

[platal.git] / upgrade / 1.1.4 / 15_deceased.sql

UPDATE profiles SET deathdate = '2009-12-30' WHERE pid = '40567';
UPDATE profiles SET deathdate = '2009-05-09' WHERE pid = '27332';
UPDATE profiles SET deathdate = '2010-01-01' WHERE pid = '27967';
UPDATE profiles SET deathdate = '2011-06-14' WHERE pid = '29729';
UPDATE profiles SET deathdate = '2011-05-21' WHERE pid = '33273';
UPDATE profiles SET deathdate = '2010-12-17' WHERE pid = '27450';
UPDATE profiles SET deathdate = '2007-10-06' WHERE pid = '28697';
UPDATE profiles SET deathdate = '2010-12-18' WHERE pid = '28905';
UPDATE profiles SET deathdate = '2011-02-20' WHERE pid = '30350';
UPDATE profiles SET deathdate = '2009-04-11' WHERE pid = '31008';
UPDATE profiles SET deathdate = '2010-10-10' WHERE pid = '31375';
UPDATE profiles SET deathdate = '2010-11-13' WHERE pid = '31322';
UPDATE profiles SET deathdate = '2003-03-29' WHERE pid = '31396';
UPDATE profiles SET deathdate = '2006-05-31' WHERE pid = '31627';
UPDATE profiles SET deathdate = '2006-06-27' WHERE pid = '40619';
UPDATE profiles SET deathdate = '2007-11-18' WHERE pid = '31861';
UPDATE profiles SET deathdate = '2010-02-04' WHERE pid = '33187';
UPDATE profiles SET deathdate = '2011-06-23' WHERE pid = '27914';
UPDATE profiles SET deathdate = '2010-01-18' WHERE pid = '28029';
UPDATE profiles SET deathdate = '2007-11-05' WHERE pid = '29261';
UPDATE profiles SET deathdate = '2010-11-21' WHERE pid = '29579';
UPDATE profiles SET deathdate = '2009-03-31' WHERE pid = '30986';
UPDATE profiles SET deathdate = '2007-11-24' WHERE pid = '27361';
UPDATE profiles SET deathdate = '2009-04-14' WHERE pid = '28209';
UPDATE profiles SET deathdate = '2011-06-06' WHERE pid = '28224';
UPDATE profiles SET deathdate = '2009-08-07' WHERE pid = '30868';
UPDATE profiles SET deathdate = '2007-07-08' WHERE pid = '31016';
UPDATE profiles SET deathdate = '2011-03-18' WHERE pid = '31772';
UPDATE profiles SET deathdate = '2008-01-22' WHERE pid = '32548';
UPDATE profiles SET deathdate = '1979-09-02' WHERE pid = '32820';
UPDATE profiles SET deathdate = '2010-03-21' WHERE pid = '27582';
UPDATE profiles SET deathdate = '2011-01-22' WHERE pid = '27587';
UPDATE profiles SET deathdate = '2007-12-17' WHERE pid = '28552';
UPDATE profiles SET deathdate = '2010-07-01' WHERE pid = '19620';
UPDATE profiles SET deathdate = '2010-06-05' WHERE pid = '28878';
UPDATE profiles SET deathdate = '2010-11-27' WHERE pid = '28917';
UPDATE profiles SET deathdate = '2011-06-23' WHERE pid = '28984';
UPDATE profiles SET deathdate = '2008-12-26' WHERE pid = '29364';
UPDATE profiles SET deathdate = '2009-07-20' WHERE pid = '29382';
UPDATE profiles SET deathdate = '2004-04-24' WHERE pid = '30579';
UPDATE profiles SET deathdate = '2010-04-26' WHERE pid = '33144';
UPDATE profiles SET deathdate = '2010-10-30' WHERE pid = '31034';
UPDATE profiles SET deathdate = '2010-04-27' WHERE pid = '31082';
UPDATE profiles SET deathdate = '2005-07-08' WHERE pid = '27298';
UPDATE profiles SET deathdate = '2008-12-13' WHERE pid = '27463';
UPDATE profiles SET deathdate = '2011-01-20' WHERE pid = '27693';
UPDATE profiles SET deathdate = '2007-04-25' WHERE pid = '28007';
UPDATE profiles SET deathdate = '2009-09-23' WHERE pid = '28112';
UPDATE profiles SET deathdate = '2008-08-24' WHERE pid = '28644';
UPDATE profiles SET deathdate = '2011-06-23' WHERE pid = '28688';
UPDATE profiles SET deathdate = '2011-10-23' WHERE pid = '28867';
UPDATE profiles SET deathdate = '2011-02-03' WHERE pid = '29547';
UPDATE profiles SET deathdate = '2008-11-21' WHERE pid = '29816';
UPDATE profiles SET deathdate = '2010-04-29' WHERE pid = '30645';
UPDATE profiles SET deathdate = '2010-12-14' WHERE pid = '30966';
UPDATE profiles SET deathdate = '1999-04-07' WHERE pid = '32592';
UPDATE profiles SET deathdate = '2011-09-09' WHERE pid = '33027';
UPDATE profiles SET deathdate = '2010-02-05' WHERE pid = '33305';
UPDATE profiles SET deathdate = '2011-01-21' WHERE pid = '27060';
UPDATE profiles SET deathdate = '2010-11-26' WHERE pid = '27084';
UPDATE profiles SET deathdate = '2010-06-28' WHERE pid = '27421';
UPDATE profiles SET deathdate = '2005-02-04' WHERE pid = '28636';
UPDATE profiles SET deathdate = '2009-04-02' WHERE pid = '29108';
UPDATE profiles SET deathdate = '2011-09-24' WHERE pid = '30107';
UPDATE profiles SET deathdate = '2008-05-04' WHERE pid = '31002';
UPDATE profiles SET deathdate = '2009-08-11' WHERE pid = '31342';
UPDATE profiles SET deathdate = '2007-12-15' WHERE pid = '31517';
UPDATE profiles SET deathdate = '2011-01-21' WHERE pid = '32101';
UPDATE profiles SET deathdate = '2010-12-18' WHERE pid = '32450';
UPDATE profiles SET deathdate = '2009-09-08' WHERE pid = '32486';
UPDATE profiles SET deathdate = '2011-05-26' WHERE pid = '32635';
UPDATE profiles SET deathdate = '2010-05-07' WHERE pid = '32778';
UPDATE profiles SET deathdate = '2009-05-01' WHERE pid = '32932';
UPDATE profiles SET deathdate = '1992-12-11' WHERE pid = '33104';
UPDATE profiles SET deathdate = '2010-04-27' WHERE pid = '33158';
UPDATE profiles SET deathdate = '2011-10-08' WHERE pid = '33189';
UPDATE profiles SET deathdate = '2011-02-23' WHERE pid = '33215';
UPDATE profiles SET deathdate = '2010-01-18' WHERE pid = '27324';
UPDATE profiles SET deathdate = '2010-02-20' WHERE pid = '28190';
UPDATE profiles SET deathdate = '2008-10-06' WHERE pid = '28365';
UPDATE profiles SET deathdate = '2010-07-23' WHERE pid = '22565';
UPDATE profiles SET deathdate = '2009-03-11' WHERE pid = '29051';
UPDATE profiles SET deathdate = '2010-01-27' WHERE pid = '29202';
UPDATE profiles SET deathdate = '2011-08-05' WHERE pid = '29538';
UPDATE profiles SET deathdate = '2010-03-04' WHERE pid = '29558';
UPDATE profiles SET deathdate = '2009-11-13' WHERE pid = '29619';
UPDATE profiles SET deathdate = '2010-04-21' WHERE pid = '29923';
UPDATE profiles SET deathdate = '2011-01-10' WHERE pid = '30026';
UPDATE profiles SET deathdate = '2009-09-23' WHERE pid = '30145';
UPDATE profiles SET deathdate = '2011-06-05' WHERE pid = '30688';
UPDATE profiles SET deathdate = '2010-09-10' WHERE pid = '30698';
UPDATE profiles SET deathdate = '2007-11-23' WHERE pid = '31106';
UPDATE profiles SET deathdate = '2011-01-22' WHERE pid = '31487';
UPDATE profiles SET deathdate = '2010-06-03' WHERE pid = '31784';
UPDATE profiles SET deathdate = '2009-12-29' WHERE pid = '32078';
UPDATE profiles SET deathdate = '2007-10-27' WHERE pid = '32320';
UPDATE profiles SET deathdate = '2009-11-30' WHERE pid = '32692';
UPDATE profiles SET deathdate = '2009-10-16' WHERE pid = '33190';
UPDATE profiles SET deathdate = '2011-05-17' WHERE pid = '27270';
UPDATE profiles SET deathdate = '2009-10-02' WHERE pid = '27393';
UPDATE profiles SET deathdate = '2011-10-01' WHERE pid = '28059';
UPDATE profiles SET deathdate = '2010-12-13' WHERE pid = '28149';
UPDATE profiles SET deathdate = '2007-10-09' WHERE pid = '28151';
UPDATE profiles SET deathdate = '2010-12-22' WHERE pid = '28435';
UPDATE profiles SET deathdate = '2005-12-06' WHERE pid = '29034';
UPDATE profiles SET deathdate = '2010-07-27' WHERE pid = '29341';
UPDATE profiles SET deathdate = '2009-10-28' WHERE pid = '29460';
UPDATE profiles SET deathdate = '2007-10-11' WHERE pid = '29567';
UPDATE profiles SET deathdate = '2010-05-10' WHERE pid = '29844';
UPDATE profiles SET deathdate = '2011-03-15' WHERE pid = '29918';
UPDATE profiles SET deathdate = '2009-11-25' WHERE pid = '30364';
UPDATE profiles SET deathdate = '2007-10-30' WHERE pid = '30668';
UPDATE profiles SET deathdate = '2007-10-09' WHERE pid = '30761';
UPDATE profiles SET deathdate = '2007-10-07' WHERE pid = '31159';
UPDATE profiles SET deathdate = '2009-11-08' WHERE pid = '31877';
UPDATE profiles SET deathdate = '2010-06-01' WHERE pid = '19986';
UPDATE profiles SET deathdate = '2011-01-08' WHERE pid = '25361';
UPDATE profiles SET deathdate = '2010-11-10' WHERE pid = '32383';
UPDATE profiles SET deathdate = '2009-07-22' WHERE pid = '32530';
UPDATE profiles SET deathdate = '2009-09-06' WHERE pid = '32580';
UPDATE profiles SET deathdate = '2011-05-28' WHERE pid = '32633';
UPDATE profiles SET deathdate = '2007-09-23' WHERE pid = '32908';
UPDATE profiles SET deathdate = '2009-04-29' WHERE pid = '33275';
UPDATE profiles SET deathdate = '2009-10-25' WHERE pid = '27182';
UPDATE profiles SET deathdate = '2009-06-07' WHERE pid = '27379';
UPDATE profiles SET deathdate = '2011-05-18' WHERE pid = '27828';
UPDATE profiles SET deathdate = '2009-07-11' WHERE pid = '28027';
UPDATE profiles SET deathdate = '2009-06-29' WHERE pid = '28600';
UPDATE profiles SET deathdate = '2011-04-28' WHERE pid = '28930';
UPDATE profiles SET deathdate = '2011-10-25' WHERE pid = '29013';
UPDATE profiles SET deathdate = '2011-07-18' WHERE pid = '29372';
UPDATE profiles SET deathdate = '2010-12-06' WHERE pid = '22499';
UPDATE profiles SET deathdate = '2011-10-06' WHERE pid = '29722';
UPDATE profiles SET deathdate = '2009-05-23' WHERE pid = '30568';
UPDATE profiles SET deathdate = '2007-11-05' WHERE pid = '31218';
UPDATE profiles SET deathdate = '2011-04-16' WHERE pid = '31701';
UPDATE profiles SET deathdate = '2009-04-03' WHERE pid = '32089';
UPDATE profiles SET deathdate = '2009-11-13' WHERE pid = '32124';
UPDATE profiles SET deathdate = '2009-10-28' WHERE pid = '32356';
UPDATE profiles SET deathdate = '2007-10-16' WHERE pid = '32453';
UPDATE profiles SET deathdate = '2010-12-18' WHERE pid = '32853';
UPDATE profiles SET deathdate = '2007-11-19' WHERE pid = '32999';
UPDATE profiles SET deathdate = '2009-03-28' WHERE pid = '33126';
UPDATE profiles SET deathdate = '2011-07-22' WHERE pid = '27067';
UPDATE profiles SET deathdate = '2010-09-16' WHERE pid = '27216';
UPDATE profiles SET deathdate = '2011-03-03' WHERE pid = '27826';
UPDATE profiles SET deathdate = '2010-03-06' WHERE pid = '28040';
UPDATE profiles SET deathdate = '2010-04-28' WHERE pid = '28195';
UPDATE profiles SET deathdate = '2010-08-19' WHERE pid = '28592';
UPDATE profiles SET deathdate = '2011-07-04' WHERE pid = '28783';
UPDATE profiles SET deathdate = '2010-07-01' WHERE pid = '29306';
UPDATE profiles SET deathdate = '2009-10-21' WHERE pid = '29793';
UPDATE profiles SET deathdate = '2010-01-09' WHERE pid = '30161';
UPDATE profiles SET deathdate = '2009-11-30' WHERE pid = '30363';
UPDATE profiles SET deathdate = '2010-11-15' WHERE pid = '30756';
UPDATE profiles SET deathdate = '2011-09-27' WHERE pid = '30863';
UPDATE profiles SET deathdate = '2009-08-19' WHERE pid = '30888';
UPDATE profiles SET deathdate = '2010-05-17' WHERE pid = '31074';
UPDATE profiles SET deathdate = '2011-09-17' WHERE pid = '31127';
UPDATE profiles SET deathdate = '2011-01-04' WHERE pid = '31236';
UPDATE profiles SET deathdate = '2011-02-04' WHERE pid = '31340';
UPDATE profiles SET deathdate = '2009-12-05' WHERE pid = '31508';
UPDATE profiles SET deathdate = '2009-03-23' WHERE pid = '31530';
UPDATE profiles SET deathdate = '2011-01-27' WHERE pid = '31984';
UPDATE profiles SET deathdate = '2010-07-15' WHERE pid = '32082';
UPDATE profiles SET deathdate = '2009-04-27' WHERE pid = '32112';
UPDATE profiles SET deathdate = '2010-07-26' WHERE pid = '32407';
UPDATE profiles SET deathdate = '2007-09-28' WHERE pid = '32886';
UPDATE profiles SET deathdate = '2009-10-11' WHERE pid = '27358';
UPDATE profiles SET deathdate = '2011-02-15' WHERE pid = '27763';
UPDATE profiles SET deathdate = '2009-05-26' WHERE pid = '27851';
UPDATE profiles SET deathdate = '2009-04-17' WHERE pid = '27932';
UPDATE profiles SET deathdate = '2009-12-11' WHERE pid = '28299';
UPDATE profiles SET deathdate = '2010-03-18' WHERE pid = '28363';
UPDATE profiles SET deathdate = '2010-11-16' WHERE pid = '29012';
UPDATE profiles SET deathdate = '2009-06-05' WHERE pid = '29339';
UPDATE profiles SET deathdate = '2011-07-20' WHERE pid = '30742';
UPDATE profiles SET deathdate = '2010-09-03' WHERE pid = '30839';
UPDATE profiles SET deathdate = '2010-12-01' WHERE pid = '30992';
UPDATE profiles SET deathdate = '2010-03-05' WHERE pid = '31278';
UPDATE profiles SET deathdate = '2009-07-22' WHERE pid = '31740';
UPDATE profiles SET deathdate = '2010-10-16' WHERE pid = '32009';
UPDATE profiles SET deathdate = '2009-11-23' WHERE pid = '32109';
UPDATE profiles SET deathdate = '2011-04-22' WHERE pid = '33188';
UPDATE profiles SET deathdate = '2011-09-07' WHERE pid = '33225';
UPDATE profiles SET deathdate = '2010-10-08' WHERE pid = '21088';
UPDATE profiles SET deathdate = '2009-03-24' WHERE pid = '27510';
UPDATE profiles SET deathdate = '2009-07-03' WHERE pid = '27759';
UPDATE profiles SET deathdate = '2007-09-03' WHERE pid = '28319';
UPDATE profiles SET deathdate = '2011-08-10' WHERE pid = '28512';
UPDATE profiles SET deathdate = '2011-10-09' WHERE pid = '28531';
UPDATE profiles SET deathdate = '2008-05-22' WHERE pid = '29410';
UPDATE profiles SET deathdate = '2011-09-17' WHERE pid = '30254';
UPDATE profiles SET deathdate = '2010-05-24' WHERE pid = '30415';
UPDATE profiles SET deathdate = '2009-10-23' WHERE pid = '30858';
UPDATE profiles SET deathdate = '2010-12-21' WHERE pid = '31033';
UPDATE profiles SET deathdate = '2011-06-23' WHERE pid = '31736';
UPDATE profiles SET deathdate = '2009-10-03' WHERE pid = '31909';
UPDATE profiles SET deathdate = '2009-09-18' WHERE pid = '32302';
UPDATE profiles SET deathdate = '2009-08-07' WHERE pid = '32441';
UPDATE profiles SET deathdate = '2010-01-27' WHERE pid = '32713';
UPDATE profiles SET deathdate = '2011-06-14' WHERE pid = '32787';
UPDATE profiles SET deathdate = '2007-12-02' WHERE pid = '25067';
UPDATE profiles SET deathdate = '2007-11-20' WHERE pid = '27210';
UPDATE profiles SET deathdate = '2010-02-07' WHERE pid = '27640';
UPDATE profiles SET deathdate = '2010-10-13' WHERE pid = '28057';
UPDATE profiles SET deathdate = '2010-01-10' WHERE pid = '29077';
UPDATE profiles SET deathdate = '2009-11-10' WHERE pid = '29902';
UPDATE profiles SET deathdate = '2009-09-14' WHERE pid = '30218';
UPDATE profiles SET deathdate = '2011-10-16' WHERE pid = '30543';
UPDATE profiles SET deathdate = '2007-09-01' WHERE pid = '31032';
UPDATE profiles SET deathdate = '2007-02-23' WHERE pid = '31052';
UPDATE profiles SET deathdate = '2009-10-30' WHERE pid = '31266';
UPDATE profiles SET deathdate = '2009-11-03' WHERE pid = '31671';
UPDATE profiles SET deathdate = '2010-05-16' WHERE pid = '32332';
UPDATE profiles SET deathdate = '2009-11-12' WHERE pid = '19360';
UPDATE profiles SET deathdate = '2010-12-10' WHERE pid = '27764';
UPDATE profiles SET deathdate = '2009-07-12' WHERE pid = '28769';
UPDATE profiles SET deathdate = '2010-08-06' WHERE pid = '29671';
UPDATE profiles SET deathdate = '2010-06-24' WHERE pid = '31120';
UPDATE profiles SET deathdate = '2011-01-22' WHERE pid = '32236';
UPDATE profiles SET deathdate = '2007-10-31' WHERE pid = '32600';
UPDATE profiles SET deathdate = '2011-09-03' WHERE pid = '27238';
UPDATE profiles SET deathdate = '2007-10-13' WHERE pid = '27755';
UPDATE profiles SET deathdate = '2011-08-16' WHERE pid = '28298';
UPDATE profiles SET deathdate = '2010-12-05' WHERE pid = '28348';
UPDATE profiles SET deathdate = '2007-04-24' WHERE pid = '28359';
UPDATE profiles SET deathdate = '2011-09-19' WHERE pid = '28732';
UPDATE profiles SET deathdate = '2011-03-24' WHERE pid = '30660';
UPDATE profiles SET deathdate = '2009-04-26' WHERE pid = '31354';
UPDATE profiles SET deathdate = '2010-03-07' WHERE pid = '31566';
UPDATE profiles SET deathdate = '2010-09-04' WHERE pid = '33123';
UPDATE profiles SET deathdate = '2010-12-31' WHERE pid = '27300';
UPDATE profiles SET deathdate = '2011-08-20' WHERE pid = '27439';
UPDATE profiles SET deathdate = '2009-12-21' WHERE pid = '28266';
UPDATE profiles SET deathdate = '2010-04-25' WHERE pid = '28553';
UPDATE profiles SET deathdate = '2011-01-15' WHERE pid = '30854';
UPDATE profiles SET deathdate = '2011-06-27' WHERE pid = '31695';
UPDATE profiles SET deathdate = '2011-10-04' WHERE pid = '27344';
UPDATE profiles SET deathdate = '2010-11-01' WHERE pid = '27838';
UPDATE profiles SET deathdate = '2010-03-03' WHERE pid = '27847';
UPDATE profiles SET deathdate = '2010-08-02' WHERE pid = '28114';
UPDATE profiles SET deathdate = '2011-04-25' WHERE pid = '28203';
UPDATE profiles SET deathdate = '2010-01-21' WHERE pid = '28221';
UPDATE profiles SET deathdate = '2010-11-19' WHERE pid = '28366';
UPDATE profiles SET deathdate = '2011-03-03' WHERE pid = '28401';
UPDATE profiles SET deathdate = '2010-06-25' WHERE pid = '28585';
UPDATE profiles SET deathdate = '2010-05-05' WHERE pid = '28834';
UPDATE profiles SET deathdate = '2009-09-23' WHERE pid = '29657';
UPDATE profiles SET deathdate = '2009-07-30' WHERE pid = '30857';
UPDATE profiles SET deathdate = '2010-03-16' WHERE pid = '31133';
UPDATE profiles SET deathdate = '2010-02-26' WHERE pid = '32503';
UPDATE profiles SET deathdate = '2007-01-30' WHERE pid = '32785';
UPDATE profiles SET deathdate = '2010-07-04' WHERE pid = '33255';
UPDATE profiles SET deathdate = '2011-05-07' WHERE pid = '39636';
UPDATE profiles SET deathdate = '2010-10-16' WHERE pid = '33263';
UPDATE profiles SET deathdate = '2011-01-27' WHERE pid = '27215';
UPDATE profiles SET deathdate = '2010-09-26' WHERE pid = '27702';
UPDATE profiles SET deathdate = '2011-02-14' WHERE pid = '27986';
UPDATE profiles SET deathdate = '2011-07-19' WHERE pid = '28431';
UPDATE profiles SET deathdate = '2011-01-04' WHERE pid = '28463';
UPDATE profiles SET deathdate = '2008-04-22' WHERE pid = '28557';
UPDATE profiles SET deathdate = '2010-03-14' WHERE pid = '28635';
UPDATE profiles SET deathdate = '2010-06-10' WHERE pid = '22531';
UPDATE profiles SET deathdate = '2011-06-27' WHERE pid = '29680';
UPDATE profiles SET deathdate = '2010-10-31' WHERE pid = '29714';
UPDATE profiles SET deathdate = '2011-09-24' WHERE pid = '30192';
UPDATE profiles SET deathdate = '2011-06-24' WHERE pid = '31457';
UPDATE profiles SET deathdate = '2010-07-29' WHERE pid = '31594';
UPDATE profiles SET deathdate = '2010-07-06' WHERE pid = '31725';
UPDATE profiles SET deathdate = '2011-03-09' WHERE pid = '32131';
UPDATE profiles SET deathdate = '2009-03-12' WHERE pid = '32251';
UPDATE profiles SET deathdate = '2007-11-29' WHERE pid = '33100';
UPDATE profiles SET deathdate = '2011-10-24' WHERE pid = '27085';
UPDATE profiles SET deathdate = '2011-01-05' WHERE pid = '27649';
UPDATE profiles SET deathdate = '2010-05-18' WHERE pid = '27790';
UPDATE profiles SET deathdate = '2009-04-13' WHERE pid = '27939';
UPDATE profiles SET deathdate = '2011-07-22' WHERE pid = '28080';
UPDATE profiles SET deathdate = '2007-10-14' WHERE pid = '28117';
UPDATE profiles SET deathdate = '2010-02-10' WHERE pid = '28668';
UPDATE profiles SET deathdate = '2010-06-02' WHERE pid = '28942';
UPDATE profiles SET deathdate = '2011-01-22' WHERE pid = '29264';
UPDATE profiles SET deathdate = '2010-01-14' WHERE pid = '29509';
UPDATE profiles SET deathdate = '2010-04-22' WHERE pid = '29654';
UPDATE profiles SET deathdate = '2011-03-11' WHERE pid = '30171';
UPDATE profiles SET deathdate = '2010-12-07' WHERE pid = '30515';
UPDATE profiles SET deathdate = '2011-05-29' WHERE pid = '31090';
UPDATE profiles SET deathdate = '2009-10-14' WHERE pid = '20185';
UPDATE profiles SET deathdate = '2011-03-05' WHERE pid = '31429';
UPDATE profiles SET deathdate = '2010-03-11' WHERE pid = '31696';
UPDATE profiles SET deathdate = '2009-11-20' WHERE pid = '31925';
UPDATE profiles SET deathdate = '2009-09-02' WHERE pid = '31982';
UPDATE profiles SET deathdate = '2011-04-22' WHERE pid = '32349';
UPDATE profiles SET deathdate = '2007-11-17' WHERE pid = '32377';
UPDATE profiles SET deathdate = '2010-06-21' WHERE pid = '32887';
UPDATE profiles SET deathdate = '2009-03-20' WHERE pid = '27552';
UPDATE profiles SET deathdate = '2011-03-23' WHERE pid = '27553';
UPDATE profiles SET deathdate = '2011-10-24' WHERE pid = '29172';
UPDATE profiles SET deathdate = '2009-05-02' WHERE pid = '29313';
UPDATE profiles SET deathdate = '2010-11-05' WHERE pid = '29470';
UPDATE profiles SET deathdate = '2010-11-13' WHERE pid = '29831';
UPDATE profiles SET deathdate = '2010-09-27' WHERE pid = '29938';
UPDATE profiles SET deathdate = '2009-11-27' WHERE pid = '29977';
UPDATE profiles SET deathdate = '2010-10-09' WHERE pid = '30198';
UPDATE profiles SET deathdate = '2011-04-05' WHERE pid = '30963';
UPDATE profiles SET deathdate = '2010-07-11' WHERE pid = '31076';
UPDATE profiles SET deathdate = '2009-05-19' WHERE pid = '31953';
UPDATE profiles SET deathdate = '2011-02-08' WHERE pid = '32278';
UPDATE profiles SET deathdate = '2011-10-30' WHERE pid = '32298';
UPDATE profiles SET deathdate = '2009-04-22' WHERE pid = '32333';
UPDATE profiles SET deathdate = '2011-08-31' WHERE pid = '32801';
UPDATE profiles SET deathdate = '2009-09-04' WHERE pid = '21078';
UPDATE profiles SET deathdate = '2010-01-12' WHERE pid = '25062';
UPDATE profiles SET deathdate = '2011-05-10' WHERE pid = '28483';
UPDATE profiles SET deathdate = '2010-07-03' WHERE pid = '28916';
UPDATE profiles SET deathdate = '2010-03-26' WHERE pid = '24187';
UPDATE profiles SET deathdate = '2010-01-22' WHERE pid = '29355';
UPDATE profiles SET deathdate = '2007-10-14' WHERE pid = '30025';
UPDATE profiles SET deathdate = '2010-03-11' WHERE pid = '30995';
UPDATE profiles SET deathdate = '2011-09-12' WHERE pid = '31753';
UPDATE profiles SET deathdate = '2011-08-19' WHERE pid = '32069';
UPDATE profiles SET deathdate = '2011-04-15' WHERE pid = '27211';
UPDATE profiles SET deathdate = '2011-03-02' WHERE pid = '27464';
UPDATE profiles SET deathdate = '2011-10-17' WHERE pid = '27750';
UPDATE profiles SET deathdate = '2010-04-29' WHERE pid = '27927';
UPDATE profiles SET deathdate = '2010-05-31' WHERE pid = '23320';
UPDATE profiles SET deathdate = '2009-05-19' WHERE pid = '29413';
UPDATE profiles SET deathdate = '2010-05-13' WHERE pid = '30642';
UPDATE profiles SET deathdate = '2009-06-15' WHERE pid = '30911';
UPDATE profiles SET deathdate = '2010-08-27' WHERE pid = '31151';
UPDATE profiles SET deathdate = '2009-08-08' WHERE pid = '31352';
UPDATE profiles SET deathdate = '2010-01-17' WHERE pid = '31367';
UPDATE profiles SET deathdate = '2009-10-14' WHERE pid = '31608';
UPDATE profiles SET deathdate = '2011-10-29' WHERE pid = '31928';
UPDATE profiles SET deathdate = '2009-10-15' WHERE pid = '32328';
UPDATE profiles SET deathdate = '2009-10-27' WHERE pid = '27477';
UPDATE profiles SET deathdate = '2011-02-24' WHERE pid = '28271';
UPDATE profiles SET deathdate = '2010-12-31' WHERE pid = '29001';
UPDATE profiles SET deathdate = '2009-10-14' WHERE pid = '29512';
UPDATE profiles SET deathdate = '2009-09-01' WHERE pid = '30693';
UPDATE profiles SET deathdate = '2007-09-23' WHERE pid = '31267';
UPDATE profiles SET deathdate = '2010-09-22' WHERE pid = '32323';
UPDATE profiles SET deathdate = '2007-11-17' WHERE pid = '32559';
UPDATE profiles SET deathdate = '2010-12-02' WHERE pid = '32768';
UPDATE profiles SET deathdate = '2009-10-23' WHERE pid = '33142';
UPDATE profiles SET deathdate = '2009-06-04' WHERE pid = '27733';
UPDATE profiles SET deathdate = '2010-02-13' WHERE pid = '28749';
UPDATE profiles SET deathdate = '2008-04-17' WHERE pid = '29016';
UPDATE profiles SET deathdate = '2010-10-09' WHERE pid = '29079';
UPDATE profiles SET deathdate = '2010-12-06' WHERE pid = '29698';
UPDATE profiles SET deathdate = '2010-11-20' WHERE pid = '31567';
UPDATE profiles SET deathdate = '2011-07-30' WHERE pid = '31955';
UPDATE profiles SET deathdate = '2011-04-10' WHERE pid = '32288';
UPDATE profiles SET deathdate = '2010-10-17' WHERE pid = '32307';
UPDATE profiles SET deathdate = '2011-08-27' WHERE pid = '27349';
UPDATE profiles SET deathdate = '2011-09-07' WHERE pid = '20937';
UPDATE profiles SET deathdate = '2010-04-29' WHERE pid = '27917';
UPDATE profiles SET deathdate = '2009-11-08' WHERE pid = '28188';
UPDATE profiles SET deathdate = '2010-12-30' WHERE pid = '28844';
UPDATE profiles SET deathdate = '2010-11-09' WHERE pid = '29232';
UPDATE profiles SET deathdate = '2011-01-06' WHERE pid = '29674';
UPDATE profiles SET deathdate = '2001-03-18' WHERE pid = '30926';
UPDATE profiles SET deathdate = '2009-06-04' WHERE pid = '31771';
UPDATE profiles SET deathdate = '2009-09-14' WHERE pid = '32103';
UPDATE profiles SET deathdate = '2008-11-26' WHERE pid = '33150';
UPDATE profiles SET deathdate = '2007-10-09' WHERE pid = '27671';
UPDATE profiles SET deathdate = '2007-11-19' WHERE pid = '29310';
UPDATE profiles SET deathdate = '2011-10-12' WHERE pid = '29319';
UPDATE profiles SET deathdate = '2009-12-17' WHERE pid = '30179';
UPDATE profiles SET deathdate = '2009-04-29' WHERE pid = '31557';
UPDATE profiles SET deathdate = '2010-09-21' WHERE pid = '32168';
UPDATE profiles SET deathdate = '2010-04-12' WHERE pid = '32566';
UPDATE profiles SET deathdate = '2010-05-14' WHERE pid = '32830';
UPDATE profiles SET deathdate = '2011-07-28' WHERE pid = '28663';
UPDATE profiles SET deathdate = '2010-02-09' WHERE pid = '24442';
UPDATE profiles SET deathdate = '2010-11-11' WHERE pid = '29331';
UPDATE profiles SET deathdate = '2008-04-28' WHERE pid = '30092';
UPDATE profiles SET deathdate = '2011-03-19' WHERE pid = '30237';
UPDATE profiles SET deathdate = '2010-02-22' WHERE pid = '30883';
UPDATE profiles SET deathdate = '2009-04-12' WHERE pid = '32363';
UPDATE profiles SET deathdate = '2011-01-07' WHERE pid = '27449';
UPDATE profiles SET deathdate = '2009-08-09' WHERE pid = '28086';
UPDATE profiles SET deathdate = '2011-10-09' WHERE pid = '28228';
UPDATE profiles SET deathdate = '2010-11-16' WHERE pid = '28414';
UPDATE profiles SET deathdate = '2011-01-31' WHERE pid = '28466';
UPDATE profiles SET deathdate = '2009-09-17' WHERE pid = '28586';
UPDATE profiles SET deathdate = '2010-01-06' WHERE pid = '29665';
UPDATE profiles SET deathdate = '2010-09-21' WHERE pid = '31454';
UPDATE profiles SET deathdate = '2010-02-27' WHERE pid = '32289';
UPDATE profiles SET deathdate = '2009-10-19' WHERE pid = '33031';
UPDATE profiles SET deathdate = '2009-01-07' WHERE pid = '33234';
UPDATE profiles SET deathdate = '2010-11-14' WHERE pid = '26728';
UPDATE profiles SET deathdate = '2009-10-19' WHERE pid = '27385';
UPDATE profiles SET deathdate = '2010-09-24' WHERE pid = '28753';
UPDATE profiles SET deathdate = '2009-05-06' WHERE pid = '29262';
UPDATE profiles SET deathdate = '2011-10-25' WHERE pid = '25083';
UPDATE profiles SET deathdate = '2010-12-15' WHERE pid = '19615';
UPDATE profiles SET deathdate = '2011-03-01' WHERE pid = '32535';
UPDATE profiles SET deathdate = '2010-02-03' WHERE pid = '23206';
UPDATE profiles SET deathdate = '2011-06-09' WHERE pid = '28116';
UPDATE profiles SET deathdate = '2011-09-14' WHERE pid = '28895';
UPDATE profiles SET deathdate = '2011-04-28' WHERE pid = '26768';
UPDATE profiles SET deathdate = '2009-04-11' WHERE pid = '30027';
UPDATE profiles SET deathdate = '2011-03-07' WHERE pid = '25594';
UPDATE profiles SET deathdate = '2011-05-09' WHERE pid = '28193';
UPDATE profiles SET deathdate = '2011-02-17' WHERE pid = '29447';
UPDATE profiles SET deathdate = '2008-02-04' WHERE pid = '30744';
UPDATE profiles SET deathdate = '2009-06-19' WHERE pid = '31044';
UPDATE profiles SET deathdate = '2010-10-13' WHERE pid = '27167';
UPDATE profiles SET deathdate = '2011-09-05' WHERE pid = '22455';
UPDATE profiles SET deathdate = '2011-06-16' WHERE pid = '19924';
UPDATE profiles SET deathdate = '2010-01-30' WHERE pid = '29593';
UPDATE profiles SET deathdate = '2010-02-05' WHERE pid = '30504';
UPDATE profiles SET deathdate = '2009-09-14' WHERE pid = '28206';
UPDATE profiles SET deathdate = '2011-09-13' WHERE pid = '27528';
UPDATE profiles SET deathdate = '2008-03-30' WHERE pid = '25852';
UPDATE profiles SET deathdate = '2009-11-26' WHERE pid = '31382';
UPDATE profiles SET deathdate = '2011-05-05' WHERE pid = '20557';
UPDATE profiles SET deathdate = '2010-11-14' WHERE pid = '32350';
UPDATE profiles SET deathdate = '2007-10-31' WHERE pid = '33148';
UPDATE profiles SET deathdate = '2011-09-09' WHERE pid = '20669';
UPDATE profiles SET deathdate = '2011-10-02' WHERE pid = '24256';
UPDATE profiles SET deathdate = '2011-09-11' WHERE pid = '28312';
UPDATE profiles SET deathdate = '2010-11-28' WHERE pid = '29340';
UPDATE profiles SET deathdate = '2009-03-21' WHERE pid = '32163';
UPDATE profiles SET deathdate = '2011-03-04' WHERE pid = '32876';
UPDATE profiles SET deathdate = '2011-10-23' WHERE pid = '22049';
UPDATE profiles SET deathdate = '2011-04-20' WHERE pid = '29234';
UPDATE profiles SET deathdate = '2009-11-14' WHERE pid = '29636';
UPDATE profiles SET deathdate = '2007-11-01' WHERE pid = '29838';
UPDATE profiles SET deathdate = '2009-12-15' WHERE pid = '19882';
UPDATE profiles SET deathdate = '2010-12-06' WHERE pid = '27501';
UPDATE profiles SET deathdate = '2011-02-08' WHERE pid = '28131';
UPDATE profiles SET deathdate = '2009-09-09' WHERE pid = '18402';
UPDATE profiles SET deathdate = '2009-11-22' WHERE pid = '29639';
UPDATE profiles SET deathdate = '2011-09-29' WHERE pid = '30146';
UPDATE profiles SET deathdate = '2009-09-03' WHERE pid = '22566';
UPDATE profiles SET deathdate = '2011-01-23' WHERE pid = '24995';
UPDATE profiles SET deathdate = '2010-06-01' WHERE pid = '28723';
UPDATE profiles SET deathdate = '2009-11-22' WHERE pid = '32224';
UPDATE profiles SET deathdate = '2011-06-29' WHERE pid = '32233';
UPDATE profiles SET deathdate = '2009-07-12' WHERE pid = '21042';
UPDATE profiles SET deathdate = '2009-12-28' WHERE pid = '27743';
UPDATE profiles SET deathdate = '2010-06-21' WHERE pid = '31338';
UPDATE profiles SET deathdate = '2011-07-10' WHERE pid = '31465';
UPDATE profiles SET deathdate = '2008-05-09' WHERE pid = '30172';
UPDATE profiles SET deathdate = '2010-06-07' WHERE pid = '31716';
UPDATE profiles SET deathdate = '2009-09-30' WHERE pid = '27874';
UPDATE profiles SET deathdate = '2009-04-18' WHERE pid = '29947';
UPDATE profiles SET deathdate = '2009-05-27' WHERE pid = '31220';
UPDATE profiles SET deathdate = '2010-02-12' WHERE pid = '28154';
UPDATE profiles SET deathdate = '2007-10-10' WHERE pid = '30970';
UPDATE profiles SET deathdate = '2010-03-26' WHERE pid = '31821';
UPDATE profiles SET deathdate = '2010-01-17' WHERE pid = '10353';
UPDATE profiles SET deathdate = '2011-02-10' WHERE pid = '27535';
UPDATE profiles SET deathdate = '2010-07-02' WHERE pid = '32639';
UPDATE profiles SET deathdate = '2010-10-03' WHERE pid = '26033';
UPDATE profiles SET deathdate = '2009-10-06' WHERE pid = '17286';
UPDATE profiles SET deathdate = '2011-02-09' WHERE pid = '34300';
UPDATE profiles SET deathdate = '2010-01-29' WHERE pid = '21993';
UPDATE profiles SET deathdate = '2010-02-12' WHERE pid = '34915';
UPDATE profiles SET deathdate = '2008-07-19' WHERE pid = '35052';
UPDATE profiles SET deathdate = '2011-05-18' WHERE pid = '35550';
UPDATE profiles SET deathdate = '2010-05-02' WHERE pid = '24416';
UPDATE profiles SET deathdate = '2007-11-03' WHERE pid = '18161';
UPDATE profiles SET deathdate = '2011-09-21' WHERE pid = '11703';
UPDATE profiles SET deathdate = '2010-09-16' WHERE pid = '15609';
UPDATE profiles SET deathdate = '2011-10-07' WHERE pid = '45532';