CRMLS CRIB-RETS Duplicate Listing Records Purge

### RAW

QUERY='{"query":{"bool":{"must":[{"term":{"_mls":"crmls"}},{"terms": {"ListingId":["315004795","218002386","218006981","218007251","218010956","218011911","218012340","219000169","219000990","219000991","219000999","219001002","219001005","219001007","219001009","219001053","219001810","219003414","219003582","219003974","219004628","219005122","219005208","219005467","219005987","219006699","219006947","219007451","219007560","219008059","219008609","219008751","219008801","219008924","219009426","219009816","219009868","219010054","219010082","219010226","219010229","219010341","219010379","219010390","219010471","219010712","219010743","219010742","219010785","219010816","219010909","219010988","219011040","219011098","219011182","219011198","219011320","219011372","219011471","219011475","219011485","219011551","219011556","219011706","219011728","219011734","219011773","219011874","219011886","219011896","219011903","219012031","219012057","219012058","219012067","219012070","219012091","219012093","219012096","219012128","219012148","219012169","219012181","219012224","219012251","219012285","219012312","219012336","219012408","219012534","219012569","219012571","219012584","219012593","219012678","219012687","219012692","219012697","219012720","219012732","219012745","219012761","219012769","219012789","219012895","219012909","219012964","219012973","219012979","219012986","219013057","219013065","219013210","219013233","219013272","219013285","219013286","219013297","219013329","219013385","219013395","219013513","219013512","219013556","219013557","219013622","219013701","219013749","219013781","219013823","219013837","219013882","219013901","219013908","219013920","219013936","219013950","219013971","219014024","219014052","219014084","219014087","219014119","219014146","219014150","219014230","219014239","219014256","219014284","219014290","219014299","219014309","219014345","219014357","219014363","219014410","219014419","219014426","219014438","219014460","219014562","219014567","219014570","219014596","219014634","219014651","219014692","219014711","219014741","219014757","219014768","219014806","219014808","219014818","219014820","219014830","219014846","220000012","220000070","220000078","220000091","220000138","220000152","220000184","220000201","220000209","220000215","220000216","220000251","220000257","220000284","220000293","220000296","220000346","220000377","220000383","220000413","220000429","220000453","220000464","220000480","220000487","220000494","220000511","220000513","220000526","220000530","220000553","220000559","220000563","220000603","220000606","220000615","220000642","220000682","220000693","220000698","220000702","220000706","220000712","220000715","220000724","220000731","220000747","220000781","220000808","220000830","220000841","220000875","220000878","220000884","220000898","220000907","220000918","220000927","220000945","220000949","220000956","220000966","220000967","220000969","220000977","220000993","220001029","220001031","220001033","220001041","220001044","220001061","220001079","220001081","220001089","220001097","220001105","220001144","220001154","220001166","220001180","220001185","220001208","220001255","220001271","220001272","220001282","220001311","220001324","220001325","220001329","220001345","220001353","220001371","220001385","220001389","220001395","220000017","220000145","220001322","220001276","220001399","220001411","220001412","220001413","220001423","220001431","220001435","220001442","220001444","220001453","220001469","220001474","220001485","220001507","220001516","220001518","220001527","220001531","220001537","220001543","220001546","220001550"]}}]}}}' INDEX=rets TYPE=listing grunt flushData

---

