Untitled

SELECT  distinct concat(cod_producto_origen,num_poliza,id_certificado_origen) ,id_poliza ,num_poliza, id_certificado_origen , des_canal ,des_subcanal,nom_intermediario, fec_emision

FROM `rs-shr-al-analyticsz-prj-ebc1.anl_produccion.poliza`

WHERE true
and concat(cod_producto_origen,num_poliza,id_certificado_origen) in
(
"2101131432914",
"21019528615351",
"21011289277359",
"21011289277360",
"21011289277361",
"2101131051717",
"210113132901",
"210113141211",
"2101131859724",
"2101131860419",
"2101131051724",
"210113134841",
"2101129564120",
"210113170721",
"210113148221",
"20017555282577",
"2001755529586",
"2001755529587",
"2001755529591",
"20017552216858",
"2001755530424",
"210113188211",
"210113138821",
"2001755530431",
"20017555313374",
"20017555313378",
"20017555313383",
"20017555313387",
"20017555313402",
"20017555313403",
"20017555313408",
"20017555313410",
"20017555313421",
"20017555313427",
"20017555313437",
"20017555313454",
"20017555313456",
"210113175601",
"210113140891",
"201650209194",
"210113178171",
"2001756857148",
"2001756857157",
"2001756857208",
"2001756857217",
"200171688883854",
"20017552243332",
"200175687861",
"200171688883025",
"200171688883028",
"200171688884132",
"200171688884151",
"20017552235942",
"200171688883269",
"20017555282521",
"20017555282528",
"20017555282529",
"20017555282550",
"20017555282552",
"20017555282555",
"20017555282562",
"20017555282563",
"20017555282573",
"200384755591",
"200384740941",
"200384741271",
"200384837441",
"200384803151",
"200384796301",
"200384796801",
"200384820011",
"200384785001",
"200384785011",
"200384785021",
"200384785031",
"200384785041",
"200384785051",
"200384785061",
"200384785071",
"200384785081",
"200384785091",
"200384785101",
"200384752621",
"200384830651",
"200384790101",
"200384790131",
"200384790141",
"200384790161",
"200384790181",
"200384790191",
"200384790231",
"200384790261",
"200384790281",
"200384790301",
"200384790321",
"200382707691",
"200384785371",
"200384785381",
"200384785391",
"200384785401",
"200384785411",
"200384785421",
"200384785431",
"200384785441",
"200384785451",
"200384785461",
"200384785471",
"200384785941",
"200384785951",
"200384785961",
"200384785971",
"200384785981",
"200384785991",
"200384786001",
"200384786011",
"200384786021",
"200384786031",
"200384786221",
"200384733661",
"200384841631",
"200382724071",
"200384825491",
"200384814021",
"200384842101",
"200384842131",
"200384842141",
"200384842151",
"200384842161",
"200384842461",
"200384795331",
"200384742771",
"200384814581",
"200384835271",
"200384742841",
"200384818821",
"200384809981",
"200382689901",
"200384801391",
"200384801631",
"200384801681",
"200382708421",
"200384802141",
"200384802251",
"200384813521",
"200384737221",
"200384823561",
"200384732931",
"200384872441",
"200385008971",
"200384852501",
"200384908741",
"200384969981",
"200384930661",
"200384988941",
"200384989161",
"200384893911",
"200385046621",
"200384986581",
"200384986991",
"200384912551",
"200382712011",
"200384987751",
"200384971461",
"200384850091",
"200384910331",
"200384989461",
"200384774021",
"200385003271",
"200384967501",
"200384846291",
"200385021091",
"200382825801",
"2003816445010",
"2003816445010",
"200384962781",
"200384867511",
"200385041161",
"200382696021",
"200382696471",
"200384791381",
"200384848141",
"200384765351",
"200382720881",
"200382720951",
"200384998911",
"200384905001",
"200384905011",
"200384905021",
"200384905031",
"200384905041",
"200384905051",
"200384905061",
"200384905071",
"200384848531",
"200384766461",
"200384776221",
"200384842471",
"200384842481",
"200385034711",
"200384923871",
"200382725621",
"200384889001",
"200385053841",
"200385037451",
"200384946251",
"200384906311",
"200380397261",
"200385001151",
"200384965461",
"200382697621",
"200382700081",
"200382700151",
"200384901201",
"200384902621",
"200384902631",
"200384902641",
"200384902651",
"200384902661",
"200384902671",
"200384902681",
"200384902691",
"200384883801",
"200384845201",
"200382716921",
"200384767511",
"200384784481",
"200384948351",
"200382714151",
"200384755871",
"200385039451",
"200385048081",
"200384995471",
"200384977681",
"200385048601",
"200385049101",
"200385041361",
"200384857361",
"200384896771",
"200384897311",
"200384897321",
"200384897381",
"200384897651",
"200384897801",
"200385050361",
"200385050431",
"200384881071",
"200384861031",
"21011274028502",
"210113311991",
"2101132993011",
"210113293314",
"210113276311",
"210113295861",
"21011332205312",
"21011332205313",
"21011332205314",
"21011332205315",
"2101133264045",
"210113156428",
"21011332205170",
"21011332205171",
"21011332205172",
"210111279101",
"210111279931",
"210113304231",
"210113275401",
"2101132967915",
"2101132967921",
"210113276882",
"210113272521",
"210111280461",
"2001755532189",
"20017567213192",
"200171688886635",
"20017555282672",
"20017555282673",
"20017555282677",
"20017552236662",
"20017555282679",
"20017555282682",
"2001755529626",
"2001755530462",
"20017555313593",
"20017567213031",
"21011333680176",
"21011333680177",
"21011333680178",
"21011333680179",
"21011333680180",
"21011333680181",
"21011333680189",
"21011333680190",
"21011333680191",
"21011333680192",
"20016316131",
"20016507308640",
"20017567212863",
"20017567212895",
"20017555313640",
"20017555313660",
"200171688886929",
"20017567213347",
"20017567213348",
"210113321751",
"200383173511",
"2101133343220",
"200383247571",
"21011304296161",
"210113313431",
"200385531191",
"200385444711",
"200385557361",
"200385574301",
"200385619181",
"200385457611",
"200385621431",
"200385460751",
"200385472951",
"200385571581",
"200385458041",
"200385547931",
"200385495481",
"200385621961",
"200385470891",
"200385487271",
"200385487271",
"200385512071",
"200385449091",
"200385521711",
"200385459781",
"200385459791",
"200385459801",
"200385459811",
"200385635561",
"200385448191",
"200385519691",
"200385479561",
"200385629871",
"200385532281",
"200385444071",
"200383234341",
"20037864642307",
"20037864642307",
"200311872311",
"20037864642256",
"20037864642256",
"200383180971",
"200385654491",
"200385817461",
"200385666351",
"200385745021",
"200385771281",
"200385808981",
"200385685211",
"200385798261",
"200385659851",
"200385684291",
"200385684311",
"200385720491",
"200385685551",
"200385722611",
"200385722651",
"200385676351",
"200385764881",
"200385765421",
"200385765451",
"200385816921",
"200385775451",
"200385778191",
"200385799031",
"200385787481",
"200385700331",
"200385700991",
"200385790071",
"200385790281",
"200385691241",
"200385791391",
"200385711851",
"200385799861",
"200385712151",
"200385723431",
"200385724101",
"200385739241",
"200385726991",
"200385748341",
"200385748621",
"200385748661",
"200385664141",
"200385750561",
"200385721041",
"200385733361",
"200385796651",
"200385809691",
"200385671211",
"200385709351",
"200385786381",
"200385488231",
"200385588891",
"200385539701",
"200385450731",
"200385730611",
"200385515331",
"200385453011",
"200385742821",
"200385528041",
"200385742851",
"200385742881",
"200385742901",
"200385742911",
"200385742921",
"200385742951",
"200385742961",
"200385743061",
"200385743071",
"200385743081",
"200385743091",
"200385743101",
"200385743111",
"200385743121",
"200385743131",
"200385743141",
"200385743151",
"200385743161",
"200385743171",
"200385743181",
"200385743191",
"200385743201",
"200385743211",
"200385743221",
"200385743231",
"200385743241",
"200385743251",
"200385743261",
"200385643441",
"200385732191",
"200385540921",
"200385755631",
"200385755671",
"200385453671",
"200385756101",
"200385756301",
"200385656171",
"200385756901",
"200385441201",
"200385592321",
"200385565741",
"200385615581",
"200385615871",
"200385793901",
"200385782291",
"200385683981",
"200385553941",
"200385707641",
"200385591431",
"200385487931",
"200383240391",
"20017555313693",
"20017555313707",
"20017555313710",
"20017555313711",
"20017555313731",
"20017555313743",
"20017555313750",
"20017555313753",
"20017555313756",
"20017555313763",
"2001757039160",
"2101133908195",
"2101133908196",
"2101133908197",
"2101133908198",
"200171688887905",
"20017555313782",
"20017555313785",
"200171688887375",
"20017555313809",
"210113395162",
"20017558737",
"20016507308651",
"20016507308652",
"20016507308653",
"20016507308654",
"20017070723735",
"200175705023",
"200171688887006",
"2001757039272",
"2001757039281",
"210113395525",
"2001757039292",
"20017566511469",
"20017566511470",
"20017566511471",
"20017566511472",
"2001757039305",
"2001757039317",
"2001757093165",
"2001757093166",
"21011339081114",
"21011339081115",
"21011339081116",
"2001757039353",
"2001757039364",
"200175709161",
"210113398611",
"200171688887492",
"200171688887506",
"20017555282696",
"2001755529630",
"200171688887527",
"20017541102531",
"20017541102532",
"20017541102533",
"2101133590446",
"210113373841",
"210113343741",
"210113343742",
"210113343743",
"210113373561",
"210113364761",
"210113380601",
"210113380621",
"2101126622158",
"210111282141",
"210111282361",
"2101133558242",
"210113354811",
"21011289277367",
"21011289277368",
"21011289277369",
"21011289277370",
"21011289277371",
"21011289277372",
"21011289277373",
"21011289277375",
"200386023261",
"200386004231",
"200385889231",
"200386024601",
"200385864341",
"200385891011",
"200385930501",
"200385918321",
"200385916781",
"200385903561",
"200385914201",
"200385987991",
"200385927031",
"200385854941",
"200385893891",
"200385922871",
"200385986291",
"200385958821",
"200385958831",
"200385958841",
"200385958851",
"200385958861",
"200385935431",
"200385872901",
"200386034251",
"200385958871",
"200385958881",
"200385958891",
"200385958901",
"200385958911",
"200385958921",
"200385958931",
"200385958941",
"200385958951",
"200385958961",
"200385958971",
"200385958981",
"200385958991",
"200385959001",
"200385959011",
"200385959021",
"200385959031",
"200385959041",
"200385959051",
"200385959061",
"200385959071",
"200385959081",
"200385959091",
"200385959101",
"200385959111",
"200385959121",
"200385959131",
"200385959141",
"200385959151",
"200385959161",
"200385959171",
"200385959181",
"200385997221",
"200386034501",
"200385924861",
"200385924921",
"200385924931",
"200385925171",
"200385921591",
"200385921641",
"200386009291",
"200386009371",
"200385972651",
"200385937491",
"200385938201",
"200385981991",
"200385973061",
"200385973071",
"200385973081",
"200385973091",
"200385973101",
"200385973111",
"200385896921",
"200386033491",
"200385998211",
"200385924261",
"200385886511",
"200385973121",
"200385973131",
"200385973141",
"200385973151",
"200385973161",
"200385973581",
"200385973631",
"200385973641",
"200385973651",
"200385973661",
"200385973671",
"200385973681",
"200385973691",
"200385973701",
"200385973711",
"200385973721",
"200385973731",
"200386048111",
"200385912681",
"200385912851",
"200386008331",
"200386008391",
"200385971801",
"200385859671",
"200385957541",
"200385981101",
"200386041311",
"200385881041",
"200385921011",
"200385843161",
"200385980301",
"200385846971",
"200385847001",
"200383326981",
"200385824111",
"200385845011",
"200383337821",
"200386062291",
"200386052381",
"200386074891",
"200386076831",
"200386066771",
"200386088541",
"200386088581",
"200386057451",
"200386071901",
"200386083501",
"200386055371",
"200386064721"
)