20120410

-- 03/04/2012 14:28:57
SELECT T265.C1, C536870915, C536870913, C536870914
  FROM T265
 WHERE ((((((T265.C536870930 != 'QUEJAS') AND
       ((((((((((((((((T265.C536870915 = 'DASC.ADMON.ELECT.CAU') OR
       (T265.C536870915 = 'DASC.AGENCIA.CAU')) OR
       (T265.C536870915 = 'DASC.APLIC.INTERNAS.CAU')) OR
       (T265.C536870915 = 'DASC.BOMBEROS.CAU')) OR
       (T265.C536870915 = 'DASC.CAU')) OR
       (T265.C536870915 = 'DASC.CORP.CAU')) OR
       (T265.C536870915 = 'DASC.CORP.GEST.TRIB.CAU')) OR
       (T265.C536870915 = 'DASC.EDU.CAU')) OR
       (T265.C536870915 = 'DASC.EDU.SOP.AVANZ')) OR
       (T265.C536870915 = 'DASC.JUST.CAU')) OR
       (T265.C536870915 = 'DASC.PHEE.CAU')) OR
       (T265.C536870915 = 'DASC.SANIDAD.CAU')) OR
       (T265.C536870915 = 'DASC.SOPTEC.A.FRONT.SERVICE')) OR
       (T265.C536870915 = 'DASC.TEC.AGENCIA.CAU')) OR
       (T265.C536870915 = 'DASC.TELEFONIA.CAU')) OR
       (T265.C536870915 = 'DASC.TMFC.CAU'))) AND
       (T265.C536870953 < 1333404000)) AND
       ((((T265.C536870938 >= 1333404000) AND
       (T265.C536870942 <= 1333404000)) AND
       (((T265.C536870940 != 'Cerrado') AND
       (T265.C536870940 != 'Pend. Confirmación')) AND
       (T265.C536870940 != 'Solucionado'))) OR
       (((T265.C536870938 IS NULL) AND (T265.C536870942 <= 1333404000)) AND
       (((T265.C7 != 6) AND (T265.C7 != 8)) AND (T265.C7 != 5))))) AND
       (T265.C536870920 = T265.C536870915)) AND
       (T265.C536870931 = 'SISTEMAS DE INFORMACION'))
 ORDER BY 1 ASC;
-----------------------------------------------------------------------------
SELECT request_id, grupo2, Area, NumeroLlamada
  FROM join_incidencias_estados
 WHERE ((((((Tipo != 'QUEJAS') AND
       ((((((((((((((((grupo2 = 'DASC.ADMON.ELECT.CAU') OR
       (grupo2 = 'DASC.AGENCIA.CAU')) OR
       (grupo2 = 'DASC.APLIC.INTERNAS.CAU')) OR
       (grupo2 = 'DASC.BOMBEROS.CAU')) OR
       (grupo2 = 'DASC.CAU')) OR
       (grupo2 = 'DASC.CORP.CAU')) OR
       (grupo2 = 'DASC.CORP.GEST.TRIB.CAU')) OR
       (grupo2 = 'DASC.EDU.CAU')) OR
       (grupo2 = 'DASC.EDU.SOP.AVANZ')) OR
       (grupo2 = 'DASC.JUST.CAU')) OR
       (grupo2 = 'DASC.PHEE.CAU')) OR
       (grupo2 = 'DASC.SANIDAD.CAU')) OR
       (grupo2 = 'DASC.SOPTEC.A.FRONT.SERVICE')) OR
       (grupo2 = 'DASC.TEC.AGENCIA.CAU')) OR
       (grupo2 = 'DASC.TELEFONIA.CAU')) OR
       (grupo2 = 'DASC.TMFC.CAU'))) AND
       (FechaHoraEntrada < 1333404000)) AND
       ((((FechaFin >= 1333404000) AND
       (FechaInicio <= 1333404000)) AND
       (((estado_historico != 'Cerrado') AND
       (estado_historico != 'Pend. Confirmación')) AND
       (estado_historico != 'Solucionado'))) OR
       (((FechaFin IS NULL) AND (FechaInicio <= 1333404000)) AND
       (((estado != 6) AND (estado != 8)) AND (estado != 5))))) AND
       (TomadaPorGrupo = grupo2)) AND
       (a1_nivel_producto = 'SISTEMAS DE INFORMACION'))
 ORDER BY 1 ASC;