QUERY='{"query":{"bool":{"must":[{"term":{"_mls":"crmls"}},{"terms": {"ListingId":["220001040","220001567","220000283","220001425","220001572","220001577","220001580","220001586","220001590","220001593","219014564","219014630","220000524","220000752","220000750","220001186","220001048","220000901","220001511","220001596","220001605","220001604","220001609","220001608","220001610","220001612","220001618","220001629","220001630","220001632","220001633","220001644","220001646","220001663","220001667","220001672","220001681","220001694","220001698","220001716","220001718","220001719","220001732","220001733","220001744","220001748","220001750","220001754","220001778","220001780","220001805","220001812","220001815","220001830","220001831","220001838","220001842","220001843","220001846","220001844","220001847","220001851","220001861","220001867","220001869","220001873","220001878","220001886","220001890","220001892","220001899","220001901","220001904","220001906","220001910","220001913","220001917","220001919","220001926","220001934","220001943","220001951","220001952","220001954","220001961","220001964","220001966","220001969","220001971","220001974","220001977","220001990","220001995","220001997","220002011","220002014","220002018","220002044","220002048","220002057","220002061","220002065","220002071","220002078","220002090","220002093","220002098","220002101","220002102","220002103","220002105","220002113","220002117","220002118","220002120","220002122","220002126","220002127","220002138","220002140","220002149","220002155","220002162","220002176","220002182","220002186","220002188","220002191","220002198","220002207","220002210","220002209","220002211","220002222","220002223","220002240","220002242","220002244","220002251","220002254","220002266","220002268","220002270","220002272","220002275","220002289","220002295","220002307","220002313","220002315","220002316","220002317","220002333","220002337","220002345","220002353","220002354","220002356","220002362","220002363","220002367","220002370","220002381","220002382","220002383","220002386","220002387","220002389","220002392","220002399","220002403","220002406","220002410","220002419","220002422","220002429","220002437","220002438","220002439","220002440","220002444","220002449","220002460","220002463","220002465","220002466","220002481","220002484","220002497","220002503","220002516","220002517","220002518","220002525","220002527","220002528","220002539","220002556","220002576","220002584","220002586","220002597","220002604","220002608","220002614","220002619","220002620","220002623","220002636","220002640","220002649","220002651","220002661","220002663","220002665","220002670","220002673","220002677","220002681","220002693","220002700","220002711","220002714","220002716","220002720","220002725","220002726","220002760","220002761","220002763","220002782","220002781","220002784","220002792","220002790","220002791","220002809","220002817","220002819","220002822","220002825","220002823","220002827","220002832","220002833","220002836","220002847","220002848","220002856","220002881","220002882","220002883","220002886","220002892","220002894","220002895","220002898","220002901","220002902","220002905","220002906","220002912","220002918","220002926","220002927","220002932","220002941","220002943","220002947","220002956","220002959","220002963","220002969","220002972","220002975","220002982","220002983","220002984","220002990","220002992","220002995","220003000","220003003","220003014","220003027","220003031","220003033","220003036","220003038","220003039","220003040","220003043","220003049","220003055","220003056","220003058","220003065","220003070","220003071"]}}]}}}' INDEX=rets TYPE=listing grunt flushData

---

