Untitled

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

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

WHERE true
and concat(cod_producto_origen,num_poliza,id_certificado_origen,EXTRACT(YEAR FROM periodo),"0",EXTRACT(MONTH FROM periodo)) in
(
"2101131432914202301",
"21019528615351202301",
"21011289277359202301",
"21011289277360202301",
"21011289277361202301",
"2101131051717202301",
"210113132901202301",
"210113141211202301",
"2101131859724202301",
"2101131860419202301",
"2101131051724202301",
"210113134841202301",
"2101129564120202301",
"210113170721202301",
"210113148221202301",
"20017555282577202301",
"2001755529586202301",
"2001755529587202301",
"2001755529591202301",
"20017552216858202301",
"2001755530424202301",
"210113188211202301",
"210113138821202301",
"2001755530431202301",
"20017555313374202301",
"20017555313378202301",
"20017555313383202301",
"20017555313387202301",
"20017555313402202301",
"20017555313403202301",
"20017555313408202301",
"20017555313410202301",
"20017555313421202301",
"20017555313427202301",
"20017555313437202301",
"20017555313454202301",
"20017555313456202301",
"210113175601202301",
"210113140891202301",
"201650209194202301",
"210113178171202301",
"2001756857148202301",
"2001756857157202301",
"2001756857208202301",
"2001756857217202301",
"200171688883854202301",
"20017552243332202301",
"200175687861202301",
"200171688883025202301",
"200171688883028202301",
"200171688884132202301",
"200171688884151202301",
"20017552235942202301",
"200171688883269202301",
"20017555282521202301",
"20017555282528202301",
"20017555282529202301",
"20017555282550202301",
"20017555282552202301",
"20017555282555202301",
"20017555282562202301",
"20017555282563202301",
"20017555282573202301",
"200384755591202301",
"200384740941202301",
"200384741271202301",
"200384837441202301",
"200384803151202301",
"200384796301202301",
"200384796801202301",
"200384820011202301",
"200384785001202301",
"200384785011202301",
"200384785021202301",
"200384785031202301",
"200384785041202301",
"200384785051202301",
"200384785061202301",
"200384785071202301",
"200384785081202301",
"200384785091202301",
"200384785101202301",
"200384752621202301",
"200384830651202301",
"200384790101202301",
"200384790131202301",
"200384790141202301",
"200384790161202301",
"200384790181202301",
"200384790191202301",
"200384790231202301",
"200384790261202301",
"200384790281202301",
"200384790301202301",
"200384790321202301",
"200382707691202301",
"200384785371202301",
"200384785381202301",
"200384785391202301",
"200384785401202301",
"200384785411202301",
"200384785421202301",
"200384785431202301",
"200384785441202301",
"200384785451202301",
"200384785461202301",
"200384785471202301",
"200384785941202301",
"200384785951202301",
"200384785961202301",
"200384785971202301",
"200384785981202301",
"200384785991202301",
"200384786001202301",
"200384786011202301",
"200384786021202301",
"200384786031202301",
"200384786221202301",
"200384733661202301",
"200384841631202301",
"200382724071202301",
"200384825491202301",
"200384814021202301",
"200384842101202301",
"200384842131202301",
"200384842141202301",
"200384842151202301",
"200384842161202301",
"200384842461202301",
"200384795331202301",
"200384742771202301",
"200384814581202301",
"200384835271202301",
"200384742841202301",
"200384818821202301",
"200384809981202301",
"200382689901202301",
"200384801391202301",
"200384801631202301",
"200384801681202301",
"200382708421202301",
"200384802141202301",
"200384802251202301",
"200384813521202301",
"200384737221202301",
"200384823561202301",
"200384732931202301",
"200384872441202301",
"200385008971202301",
"200384852501202301",
"200384908741202301",
"200384969981202301",
"200384930661202301",
"200384988941202301",
"200384989161202301",
"200384893911202301",
"200385046621202301",
"200384986581202301",
"200384986991202301",
"200384912551202301",
"200382712011202301",
"200384987751202301",
"200384971461202301",
"200384850091202301",
"200384910331202301",
"200384989461202301",
"200384774021202301",
"200385003271202301",
"200384967501202301",
"200384846291202301",
"200385021091202301",
"200382825801202301",
"2003816445010202301",
"2003816445010202301",
"200384962781202301",
"200384867511202301",
"200385041161202301",
"200382696021202301",
"200382696471202301",
"200384791381202301",
"200384848141202301",
"200384765351202301",
"200382720881202301",
"200382720951202301",
"200384998911202301",
"200384905001202301",
"200384905011202301",
"200384905021202301",
"200384905031202301",
"200384905041202301",
"200384905051202301",
"200384905061202301",
"200384905071202301",
"200384848531202301",
"200384766461202301",
"200384776221202301",
"200384842471202301",
"200384842481202301",
"200385034711202301",
"200384923871202301",
"200382725621202301",
"200384889001202301",
"200385053841202301",
"200385037451202301",
"200384946251202301",
"200384906311202301",
"200380397261202301",
"200385001151202301",
"200384965461202301",
"200382697621202301",
"200382700081202301",
"200382700151202301",
"200384901201202301",
"200384902621202301",
"200384902631202301",
"200384902641202301",
"200384902651202301",
"200384902661202301",
"200384902671202301",
"200384902681202301",
"200384902691202301",
"200384883801202301",
"200384845201202301",
"200382716921202301",
"200384767511202301",
"200384784481202301",
"200384948351202301",
"200382714151202301",
"200384755871202301",
"200385039451202301",
"200385048081202301",
"200384995471202301",
"200384977681202301",
"200385048601202301",
"200385049101202301",
"200385041361202301",
"200384857361202301",
"200384896771202301",
"200384897311202301",
"200384897321202301",
"200384897381202301",
"200384897651202301",
"200384897801202301",
"200385050361202301",
"200385050431202301",
"200384881071202301",
"200384861031202301",
"21011274028502202303",
"210113311991202303",
"2101132993011202303",
"210113293314202303",
"210113276311202303",
"210113295861202303",
"21011332205312202303",
"21011332205313202303",
"21011332205314202303",
"21011332205315202303",
"2101133264045202303",
"210113156428202303",
"21011332205170202303",
"21011332205171202303",
"21011332205172202303",
"210111279101202303",
"210111279931202303",
"210113304231202303",
"210113275401202303",
"2101132967915202303",
"2101132967921202303",
"210113276882202303",
"210113272521202303",
"210111280461202303",
"2001755532189202303",
"20017567213192202303",
"200171688886635202303",
"20017555282672202303",
"20017555282673202303",
"20017555282677202303",
"20017552236662202303",
"20017555282679202303",
"20017555282682202303",
"2001755529626202303",
"2001755530462202303",
"20017555313593202303",
"20017567213031202303",
"21011333680176202303",
"21011333680177202303",
"21011333680178202303",
"21011333680179202303",
"21011333680180202303",
"21011333680181202303",
"21011333680189202303",
"21011333680190202303",
"21011333680191202303",
"21011333680192202303",
"20016316131202303",
"20016507308640202303",
"20017567212863202303",
"20017567212895202303",
"20017555313640202303",
"20017555313660202303",
"200171688886929202303",
"20017567213347202303",
"20017567213348202303",
"210113321751202303",
"200383173511202303",
"2101133343220202303",
"200383247571202303",
"21011304296161202303",
"210113313431202303",
"200385531191202303",
"200385444711202303",
"200385557361202303",
"200385574301202303",
"200385619181202303",
"200385457611202303",
"200385621431202303",
"200385460751202303",
"200385472951202303",
"200385571581202303",
"200385458041202303",
"200385547931202303",
"200385495481202303",
"200385621961202303",
"200385470891202303",
"200385487271202303",
"200385487271202303",
"200385512071202303",
"200385449091202303",
"200385521711202303",
"200385459781202303",
"200385459791202303",
"200385459801202303",
"200385459811202303",
"200385635561202303",
"200385448191202303",
"200385519691202303",
"200385479561202303",
"200385629871202303",
"200385532281202303",
"200385444071202303",
"200383234341202303",
"20037864642307202303",
"20037864642307202303",
"200311872311202303",
"20037864642256202303",
"20037864642256202303",
"200383180971202303",
"200385654491202303",
"200385817461202303",
"200385666351202303",
"200385745021202303",
"200385771281202303",
"200385808981202303",
"200385685211202303",
"200385798261202303",
"200385659851202303",
"200385684291202303",
"200385684311202303",
"200385720491202303",
"200385685551202303",
"200385722611202303",
"200385722651202303",
"200385676351202303",
"200385764881202303",
"200385765421202303",
"200385765451202303",
"200385816921202303",
"200385775451202303",
"200385778191202303",
"200385799031202303",
"200385787481202303",
"200385700331202303",
"200385700991202303",
"200385790071202303",
"200385790281202303",
"200385691241202303",
"200385791391202303",
"200385711851202303",
"200385799861202303",
"200385712151202303",
"200385723431202303",
"200385724101202303",
"200385739241202303",
"200385726991202303",
"200385748341202303",
"200385748621202303",
"200385748661202303",
"200385664141202303",
"200385750561202303",
"200385721041202303",
"200385733361202303",
"200385796651202303",
"200385809691202303",
"200385671211202303",
"200385709351202303",
"200385786381202303",
"200385488231202303",
"200385588891202303",
"200385539701202303",
"200385450731202303",
"200385730611202303",
"200385515331202303",
"200385453011202303",
"200385742821202303",
"200385528041202303",
"200385742851202303",
"200385742881202303",
"200385742901202303",
"200385742911202303",
"200385742921202303",
"200385742951202303",
"200385742961202303",
"200385743061202303",
"200385743071202303",
"200385743081202303",
"200385743091202303",
"200385743101202303",
"200385743111202303",
"200385743121202303",
"200385743131202303",
"200385743141202303",
"200385743151202303",
"200385743161202303",
"200385743171202303",
"200385743181202303",
"200385743191202303",
"200385743201202303",
"200385743211202303",
"200385743221202303",
"200385743231202303",
"200385743241202303",
"200385743251202303",
"200385743261202303",
"200385643441202303",
"200385732191202303",
"200385540921202303",
"200385755631202303",
"200385755671202303",
"200385453671202303",
"200385756101202303",
"200385756301202303",
"200385656171202303",
"200385756901202303",
"200385441201202303",
"200385592321202303",
"200385565741202303",
"200385615581202303",
"200385615871202303",
"200385793901202303",
"200385782291202303",
"200385683981202303",
"200385553941202303",
"200385707641202303",
"200385591431202303",
"200385487931202303",
"200383240391202303",
"20017555313693202304",
"20017555313707202304",
"20017555313710202304",
"20017555313711202304",
"20017555313731202304",
"20017555313743202304",
"20017555313750202304",
"20017555313753202304",
"20017555313756202304",
"20017555313763202304",
"2001757039160202304",
"2101133908195202304",
"2101133908196202304",
"2101133908197202304",
"2101133908198202304",
"200171688887905202304",
"20017555313782202304",
"20017555313785202304",
"200171688887375202304",
"20017555313809202304",
"210113395162202304",
"20017558737202304",
"20016507308651202304",
"20016507308652202304",
"20016507308653202304",
"20016507308654202304",
"20017070723735202304",
"200175705023202304",
"200171688887006202304",
"2001757039272202304",
"2001757039281202304",
"210113395525202304",
"2001757039292202304",
"20017566511469202304",
"20017566511470202304",
"20017566511471202304",
"20017566511472202304",
"2001757039305202304",
"2001757039317202304",
"2001757093165202304",
"2001757093166202304",
"21011339081114202304",
"21011339081115202304",
"21011339081116202304",
"2001757039353202304",
"2001757039364202304",
"200175709161202304",
"210113398611202304",
"200171688887492202304",
"200171688887506202304",
"20017555282696202304",
"2001755529630202304",
"200171688887527202304",
"20017541102531202304",
"20017541102532202304",
"20017541102533202304",
"2101133590446202304",
"210113373841202304",
"210113343741202304",
"210113343742202304",
"210113343743202304",
"210113373561202304",
"210113364761202304",
"210113380601202304",
"210113380621202304",
"2101126622158202304",
"210111282141202304",
"210111282361202304",
"2101133558242202304",
"210113354811202304",
"21011289277367202304",
"21011289277368202304",
"21011289277369202304",
"21011289277370202304",
"21011289277371202304",
"21011289277372202304",
"21011289277373202304",
"21011289277375202304",
"200386023261202304",
"200386004231202304",
"200385889231202304",
"200386024601202304",
"200385864341202304",
"200385891011202304",
"200385930501202304",
"200385918321202304",
"200385916781202304",
"200385903561202304",
"200385914201202304",
"200385987991202304",
"200385927031202304",
"200385854941202304",
"200385893891202304",
"200385922871202304",
"200385986291202304",
"200385958821202304",
"200385958831202304",
"200385958841202304",
"200385958851202304",
"200385958861202304",
"200385935431202304",
"200385872901202304",
"200386034251202304",
"200385958871202304",
"200385958881202304",
"200385958891202304",
"200385958901202304",
"200385958911202304",
"200385958921202304",
"200385958931202304",
"200385958941202304",
"200385958951202304",
"200385958961202304",
"200385958971202304",
"200385958981202304",
"200385958991202304",
"200385959001202304",
"200385959011202304",
"200385959021202304",
"200385959031202304",
"200385959041202304",
"200385959051202304",
"200385959061202304",
"200385959071202304",
"200385959081202304",
"200385959091202304",
"200385959101202304",
"200385959111202304",
"200385959121202304",
"200385959131202304",
"200385959141202304",
"200385959151202304",
"200385959161202304",
"200385959171202304",
"200385959181202304",
"200385997221202304",
"200386034501202304",
"200385924861202304",
"200385924921202304",
"200385924931202304",
"200385925171202304",
"200385921591202304",
"200385921641202304",
"200386009291202304",
"200386009371202304",
"200385972651202304",
"200385937491202304",
"200385938201202304",
"200385981991202304",
"200385973061202304",
"200385973071202304",
"200385973081202304",
"200385973091202304",
"200385973101202304",
"200385973111202304",
"200385896921202304",
"200386033491202304",
"200385998211202304",
"200385924261202304",
"200385886511202304",
"200385973121202304",
"200385973131202304",
"200385973141202304",
"200385973151202304",
"200385973161202304",
"200385973581202304",
"200385973631202304",
"200385973641202304",
"200385973651202304",
"200385973661202304",
"200385973671202304",
"200385973681202304",
"200385973691202304",
"200385973701202304",
"200385973711202304",
"200385973721202304",
"200385973731202304",
"200386048111202304",
"200385912681202304",
"200385912851202304",
"200386008331202304",
"200386008391202304",
"200385971801202304",
"200385859671202304",
"200385957541202304",
"200385981101202304",
"200386041311202304",
"200385881041202304",
"200385921011202304",
"200385843161202304",
"200385980301202304",
"200385846971202304",
"200385847001202304",
"200383326981202304",
"200385824111202304",
"200385845011202304",
"200383337821202304",
"200386062291202304",
"200386052381202304",
"200386074891202304",
"200386076831202304",
"200386066771202304",
"200386088541202304",
"200386088581202304",
"200386057451202304",
"200386071901202304",
"200386083501202304",
"200386055371202304",
"200386064721202304"
)