search

Afrostream / afrostream-back-end

Simple backo for afrostream
1 stars 0 forks source link

database: migrate phone numbers to international e.164 / MSISDN format #414

Closed syndr0m closed 7 years ago

syndr0m commented 7 years ago

FIXME: is "+" symbol mandatory ?

on backup la table users

create table "backupUsers31032017" AS TABLE "Users";

récupération des numéros actuels

select _id, telephone from "Users" where telephone is not null order by _id

création d'un spreadsheet en vue d'un re-export en JSON pour traitement @see https://docs.google.com/a/afrostream.tv/spreadsheets/d/1f5r3Q8XkC5zc9fdIB5-p-EtI_5gCnqFeFTFhzKnkD3U/edit?usp=sharing

création d'un script de parsing des numéros de téléphone


// Require `PhoneNumberFormat`. 
const { parse, format }  = require('libphonenumber-js');

const data = [
 // FIXME
]; 

data.forEach(([userId, telephone]) => {
  const phoneNumber = parse(telephone, 'FR');
  const newPhoneNumber = format(phoneNumber, 'International_plaintext');
  //console.log(userId + ' => ' + telephone + ' ' + newPhoneNumber);
  console.log(newPhoneNumber)
});

utilisation du spreadsheet pour générer les requêtes

syndr0m commented 7 years ago 
UPDATE "Users" SET "telephone"='33680682570' WHERE _id=1;
UPDATE "Users" SET "telephone"='' WHERE _id=224;
UPDATE "Users" SET "telephone"='33684438779' WHERE _id=226;
UPDATE "Users" SET "telephone"='33601400723' WHERE _id=385;
UPDATE "Users" SET "telephone"='33651787628' WHERE _id=488;
UPDATE "Users" SET "telephone"='33666691015' WHERE _id=1023;
UPDATE "Users" SET "telephone"='33607274096' WHERE _id=1116;
UPDATE "Users" SET "telephone"='41762568138' WHERE _id=1204;
UPDATE "Users" SET "telephone"='22501670255' WHERE _id=1253;
UPDATE "Users" SET "telephone"='33652861812' WHERE _id=1417;
UPDATE "Users" SET "telephone"='33661432517' WHERE _id=1587;
UPDATE "Users" SET "telephone"='33694442428' WHERE _id=1714;
UPDATE "Users" SET "telephone"='33785732213' WHERE _id=1959;
UPDATE "Users" SET "telephone"='33650719944' WHERE _id=2016;
UPDATE "Users" SET "telephone"='33681327812' WHERE _id=2092;
UPDATE "Users" SET "telephone"='' WHERE _id=2112;
UPDATE "Users" SET "telephone"='33761716812' WHERE _id=2237;
UPDATE "Users" SET "telephone"='33627550732' WHERE _id=2266;
UPDATE "Users" SET "telephone"='33768819183' WHERE _id=3241;
UPDATE "Users" SET "telephone"='33642589169' WHERE _id=3358;
UPDATE "Users" SET "telephone"='33783075073' WHERE _id=3725;
UPDATE "Users" SET "telephone"='5147466970' WHERE _id=4990;
UPDATE "Users" SET "telephone"='33651935990' WHERE _id=7069;
UPDATE "Users" SET "telephone"='33616152880' WHERE _id=7783;
UPDATE "Users" SET "telephone"='491602591977' WHERE _id=8572;
UPDATE "Users" SET "telephone"='33783118358' WHERE _id=9101;
UPDATE "Users" SET "telephone"='33628533112' WHERE _id=9183;
UPDATE "Users" SET "telephone"='33646798051' WHERE _id=9653;
UPDATE "Users" SET "telephone"='33668225256' WHERE _id=10398;
UPDATE "Users" SET "telephone"='' WHERE _id=10965;
UPDATE "Users" SET "telephone"='33768093492' WHERE _id=11555;
UPDATE "Users" SET "telephone"='33782602296' WHERE _id=14479;
UPDATE "Users" SET "telephone"='33659062894' WHERE _id=15530;
UPDATE "Users" SET "telephone"='33658223332' WHERE _id=15946;
UPDATE "Users" SET "telephone"='33645022746' WHERE _id=16423;
UPDATE "Users" SET "telephone"='33760805568' WHERE _id=16451;
UPDATE "Users" SET "telephone"='33769053878' WHERE _id=19203;
UPDATE "Users" SET "telephone"='33770000692' WHERE _id=19262;
UPDATE "Users" SET "telephone"='33666062574' WHERE _id=19732;
UPDATE "Users" SET "telephone"='33666228265' WHERE _id=20106;
UPDATE "Users" SET "telephone"='33763403911' WHERE _id=20420;
UPDATE "Users" SET "telephone"='33617895361' WHERE _id=20580;
UPDATE "Users" SET "telephone"='33646452335' WHERE _id=21428;
UPDATE "Users" SET "telephone"='33658704503' WHERE _id=22206;
UPDATE "Users" SET "telephone"='33659644880' WHERE _id=22307;
UPDATE "Users" SET "telephone"='33652850535' WHERE _id=22635;
UPDATE "Users" SET "telephone"='32486333308' WHERE _id=24614;
UPDATE "Users" SET "telephone"='33650176661' WHERE _id=26280;
UPDATE "Users" SET "telephone"='33686866438' WHERE _id=26651;
UPDATE "Users" SET "telephone"='33626594770' WHERE _id=27851;
UPDATE "Users" SET "telephone"='33665588428' WHERE _id=27919;
UPDATE "Users" SET "telephone"='33690682445' WHERE _id=28159;
UPDATE "Users" SET "telephone"='33636933853' WHERE _id=28590;
UPDATE "Users" SET "telephone"='33628122069' WHERE _id=29057;
UPDATE "Users" SET "telephone"='33758872551' WHERE _id=29215;
UPDATE "Users" SET "telephone"='33617350199' WHERE _id=33019;
UPDATE "Users" SET "telephone"='33758205395' WHERE _id=34061;
UPDATE "Users" SET "telephone"='33667989685' WHERE _id=34578;
UPDATE "Users" SET "telephone"='33650156515' WHERE _id=34790;
UPDATE "Users" SET "telephone"='33665517162' WHERE _id=34874;
UPDATE "Users" SET "telephone"='33783213373' WHERE _id=37026;
UPDATE "Users" SET "telephone"='33610271287' WHERE _id=37462;
UPDATE "Users" SET "telephone"='33768857312' WHERE _id=37629;
UPDATE "Users" SET "telephone"='33751216223' WHERE _id=37723;
UPDATE "Users" SET "telephone"='33788556750' WHERE _id=40487;
UPDATE "Users" SET "telephone"='33755412127' WHERE _id=44007;
UPDATE "Users" SET "telephone"='33651927198' WHERE _id=45292;
UPDATE "Users" SET "telephone"='32493396325' WHERE _id=45815;
UPDATE "Users" SET "telephone"='33641187207' WHERE _id=47173;
UPDATE "Users" SET "telephone"='447503566644' WHERE _id=50294;
UPDATE "Users" SET "telephone"='33624470720' WHERE _id=52042;
UPDATE "Users" SET "telephone"='33603793466' WHERE _id=54154;
UPDATE "Users" SET "telephone"='33782622557' WHERE _id=55418;
UPDATE "Users" SET "telephone"='33677343109' WHERE _id=58095;
UPDATE "Users" SET "telephone"='33789495543' WHERE _id=58644;
UPDATE "Users" SET "telephone"='33758102870' WHERE _id=60315;
UPDATE "Users" SET "telephone"='' WHERE _id=62886;
UPDATE "Users" SET "telephone"='33609039105' WHERE _id=64071;
UPDATE "Users" SET "telephone"='33590538749' WHERE _id=65918;
UPDATE "Users" SET "telephone"='33645318566' WHERE _id=66635;
UPDATE "Users" SET "telephone"='33638357444' WHERE _id=68417;
UPDATE "Users" SET "telephone"='33634273542' WHERE _id=69516;
UPDATE "Users" SET "telephone"='33624593948' WHERE _id=70335;
UPDATE "Users" SET "telephone"='33621888838' WHERE _id=71131;
UPDATE "Users" SET "telephone"='33782651161' WHERE _id=71297;
UPDATE "Users" SET "telephone"='33666584774' WHERE _id=71924;
UPDATE "Users" SET "telephone"='33610954308' WHERE _id=73685;
UPDATE "Users" SET "telephone"='33646222975' WHERE _id=73687;
UPDATE "Users" SET "telephone"='33628570032' WHERE _id=73858;
UPDATE "Users" SET "telephone"='32493396325' WHERE _id=74147;
UPDATE "Users" SET "telephone"='33633336650' WHERE _id=74281;
UPDATE "Users" SET "telephone"='33787410114' WHERE _id=75827;
UPDATE "Users" SET "telephone"='33781361125' WHERE _id=75921;
UPDATE "Users" SET "telephone"='33484225187' WHERE _id=77186;
UPDATE "Users" SET "telephone"='33781721075' WHERE _id=77456;
UPDATE "Users" SET "telephone"='33628010080' WHERE _id=77905;
UPDATE "Users" SET "telephone"='' WHERE _id=80196;
UPDATE "Users" SET "telephone"='330753504470' WHERE _id=86020;
UPDATE "Users" SET "telephone"='33488325865' WHERE _id=86540;
UPDATE "Users" SET "telephone"='' WHERE _id=88798;
UPDATE "Users" SET "telephone"='33663249215' WHERE _id=92681;
UPDATE "Users" SET "telephone"='33783991460' WHERE _id=94341;
UPDATE "Users" SET "telephone"='' WHERE _id=100892;
UPDATE "Users" SET "telephone"='33758387078' WHERE _id=101395;
UPDATE "Users" SET "telephone"='33682479211' WHERE _id=102111;
UPDATE "Users" SET "telephone"='33768199443' WHERE _id=104989;
UPDATE "Users" SET "telephone"='33650343357' WHERE _id=105916;
UPDATE "Users" SET "telephone"='33651538589' WHERE _id=107205;
UPDATE "Users" SET "telephone"='33613860659' WHERE _id=107351;
UPDATE "Users" SET "telephone"='33781499521' WHERE _id=107393;
UPDATE "Users" SET "telephone"='22507986272' WHERE _id=107769;
UPDATE "Users" SET "telephone"='33643333047' WHERE _id=107823;
UPDATE "Users" SET "telephone"='33662963792' WHERE _id=108854;
UPDATE "Users" SET "telephone"='33761618797' WHERE _id=109196;
UPDATE "Users" SET "telephone"='33698058900' WHERE _id=109701;
UPDATE "Users" SET "telephone"='33761011415' WHERE _id=111021;
UPDATE "Users" SET "telephone"='33768830605' WHERE _id=114155;
UPDATE "Users" SET "telephone"='33635445498' WHERE _id=114688;
UPDATE "Users" SET "telephone"='33601496543' WHERE _id=115508;
UPDATE "Users" SET "telephone"='33698675745' WHERE _id=115577;
UPDATE "Users" SET "telephone"='33781985791' WHERE _id=130636;
UPDATE "Users" SET "telephone"='33760188323' WHERE _id=131525;
UPDATE "Users" SET "telephone"='33611521763' WHERE _id=132949;
UPDATE "Users" SET "telephone"='33611283467' WHERE _id=135276;
UPDATE "Users" SET "telephone"='33696185178' WHERE _id=135715;
UPDATE "Users" SET "telephone"='33690680879' WHERE _id=136440;
UPDATE "Users" SET "telephone"='33625262704' WHERE _id=138061;
UPDATE "Users" SET "telephone"='33626701829' WHERE _id=140150;
UPDATE "Users" SET "telephone"='771815132' WHERE _id=140227;
UPDATE "Users" SET "telephone"='33666131733' WHERE _id=147123;
UPDATE "Users" SET "telephone"='33770089750' WHERE _id=155504;
UPDATE "Users" SET "telephone"='33652363401' WHERE _id=156216;
UPDATE "Users" SET "telephone"='33758205395' WHERE _id=157488;
UPDATE "Users" SET "telephone"='33696557753' WHERE _id=157763;
UPDATE "Users" SET "telephone"='33624224493' WHERE _id=158524;
UPDATE "Users" SET "telephone"='33650020824' WHERE _id=160724;
UPDATE "Users" SET "telephone"='' WHERE _id=163066;
UPDATE "Users" SET "telephone"='33612868573' WHERE _id=168514;
UPDATE "Users" SET "telephone"='33659499346' WHERE _id=169843;
UPDATE "Users" SET "telephone"='33651542679' WHERE _id=170060;
UPDATE "Users" SET "telephone"='32484960175' WHERE _id=170534;
UPDATE "Users" SET "telephone"='33768462992' WHERE _id=172455;
UPDATE "Users" SET "telephone"='33699651520' WHERE _id=177221;
UPDATE "Users" SET "telephone"='33751160639' WHERE _id=178891;
UPDATE "Users" SET "telephone"='33781962142' WHERE _id=179943;
UPDATE "Users" SET "telephone"='33762831602' WHERE _id=181130;
UPDATE "Users" SET "telephone"='' WHERE _id=182565;
UPDATE "Users" SET "telephone"='33651600692' WHERE _id=183295;
UPDATE "Users" SET "telephone"='33629166486' WHERE _id=183536;
UPDATE "Users" SET "telephone"='221782929890' WHERE _id=184052;
UPDATE "Users" SET "telephone"='33616478466' WHERE _id=184658;
UPDATE "Users" SET "telephone"='33616294888' WHERE _id=185324;
UPDATE "Users" SET "telephone"='33626376242' WHERE _id=186068;
UPDATE "Users" SET "telephone"='33680482507' WHERE _id=186734;
UPDATE "Users" SET "telephone"='33613603537' WHERE _id=187007;
UPDATE "Users" SET "telephone"='33640958906' WHERE _id=187148;
UPDATE "Users" SET "telephone"='33699916758' WHERE _id=187499;
UPDATE "Users" SET "telephone"='33692944953' WHERE _id=189619;
UPDATE "Users" SET "telephone"='33603869264' WHERE _id=189754;
UPDATE "Users" SET "telephone"='33768015590' WHERE _id=190026;
UPDATE "Users" SET "telephone"='33753156198' WHERE _id=190083;
UPDATE "Users" SET "telephone"='33617969406' WHERE _id=190659;
UPDATE "Users" SET "telephone"='33786384597' WHERE _id=190694;
UPDATE "Users" SET "telephone"='24106282527' WHERE _id=190969;
UPDATE "Users" SET "telephone"='33783651157' WHERE _id=192495;
UPDATE "Users" SET "telephone"='' WHERE _id=192711;
UPDATE "Users" SET "telephone"='33627491645' WHERE _id=193046;
UPDATE "Users" SET "telephone"='33695180444' WHERE _id=193731;
UPDATE "Users" SET "telephone"='33782274997' WHERE _id=193807;
UPDATE "Users" SET "telephone"='33611197342' WHERE _id=194511;
UPDATE "Users" SET "telephone"='33646928167' WHERE _id=194882;
UPDATE "Users" SET "telephone"='33783560873' WHERE _id=195634;
UPDATE "Users" SET "telephone"='33781341986' WHERE _id=197217;
UPDATE "Users" SET "telephone"='33986701392' WHERE _id=198079;
UPDATE "Users" SET "telephone"='237653170911' WHERE _id=198345;
UPDATE "Users" SET "telephone"='221775693504' WHERE _id=199200;
UPDATE "Users" SET "telephone"='33646014461' WHERE _id=199442;
UPDATE "Users" SET "telephone"='' WHERE _id=199735;
UPDATE "Users" SET "telephone"='' WHERE _id=199978;
UPDATE "Users" SET "telephone"='' WHERE _id=200346;
UPDATE "Users" SET "telephone"='33611177601' WHERE _id=200633;
UPDATE "Users" SET "telephone"='237696297119' WHERE _id=201897;
UPDATE "Users" SET "telephone"='33662302763' WHERE _id=203051;
UPDATE "Users" SET "telephone"='33618285332' WHERE _id=203820;
UPDATE "Users" SET "telephone"='33782778808' WHERE _id=205759;
UPDATE "Users" SET "telephone"='224621255936' WHERE _id=209383;
UPDATE "Users" SET "telephone"='447435574537' WHERE _id=209868;
UPDATE "Users" SET "telephone"='33751479863' WHERE _id=210113;
UPDATE "Users" SET "telephone"='' WHERE _id=211179;
UPDATE "Users" SET "telephone"='33789842338' WHERE _id=214793;
UPDATE "Users" SET "telephone"='33612811587' WHERE _id=214916;
UPDATE "Users" SET "telephone"='778317732' WHERE _id=216250;
UPDATE "Users" SET "telephone"='221772598649' WHERE _id=216384;
UPDATE "Users" SET "telephone"='' WHERE _id=217234;
UPDATE "Users" SET "telephone"='33760004566' WHERE _id=217458;
UPDATE "Users" SET "telephone"='' WHERE _id=218592;
UPDATE "Users" SET "telephone"='33695351286' WHERE _id=218905;
UPDATE "Users" SET "telephone"='33770336598' WHERE _id=219546;
UPDATE "Users" SET "telephone"='33650033371' WHERE _id=219591;
UPDATE "Users" SET "telephone"='33687527147' WHERE _id=219740;
UPDATE "Users" SET "telephone"='33756430824' WHERE _id=219879;
UPDATE "Users" SET "telephone"='33698197174' WHERE _id=221214;
UPDATE "Users" SET "telephone"='33611653705' WHERE _id=224315;
UPDATE "Users" SET "telephone"='33663317765' WHERE _id=224940;
UPDATE "Users" SET "telephone"='33603316340' WHERE _id=225185;
UPDATE "Users" SET "telephone"='33660060431' WHERE _id=226449;
UPDATE "Users" SET "telephone"='33783118358' WHERE _id=226533;
UPDATE "Users" SET "telephone"='33995794742' WHERE _id=226897;
UPDATE "Users" SET "telephone"='33768205109' WHERE _id=227094;
UPDATE "Users" SET "telephone"='33696111043' WHERE _id=229152;
UPDATE "Users" SET "telephone"='' WHERE _id=230908;
UPDATE "Users" SET "telephone"='33631059570' WHERE _id=231191;
UPDATE "Users" SET "telephone"='33659489844' WHERE _id=231578;
UPDATE "Users" SET "telephone"='971506798075' WHERE _id=233380;
UPDATE "Users" SET "telephone"='22247651554' WHERE _id=233391;
UPDATE "Users" SET "telephone"='' WHERE _id=234956;
UPDATE "Users" SET "telephone"='22967658013' WHERE _id=235031;
UPDATE "Users" SET "telephone"='33622621034' WHERE _id=235154;
UPDATE "Users" SET "telephone"='33613114041' WHERE _id=235675;
UPDATE "Users" SET "telephone"='33778635645' WHERE _id=235709;
UPDATE "Users" SET "telephone"='33663898607' WHERE _id=236013;
UPDATE "Users" SET "telephone"='33760366063' WHERE _id=236314;
UPDATE "Users" SET "telephone"='33624716319' WHERE _id=236605;
UPDATE "Users" SET "telephone"='33660024261' WHERE _id=236653;
UPDATE "Users" SET "telephone"='33760321153' WHERE _id=236655;
UPDATE "Users" SET "telephone"='33614725600' WHERE _id=236801;
UPDATE "Users" SET "telephone"='33699757670' WHERE _id=239257;
UPDATE "Users" SET "telephone"='33783118358' WHERE _id=239752;
UPDATE "Users" SET "telephone"='33623775297' WHERE _id=240158;
UPDATE "Users" SET "telephone"='33662011731' WHERE _id=240220;
UPDATE "Users" SET "telephone"='33603272383' WHERE _id=240376;
UPDATE "Users" SET "telephone"='33661762174' WHERE _id=240484;
UPDATE "Users" SET "telephone"='33611384485' WHERE _id=241131;
UPDATE "Users" SET "telephone"='33782096297' WHERE _id=241399;
UPDATE "Users" SET "telephone"='33659336169' WHERE _id=241969;
UPDATE "Users" SET "telephone"='590690123910' WHERE _id=241987;
UPDATE "Users" SET "telephone"='33659476704' WHERE _id=243698;
UPDATE "Users" SET "telephone"='33753415852' WHERE _id=244188;
UPDATE "Users" SET "telephone"='33618745247' WHERE _id=244449;
UPDATE "Users" SET "telephone"='' WHERE _id=244616;
UPDATE "Users" SET "telephone"='24102630530' WHERE _id=244854;
UPDATE "Users" SET "telephone"='33696066838' WHERE _id=245433;
UPDATE "Users" SET "telephone"='33616243529' WHERE _id=246105;
UPDATE "Users" SET "telephone"='33629201879' WHERE _id=246645;
UPDATE "Users" SET "telephone"='33768055549' WHERE _id=246893;
UPDATE "Users" SET "telephone"='33682200983' WHERE _id=247186;
UPDATE "Users" SET "telephone"='33781545670' WHERE _id=247492;
UPDATE "Users" SET "telephone"='33633505194' WHERE _id=247704;
UPDATE "Users" SET "telephone"='33782602296' WHERE _id=248100;
UPDATE "Users" SET "telephone"='' WHERE _id=248652;
UPDATE "Users" SET "telephone"='' WHERE _id=248845;
UPDATE "Users" SET "telephone"='33682474643' WHERE _id=249097;
UPDATE "Users" SET "telephone"='33661601297' WHERE _id=249974;
UPDATE "Users" SET "telephone"='33622037448' WHERE _id=250036;
UPDATE "Users" SET "telephone"='33781957693' WHERE _id=250821;
UPDATE "Users" SET "telephone"='33666102495' WHERE _id=250862;
UPDATE "Users" SET "telephone"='33603793211' WHERE _id=250917;
UPDATE "Users" SET "telephone"='33466438046' WHERE _id=251434;
UPDATE "Users" SET "telephone"='33763403911' WHERE _id=251503;
UPDATE "Users" SET "telephone"='33665681573' WHERE _id=251614;
UPDATE "Users" SET "telephone"='' WHERE _id=251754;
UPDATE "Users" SET "telephone"='33648394441' WHERE _id=252009;
UPDATE "Users" SET "telephone"='33783914835' WHERE _id=252594;
UPDATE "Users" SET "telephone"='33623828833' WHERE _id=252844;
UPDATE "Users" SET "telephone"='33647549033' WHERE _id=253835;
UPDATE "Users" SET "telephone"='22579366384' WHERE _id=254343;
UPDATE "Users" SET "telephone"='22374544044' WHERE _id=255515;
UPDATE "Users" SET "telephone"='33753536074' WHERE _id=256573;
UPDATE "Users" SET "telephone"='33696027586' WHERE _id=256650;
UPDATE "Users" SET "telephone"='33651000571' WHERE _id=257325;
UPDATE "Users" SET "telephone"='33636987617' WHERE _id=257557;
UPDATE "Users" SET "telephone"='33785706086' WHERE _id=257717;
UPDATE "Users" SET "telephone"='33651796559' WHERE _id=258066;
UPDATE "Users" SET "telephone"='33663183771' WHERE _id=258151;
UPDATE "Users" SET "telephone"='33782725757' WHERE _id=259467;
UPDATE "Users" SET "telephone"='33606515966' WHERE _id=259547;
UPDATE "Users" SET "telephone"='' WHERE _id=259921;
UPDATE "Users" SET "telephone"='33788436932' WHERE _id=260694;
UPDATE "Users" SET "telephone"='33611555076' WHERE _id=261411;
UPDATE "Users" SET "telephone"='33771802696' WHERE _id=261541;
UPDATE "Users" SET "telephone"='33634554028' WHERE _id=265045;
UPDATE "Users" SET "telephone"='33750839012' WHERE _id=270610;
UPDATE "Users" SET "telephone"='33652103486' WHERE _id=275595;
UPDATE "Users" SET "telephone"='33662117395' WHERE _id=280256;
UPDATE "Users" SET "telephone"='33696025738' WHERE _id=282621;
UPDATE "Users" SET "telephone"='33668058834' WHERE _id=287202;
UPDATE "Users" SET "telephone"='33678666777' WHERE _id=290675;
UPDATE "Users" SET "telephone"='33640146214' WHERE _id=292338;
UPDATE "Users" SET "telephone"='33781331205' WHERE _id=296180;
UPDATE "Users" SET "telephone"='33777202493' WHERE _id=297909;
UPDATE "Users" SET "telephone"='33650004394' WHERE _id=300899;
UPDATE "Users" SET "telephone"='33679345483' WHERE _id=303704;
UPDATE "Users" SET "telephone"='33466445473' WHERE _id=303716;
UPDATE "Users" SET "telephone"='33695433189' WHERE _id=306917;
UPDATE "Users" SET "telephone"='33610980845' WHERE _id=309637;
UPDATE "Users" SET "telephone"='33626794803' WHERE _id=313216;
UPDATE "Users" SET "telephone"='33623820544' WHERE _id=314373;
UPDATE "Users" SET "telephone"='33783060398' WHERE _id=314414;
UPDATE "Users" SET "telephone"='33769466791' WHERE _id=317526;
UPDATE "Users" SET "telephone"='33140117345' WHERE _id=317672;
UPDATE "Users" SET "telephone"='' WHERE _id=320502;
UPDATE "Users" SET "telephone"='242069800101' WHERE _id=321866;
UPDATE "Users" SET "telephone"='33769050747' WHERE _id=322128;
UPDATE "Users" SET "telephone"='33659238990' WHERE _id=322316;
UPDATE "Users" SET "telephone"='' WHERE _id=322385;
UPDATE "Users" SET "telephone"='33618001300' WHERE _id=324190;
UPDATE "Users" SET "telephone"='33768621762' WHERE _id=324562;
UPDATE "Users" SET "telephone"='33615240181' WHERE _id=324610;
UPDATE "Users" SET "telephone"='33782217971' WHERE _id=325755;
UPDATE "Users" SET "telephone"='33680682570' WHERE _id=326922;
UPDATE "Users" SET "telephone"='33680682570' WHERE _id=327066;
UPDATE "Users" SET "telephone"='33680682570' WHERE _id=327081;
UPDATE "Users" SET "telephone"='33680682570' WHERE _id=327087;
UPDATE "Users" SET "telephone"='33680682570' WHERE _id=327239;
UPDATE "Users" SET "telephone"='' WHERE _id=327261;
UPDATE "Users" SET "telephone"='33696096810' WHERE _id=327515;
UPDATE "Users" SET "telephone"='33685213645' WHERE _id=327570;
UPDATE "Users" SET "telephone"='33699799592' WHERE _id=327598;
UPDATE "Users" SET "telephone"='33680682570' WHERE _id=327715;
UPDATE "Users" SET "telephone"='33634096310' WHERE _id=327802;
UPDATE "Users" SET "telephone"='33684297254' WHERE _id=327861;
UPDATE "Users" SET "telephone"='33696260336' WHERE _id=327996;
UPDATE "Users" SET "telephone"='33622777578' WHERE _id=328249;
UPDATE "Users" SET "telephone"='33277468637' WHERE _id=328304;
UPDATE "Users" SET "telephone"='33661369940' WHERE _id=328347;
UPDATE "Users" SET "telephone"='33751588168' WHERE _id=328443;
UPDATE "Users" SET "telephone"='33625975240' WHERE _id=328834;
UPDATE "Users" SET "telephone"='' WHERE _id=328888;
UPDATE "Users" SET "telephone"='33647788056' WHERE _id=328914;
UPDATE "Users" SET "telephone"='33655730777' WHERE _id=328954;
UPDATE "Users" SET "telephone"='' WHERE _id=328991;
UPDATE "Users" SET "telephone"='33659766921' WHERE _id=329103;
UPDATE "Users" SET "telephone"='33668362110' WHERE _id=329108;
UPDATE "Users" SET "telephone"='33603684226' WHERE _id=329272;
UPDATE "Users" SET "telephone"='33753506327' WHERE _id=329342;
UPDATE "Users" SET "telephone"='33641074968' WHERE _id=329452;
UPDATE "Users" SET "telephone"='33629102765' WHERE _id=329487;
UPDATE "Users" SET "telephone"='33625480299' WHERE _id=329493;
UPDATE "Users" SET "telephone"='33787076719' WHERE _id=329597;
UPDATE "Users" SET "telephone"='33698687601' WHERE _id=329599;
UPDATE "Users" SET "telephone"='33630866566' WHERE _id=329735;
UPDATE "Users" SET "telephone"='33629747569' WHERE _id=329757;
UPDATE "Users" SET "telephone"='33672655877' WHERE _id=329955;
UPDATE "Users" SET "telephone"='33662994035' WHERE _id=330101;
UPDATE "Users" SET "telephone"='33634618570' WHERE _id=330115;
UPDATE "Users" SET "telephone"='33788998682' WHERE _id=330308;
UPDATE "Users" SET "telephone"='33753586662' WHERE _id=330343;
UPDATE "Users" SET "telephone"='33652553518' WHERE _id=330398;
UPDATE "Users" SET "telephone"='33609038224' WHERE _id=330418;
UPDATE "Users" SET "telephone"='33486996641' WHERE _id=330494;
UPDATE "Users" SET "telephone"='33652491647' WHERE _id=330583;
UPDATE "Users" SET "telephone"='33696185178' WHERE _id=330643;
UPDATE "Users" SET "telephone"='14388228642' WHERE _id=330681;
UPDATE "Users" SET "telephone"='33662693801' WHERE _id=330711;
UPDATE "Users" SET "telephone"='33606645878' WHERE _id=330791;
UPDATE "Users" SET "telephone"='33649610537' WHERE _id=330978;
UPDATE "Users" SET "telephone"='33641022802' WHERE _id=331202;
UPDATE "Users" SET "telephone"='33621135777' WHERE _id=331291;
UPDATE "Users" SET "telephone"='5519997551321' WHERE _id=331316;
UPDATE "Users" SET "telephone"='33762397519' WHERE _id=331356;
UPDATE "Users" SET "telephone"='33658950651' WHERE _id=331547;
UPDATE "Users" SET "telephone"='33756399471' WHERE _id=331626;
UPDATE "Users" SET "telephone"='12024217228' WHERE _id=331668;
UPDATE "Users" SET "telephone"='33769368790' WHERE _id=331690;
UPDATE "Users" SET "telephone"='33606861135' WHERE _id=331767;
UPDATE "Users" SET "telephone"='33651557452' WHERE _id=331858;
UPDATE "Users" SET "telephone"='33603779143' WHERE _id=331914;
UPDATE "Users" SET "telephone"='33758411836' WHERE _id=331965;
UPDATE "Users" SET "telephone"='24104391968' WHERE _id=331988;
UPDATE "Users" SET "telephone"='' WHERE _id=332161;
UPDATE "Users" SET "telephone"='' WHERE _id=332163;
UPDATE "Users" SET "telephone"='' WHERE _id=332175;
UPDATE "Users" SET "telephone"='33782806270' WHERE _id=332252;
UPDATE "Users" SET "telephone"='33651805046' WHERE _id=332338;
UPDATE "Users" SET "telephone"='27780249944' WHERE _id=332339;
UPDATE "Users" SET "telephone"='' WHERE _id=332362;
UPDATE "Users" SET "telephone"='33621036270' WHERE _id=332377;
UPDATE "Users" SET "telephone"='33669287984' WHERE _id=332531;
UPDATE "Users" SET "telephone"='33659030283' WHERE _id=332538;
UPDATE "Users" SET "telephone"='33699147948' WHERE _id=332564;
UPDATE "Users" SET "telephone"='' WHERE _id=332565;
UPDATE "Users" SET "telephone"='' WHERE _id=332586;
UPDATE "Users" SET "telephone"='' WHERE _id=332736;
UPDATE "Users" SET "telephone"='33680682570' WHERE _id=332884;
UPDATE "Users" SET "telephone"='33781605832' WHERE _id=332904;
UPDATE "Users" SET "telephone"='33651203007' WHERE _id=332905;
UPDATE "Users" SET "telephone"='221770642521' WHERE _id=332915;
UPDATE "Users" SET "telephone"='245955203273' WHERE _id=332923;
UPDATE "Users" SET "telephone"='12816179062' WHERE _id=333140;
UPDATE "Users" SET "telephone"='22558293748' WHERE _id=333201;
UPDATE "Users" SET "telephone"='22892036083' WHERE _id=333331;
UPDATE "Users" SET "telephone"='2252138129' WHERE _id=333336;