QUERY='{"query":{"bool":{"must":[{"term":{"_mls":"crmls"}},{"terms": {"ListingId":["220003076","220003079","220003083","220003086","220003091","220003092","220003094","220003102","220003106","220003109","220003113","220003115","220003122","220003124","220003126","220003127","220003131","220003133","220003139","220003140","220003141","220003144","220003155","220003157","220003159","220003163","220003166","220003167","220003171","220003172","220003178","220003184","220003185","220003187","220003190","220003192","220003201","220003205","220003206","220003207","220003209","220003210","220003217","220003221","220003222","220003223","220003228","220003230","220003234","220003241","220003242","220003244","220003246","220003248","220003256","220003259","220003261","220003265","220003266","220003268","220003270","220003275","220003276","220003278","220003279","220003281","220003285","220003289","220003291","220003294","220003297","220003298","220003301","220003302","220003304","220003306","220003307","220003308","220003310","220003311","220003312","220003314","220003315","220003316","220003317","220003318","220003320","220003321","220003326","220003327","220003328","220003330","220003334","220003336","220003335","220003337","220003339","220003345","220003346","220003350","220003352","220003354","220003356","220003357","220003360","220003362","220003363","220003364","220003365","220003366","220003368","220003371","220003372","220003373","220003376","220003377","220003378","220003379","220003380","220003382","220003384","220003385","220003386","220002265","220003388","220003389","220003391","220003392","220003395","220003399","220003401","220003405","220003406","220003409","220003410","220003411","220003412","220003413","220003415","220003416","220003418","220003419","220003420","220003421","220003422","220003423","220003425","220003426","220003428","220003429","220003432","220003434","220003435","220003436","220003437","220003440","220003439","220003441","220003442","220003444","220003443","220003446","220003447","220003452","220003455","220003456","220003457","220003458","220003459","220003460","220003462","220003464","220003467","220003468","220003472","220003474","220003473","220003470","220003475","220003477","220003476","220003481","220003484","220003485","220003480","220003482","220003486","220003488","220003489","220003490","220003492","220003491","220003493","220003496","220003501","220003502","220003503","220003504","220003505","220003507","220003508","220003509","220003510","220003511","317004964","219008203","219009153","219009652","219010089","219011203","219011321","219011880","219012129","219012147","219012589","219012856","219013452","219013476","219013690","219013865","219014026","219014202","219014226","219014315","219014350","219014530","219014536","219014809","220000073","220000157","220000268","220000364","220000433","220000481","220000593","220000598","220000645","220000673","220000674","220000732","220000751","220001022","220001034","220001113","220001156","220001157","220001158","220001217","220001334","220001340","220001384","220001392","220001508","220001534","220001616","220000858","220000240","220001486","220000196","220000896","220000253","220000948","220000771","220001634","220001669","220001676","220001696","220001722","220001723","220001751","220001835","220001837","220001856","220001893","220002045","220002046","220002081","220002089","220002088","220002134","220002152","220002178","220002206","220002280","220002327","220002344","220002369","220002372","220002400","220002418","220002436","220002470","220002513","220002520","220002521","220002536","220002562","220002566","220002579","220002589","220002607","220002669","220002712","220002736","220002749","220002754","220002758","220002765","220002830","220002845","220002872","220002889","220002890","220002904","220002944","220002964","220002998","220003005","220003052","220003035","220003061","220003078","220003085","220003096","220003114","220003182","220003194","220003200","220003224","220003232","220003255","220003257","220003258","220003273","220003284","220003288","220003290","220003329","220003338","220003340","220003341","220003342","220003343","220003344","220003348","220003349","220003353","220003355","220003374","220003375","220003381","220003383","220003387","220003390","220003393","220003394","220003396","220003398","220003403","220003402","220003414","220003427","220003431","220003430","220003433","220003448","220003451","220003453","220003454","220003461","220003463","220003465","220003466","220003478","220003479","220003483","220003494","220003495","220003497","220003498","220003500","220003499","315007595","315008490","316000961","317001086","317003186","317003970","317004716","219000986","219001856","219006172","219012949","219013437","219013485","220000666","220001129","220001292","220001670","220001725","220001761","220002321","220002560","220002613","220002705","220002768","220003359","220003361","220003408","220003506","217014492","218002154","218012482","218013607","219001624","219003382","219003383","219003387","219003599","219005926","219006928","219007922","219008631","219009600","219009746","219011620","219011944","219011946","219012087","219012208","219012239","219012733","219012851","219012853","219013387","219014206","219014347","219014548","220000005","220000443","220002891","220003351","220003369","220003370","220003397","220003417","220003424","220003438","220003449","219008141","219008195","219008653","219010123","219011199","220002985","220002035","220001541","220002643","220002092","220001611","219013445","220003407","220003006","220001468","220000870","219013234","220002771","220000903","220002338","220001762","220003469","220003471","219013638","220001679","220003487","219014839","220003445","220001420","219014091","219013911","220001740","219014004","219014232","219013666","220003347","220001737","220003358","220001296","220003367","220002019","220003400","220002431","220002277"]}}]}}}' INDEX=rets TYPE=listing grunt flushData


