Untitled
unknown
sql
6 months ago
16 kB
7
Indexable
Never
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" )