QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-01_21:00:22 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-01_21:00:32 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-01_21:00:32 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-01_21:00:33 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-01_21:00:33 EMPEZO ->> 2021-11-01_21:00:02 TERMINO ->> 2021-11-01_21:00:33 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-02_21:00:17 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-02_21:00:25 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-02_21:00:25 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-02_21:00:26 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-02_21:00:26 EMPEZO ->> 2021-11-02_21:00:01 TERMINO ->> 2021-11-02_21:00:26 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-03_21:00:16 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-03_21:00:20 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-03_21:00:20 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-03_21:00:20 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-03_21:00:20 EMPEZO ->> 2021-11-03_21:00:01 TERMINO ->> 2021-11-03_21:00:20 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-04_21:00:07 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-04_21:00:10 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-04_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-04_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-04_21:00:10 EMPEZO ->> 2021-11-04_21:00:01 TERMINO ->> 2021-11-04_21:00:10 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-11_21:00:17 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-11_21:00:25 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-11_21:00:26 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-11_21:00:26 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-11_21:00:27 EMPEZO ->> 2021-11-11_21:00:01 TERMINO ->> 2021-11-11_21:00:27 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-12_21:00:18 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-12_21:00:27 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-12_21:00:27 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-12_21:00:28 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-12_21:00:28 EMPEZO ->> 2021-11-12_21:00:01 TERMINO ->> 2021-11-12_21:00:28 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-15_21:00:18 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-15_21:00:28 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-15_21:00:28 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-15_21:00:29 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-15_21:00:29 EMPEZO ->> 2021-11-15_21:00:01 TERMINO ->> 2021-11-15_21:00:29 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-16_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-16_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-16_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-16_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-16_21:00:09 EMPEZO ->> 2021-11-16_21:00:01 TERMINO ->> 2021-11-16_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-17_21:00:09 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-17_21:00:13 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-17_21:00:13 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-17_21:00:13 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-17_21:00:13 EMPEZO ->> 2021-11-17_21:00:02 TERMINO ->> 2021-11-17_21:00:13 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-18_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-18_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-18_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-18_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-18_21:00:09 EMPEZO ->> 2021-11-18_21:00:01 TERMINO ->> 2021-11-18_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-19_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-19_21:00:08 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-19_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-19_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-19_21:00:08 EMPEZO ->> 2021-11-19_21:00:01 TERMINO ->> 2021-11-19_21:00:08 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-20_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-20_21:00:08 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-20_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-20_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-20_21:00:08 EMPEZO ->> 2021-11-20_21:00:01 TERMINO ->> 2021-11-20_21:00:08 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-21_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-21_21:00:10 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-21_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-21_21:00:10 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-21_21:00:10 EMPEZO ->> 2021-11-21_21:00:01 TERMINO ->> 2021-11-21_21:00:10 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-22_21:00:14 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-22_21:00:24 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-22_21:00:24 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-22_21:00:25 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-22_21:00:25 EMPEZO ->> 2021-11-22_21:00:01 TERMINO ->> 2021-11-22_21:00:25 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-23_21:00:07 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-23_21:00:12 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-23_21:00:12 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-23_21:00:12 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-23_21:00:12 EMPEZO ->> 2021-11-23_21:00:01 TERMINO ->> 2021-11-23_21:00:12 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-24_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-24_21:00:08 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-24_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-24_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-24_21:00:08 EMPEZO ->> 2021-11-24_21:00:01 TERMINO ->> 2021-11-24_21:00:08 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-25_21:00:18 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-25_21:00:27 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-25_21:00:28 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-25_21:00:28 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-25_21:00:29 EMPEZO ->> 2021-11-25_21:00:02 TERMINO ->> 2021-11-25_21:00:29 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-26_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-26_21:00:09 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-26_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-26_21:00:09 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-26_21:00:09 EMPEZO ->> 2021-11-26_21:00:01 TERMINO ->> 2021-11-26_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-27_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-27_21:00:08 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-27_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-27_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-27_21:00:09 EMPEZO ->> 2021-11-27_21:00:01 TERMINO ->> 2021-11-27_21:00:09 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-28_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-28_21:00:08 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-28_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-28_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-28_21:00:08 EMPEZO ->> 2021-11-28_21:00:01 TERMINO ->> 2021-11-28_21:00:08 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-29_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-29_21:00:08 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-29_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-29_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=10 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-29_21:00:08 EMPEZO ->> 2021-11-29_21:00:01 TERMINO ->> 2021-11-29_21:00:08 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2021-11-30_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-30_21:00:08 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-30_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2021-11-30_21:00:08 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2021 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2021-11-30_21:00:08 EMPEZO ->> 2021-11-30_21:00:01 TERMINO ->> 2021-11-30_21:00:08