### NORMALIZED

QUERY='{"query":{"bool":{"must":[{"term":{"mls.name":"crmls"}},{"terms": {"mls.mlsNumber":["315004795","218002386","218006981","218007251","218010956","218011911","218012340","219000169","219000990","219000991","219000999","219001002","219001005","219001007","219001009","219001053","219001810","219003414","219003582","219003974","219004628","219005122","219005208","219005467","219005987","219006699","219006947","219007451","219007560","219008059","219008609","219008751","219008801","219008924","219009426","219009816","219009868","219010054","219010082","219010226","219010229","219010341","219010379","219010390","219010471","219010712","219010743","219010742","219010785","219010816","219010909","219010988","219011040","219011098","219011182","219011198","219011320","219011372","219011471","219011475","219011485","219011551","219011556","219011706","219011728","219011734","219011773","219011874","219011886","219011896","219011903","219012031","219012057","219012058","219012067","219012070","219012091","219012093","219012096","219012128","219012148","219012169","219012181","219012224","219012251","219012285","219012312","219012336","219012408","219012534","219012569","219012571","219012584","219012593","219012678","219012687","219012692","219012697","219012720","219012732","219012745","219012761","219012769","219012789","219012895","219012909","219012964","219012973","219012979","219012986","219013057","219013065","219013210","219013233","219013272","219013285","219013286","219013297","219013329","219013385","219013395","219013513","219013512","219013556","219013557","219013622","219013701","219013749","219013781","219013823","219013837","219013882","219013901","219013908","219013920","219013936","219013950","219013971","219014024","219014052","219014084","219014087","219014119","219014146","219014150","219014230","219014239","219014256","219014284","219014290","219014299","219014309","219014345","219014357","219014363","219014410","219014419","219014426","219014438","219014460","219014562","219014567","219014570","219014596","219014634","219014651","219014692","219014711","219014741","219014757","219014768","219014806","219014808","219014818","219014820","219014830","219014846","220000012","220000070","220000078","220000091","220000138","220000152","220000184","220000201","220000209","220000215","220000216","220000251","220000257","220000284","220000293","220000296","220000346","220000377","220000383","220000413","220000429","220000453","220000464","220000480","220000487","220000494","220000511","220000513","220000526","220000530","220000553","220000559","220000563","220000603","220000606","220000615","220000642","220000682","220000693","220000698","220000702","220000706","220000712","220000715","220000724","220000731","220000747","220000781","220000808","220000830","220000841","220000875","220000878","220000884","220000898","220000907","220000918","220000927","220000945","220000949","220000956","220000966","220000967","220000969","220000977","220000993","220001029","220001031","220001033","220001041","220001044","220001061","220001079","220001081","220001089","220001097","220001105","220001144","220001154","220001166","220001180","220001185","220001208","220001255","220001271","220001272","220001282","220001311","220001324","220001325","220001329","220001345","220001353","220001371","220001385","220001389","220001395","220000017","220000145","220001322","220001276","220001399","220001411","220001412","220001413","220001423","220001431","220001435","220001442","220001444","220001453","220001469","220001474","220001485","220001507","220001516","220001518","220001527","220001531","220001537","220001543","220001546","220001550"]}}]}}}' INDEX=listing TYPE=listing grunt flushData

---

QUERY='{"query":{"bool":{"must":[{"term":{"mls.name":"crmls"}},{"terms": {"mls.mlsNumber":["220001040","220001567","220000283","220001425","220001572","220001577","220001580","220001586","220001590","220001593","219014564","219014630","220000524","220000752","220000750","220001186","220001048","220000901","220001511","220001596","220001605","220001604","220001609","220001608","220001610","220001612","220001618","220001629","220001630","220001632","220001633","220001644","220001646","220001663","220001667","220001672","220001681","220001694","220001698","220001716","220001718","220001719","220001732","220001733","220001744","220001748","220001750","220001754","220001778","220001780","220001805","220001812","220001815","220001830","220001831","220001838","220001842","220001843","220001846","220001844","220001847","220001851","220001861","220001867","220001869","220001873","220001878","220001886","220001890","220001892","220001899","220001901","220001904","220001906","220001910","220001913","220001917","220001919","220001926","220001934","220001943","220001951","220001952","220001954","220001961","220001964","220001966","220001969","220001971","220001974","220001977","220001990","220001995","220001997","220002011","220002014","220002018","220002044","220002048","220002057","220002061","220002065","220002071","220002078","220002090","220002093","220002098","220002101","220002102","220002103","220002105","220002113","220002117","220002118","220002120","220002122","220002126","220002127","220002138","220002140","220002149","220002155","220002162","220002176","220002182","220002186","220002188","220002191","220002198","220002207","220002210","220002209","220002211","220002222","220002223","220002240","220002242","220002244","220002251","220002254","220002266","220002268","220002270","220002272","220002275","220002289","220002295","220002307","220002313","220002315","220002316","220002317","220002333","220002337","220002345","220002353","220002354","220002356","220002362","220002363","220002367","220002370","220002381","220002382","220002383","220002386","220002387","220002389","220002392","220002399","220002403","220002406","220002410","220002419","220002422","220002429","220002437","220002438","220002439","220002440","220002444","220002449","220002460","220002463","220002465","220002466","220002481","220002484","220002497","220002503","220002516","220002517","220002518","220002525","220002527","220002528","220002539","220002556","220002576","220002584","220002586","220002597","220002604","220002608","220002614","220002619","220002620","220002623","220002636","220002640","220002649","220002651","220002661","220002663","220002665","220002670","220002673","220002677","220002681","220002693","220002700","220002711","220002714","220002716","220002720","220002725","220002726","220002760","220002761","220002763","220002782","220002781","220002784","220002792","220002790","220002791","220002809","220002817","220002819","220002822","220002825","220002823","220002827","220002832","220002833","220002836","220002847","220002848","220002856","220002881","220002882","220002883","220002886","220002892","220002894","220002895","220002898","220002901","220002902","220002905","220002906","220002912","220002918","220002926","220002927","220002932","220002941","220002943","220002947","220002956","220002959","220002963","220002969","220002972","220002975","220002982","220002983","220002984","220002990","220002992","220002995","220003000","220003003","220003014","220003027","220003031","220003033","220003036","220003038","220003039","220003040","220003043","220003049","220003055","220003056","220003058","220003065","220003070","220003071"]}}]}}}' INDEX=listing TYPE=listing grunt flushData

---

QUERY='{"query":{"bool":{"must":[{"term":{"mls.name":"crmls"}},{"terms": {"mls.mlsNumber":["220003076","220003079","220003083","220003086","220003091","220003092","220003094","220003102","220003106","220003109","220003113","220003115","220003122","220003124","220003126","220003127","220003131","220003133","220003139","220003140","220003141","220003144","220003155","220003157","220003159","220003163","220003166","220003167","220003171","220003172","220003178","220003184","220003185","220003187","220003190","220003192","220003201","220003205","220003206","220003207","220003209","220003210","220003217","220003221","220003222","220003223","220003228","220003230","220003234","220003241","220003242","220003244","220003246","220003248","220003256","220003259","220003261","220003265","220003266","220003268","220003270","220003275","220003276","220003278","220003279","220003281","220003285","220003289","220003291","220003294","220003297","220003298","220003301","220003302","220003304","220003306","220003307","220003308","220003310","220003311","220003312","220003314","220003315","220003316","220003317","220003318","220003320","220003321","220003326","220003327","220003328","220003330","220003334","220003336","220003335","220003337","220003339","220003345","220003346","220003350","220003352","220003354","220003356","220003357","220003360","220003362","220003363","220003364","220003365","220003366","220003368","220003371","220003372","220003373","220003376","220003377","220003378","220003379","220003380","220003382","220003384","220003385","220003386","220002265","220003388","220003389","220003391","220003392","220003395","220003399","220003401","220003405","220003406","220003409","220003410","220003411","220003412","220003413","220003415","220003416","220003418","220003419","220003420","220003421","220003422","220003423","220003425","220003426","220003428","220003429","220003432","220003434","220003435","220003436","220003437","220003440","220003439","220003441","220003442","220003444","220003443","220003446","220003447","220003452","220003455","220003456","220003457","220003458","220003459","220003460","220003462","220003464","220003467","220003468","220003472","220003474","220003473","220003470","220003475","220003477","220003476","220003481","220003484","220003485","220003480","220003482","220003486","220003488","220003489","220003490","220003492","220003491","220003493","220003496","220003501","220003502","220003503","220003504","220003505","220003507","220003508","220003509","220003510","220003511","317004964","219008203","219009153","219009652","219010089","219011203","219011321","219011880","219012129","219012147","219012589","219012856","219013452","219013476","219013690","219013865","219014026","219014202","219014226","219014315","219014350","219014530","219014536","219014809","220000073","220000157","220000268","220000364","220000433","220000481","220000593","220000598","220000645","220000673","220000674","220000732","220000751","220001022","220001034","220001113","220001156","220001157","220001158","220001217","220001334","220001340","220001384","220001392","220001508","220001534","220001616","220000858","220000240","220001486","220000196","220000896","220000253","220000948","220000771","220001634","220001669","220001676","220001696","220001722","220001723","220001751","220001835","220001837","220001856","220001893","220002045","220002046","220002081","220002089","220002088","220002134","220002152","220002178","220002206","220002280","220002327","220002344","220002369","220002372","220002400","220002418","220002436","220002470","220002513","220002520","220002521","220002536","220002562","220002566","220002579","220002589","220002607","220002669","220002712","220002736","220002749","220002754","220002758","220002765","220002830","220002845","220002872","220002889","220002890","220002904","220002944","220002964","220002998","220003005","220003052","220003035","220003061","220003078","220003085","220003096","220003114","220003182","220003194","220003200","220003224","220003232","220003255","220003257","220003258","220003273","220003284","220003288","220003290","220003329","220003338","220003340","220003341","220003342","220003343","220003344","220003348","220003349","220003353","220003355","220003374","220003375","220003381","220003383","220003387","220003390","220003393","220003394","220003396","220003398","220003403","220003402","220003414","220003427","220003431","220003430","220003433","220003448","220003451","220003453","220003454","220003461","220003463","220003465","220003466","220003478","220003479","220003483","220003494","220003495","220003497","220003498","220003500","220003499","315007595","315008490","316000961","317001086","317003186","317003970","317004716","219000986","219001856","219006172","219012949","219013437","219013485","220000666","220001129","220001292","220001670","220001725","220001761","220002321","220002560","220002613","220002705","220002768","220003359","220003361","220003408","220003506","217014492","218002154","218012482","218013607","219001624","219003382","219003383","219003387","219003599","219005926","219006928","219007922","219008631","219009600","219009746","219011620","219011944","219011946","219012087","219012208","219012239","219012733","219012851","219012853","219013387","219014206","219014347","219014548","220000005","220000443","220002891","220003351","220003369","220003370","220003397","220003417","220003424","220003438","220003449","219008141","219008195","219008653","219010123","219011199","220002985","220002035","220001541","220002643","220002092","220001611","219013445","220003407","220003006","220001468","220000870","219013234","220002771","220000903","220002338","220001762","220003469","220003471","219013638","220001679","220003487","219014839","220003445","220001420","219014091","219013911","220001740","219014004","219014232","219013666","220003347","220001737","220003358","220001296","220003367","220002019","220003400","220002431","220002277"]}}]}}}' INDEX=listing TYPE=listing grunt flushData