Error |
Se produjo un error al acceder a la base de datos You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'JOIN sec_users u ON v.usuario=u.login WHERE v.foliodcto=''' at line 1 SELECT v.idvrem as idvrem, v.idcte as idcte, v.idalm as idalm, v.idpromo as idpromo, v.idctaf as idctaf, v.idruta as idruta, v.idloca as idloca, v.idgposol as idgposol, v.idces as idces, v.fecha as fecha, v.subtotal as subtotal, v.iva as iva, v.ieps as ieps, v.total as total, v.mp as mp, v.fp as fp, v.numpagos as numpagos, v.cantpagos as cantpagos, v.numpagos-v.cantpagos as pagospdtes, v.aboper as aboper, v.inipago as inipago, v.vence as vence, v.impcred as impcred, v.comis as comis, v.cargos as cargos, v.abonos as abonos, v.saldo as saldo, v.pjepena as pjepena, v.imppena as imppena, v.numvenc as numvenc, v.impvenc as impvenc, v.intmensual as intmensual, v.usuario as usuario, v.fechaupd as fechaupd, v.vencida as vencida, v.proxvisita as proxvisita, v.refart as refart, v.pv as pv, v.sistamortz as sistamortz, v.anticipo as anticipo, v.abocap as abocap, v.abotint as abotint, v.aboint as aboint, v.aboiva as aboiva, v.estatus as estatus, v.fechasurt as fechasurt, v.cb as cb_cfdi, v.impfrenov as renovado, v.total-v.impfrenov as entregado, v.interestotal as interestotal, v.saldoinsoluto as saldoinsoluto, v.total-v.saldoinsoluto as renueva, v.observaciones as observaciones, v.folio as folio, v.momento as momento, v.statdcto as statdcto, v.foliodcto as foliodcto, v.idtransp as idtransp, v.numguia as numguia, v.fechaenvio as fechaenvio, v.numbultos as numbultos, v.notasenvio as notasenvio, v.fechaxauto as fechaxauto, v.fechaauto as fechaauto, cte.nombre as cte_nombre, cte.razon as cte_razon, cte.rfc as cte_rfc, cte.callenums as cte_callenums, cte.col as cte_col, cte.mpo as cte_mpo, cte.edo as cte_edo, cte.cp as cte_cp, cte.tel as cte_tel, cte.identif as cte_identif, cte.email as cte_email, cte.numexpediente as numexpediente, cte.nomempr as nomempr, cte.tcallenums as tcallenums, cte.tcol as tcol, cte.tmpo as tmpo, cte.tedo as tedo, cte.tcp as tcp, cte.tiempodom as tiempodom, cte.tipocasa as tipocasa, cte.fechanacim as fechanacim, cte.lugarnacim as lugarnacim, cte.edocivil as edocivil, cte.nombrecony as nombrecony, cte.ocupacioncony as ocupacioncony, cte.telcelcony as telcelcony, cte.ttiempolab as ttiempolab, cte.ttipoempr as ttipoempr, cte.ttiempoempr as ttiempoempr, cte.tgiro as tgiro, cte.tobserva as tobserva, cte.telcel as cte_telcel, cte.refdom as cte_refdom, dom.callenums as rem_callenums, dom.col as rem_col, dom.mpo as rem_mpo, dom.edo as rem_edo, dom.cp as rem_cp, dom.refdom as rem_refdom, dom.tel as rem_tel, dom.telcel as rem_telcel, dom.atencion as rem_atencion, a.nombre as alm_nombre, alm.razon as alm_razon, alm.rfc as alm_rfc, alm.callenums as alm_callenums, alm.col as alm_col, alm.mpo as alm_mpo, alm.edo as alm_edo, alm.cp as alm_cp, alm.tel as alm_tel, alm.email as alm_email, fm.formato as formato, fm.hint as hintformato, fm.det1 as det1, fm.det2 as det2, fm.det3 as det3, fm.det4 as det4, fm.det5 as det5, fm.det6 as det6, fm.det7 as det7, fm.det8 as det8, fm.esp1 as esp1, fm.esp2 as esp2, fm.esp3 as esp3, fm.esp4 as esp4, fm.esp5 as esp5, fm.esp6 as esp6, fm.esp7 as esp7, fm.esp8 as esp8, av1.nombre as av1_nombre, av1.razon as av1_razon, av1.rfc as av1_rfc, av1.callenums as av1_callenums, av1.col as av1_col, av1.mpo as av1_mpo, av1.edo as av1_edo, av1.cp as av1_cp, av1.tel as av1_tel, av1.email as av1_email, av1.refdom as av1_refdom, av2.nombre as av2_nombre, av2.razon as av2_razon, av2.rfc as av2_rfc, av2.callenums as av2_callenums, av2.col as av2_col, av2.mpo as av2_mpo, av2.edo as av2_edo, av2.cp as av2_cp, av2.tel as av2_tel, av2.email as av2_email, av2.refdom as av2_refdom, ces.nombre as cesnombre, promo.nombre as promonombre, ruta.nombre as rutanombre, ctaf.nombre as ctafnombre, fm.lineas_det as lineas_det, fm.pag2 as pag2, fm.formato2 as formato2, vos.idvremos as idvremos, vos.idperson as osidperson, vos.km as oskm, vos.reporte as osreporte, vos.notas as osnotas, vos.diagnostico as osdiagnostico, vos.estatus as osestatus, vos.recibido as osrecibido, vos.promesa as ospromesa, vos.recibio as osrecibio, auto.nombre as autonombre, auto.marca as automarca, auto.modelo as automodelo, auto.color as autocolor, auto.placas as autoplacas, auto.vin as autovin, auto.tipo as autotipo, auto.motor as automotor, auto.anual as autoanual, auto.estado as autoestado, auto.numeconomico as autonumeconomico, cteo.nombre as cteo_nombre, cteo.razon as cteo_razon, cteo.rfc as cteo_rfc, cteo.callenums as cteo_callenums, cteo.col as cteo_col, cteo.mpo as cteo_mpo, cteo.edo as cteo_edo, cteo.cp as cteo_cp, cteo.tel as cteo_tel, cteo.identif as cteo_identif, cteo.email as cteo_email, fm.printexist as printexist, gp.nombre as nombregrupo, u.name as nomusuario, mp.nombre as mpnombre, fp.nombre as fpnombre, dia.nombre as diavisita, perp.nombre as perpago, cte.ref1nombre as ref1nombre, cte.ref2nombre as ref2nombre, cte.ref3nombre as ref3nombre, cte.ref4nombre as ref4nombre, cte.ref1paren as ref1paren, cte.ref2paren as ref2paren, cte.ref3paren as ref3paren, cte.ref4paren as ref4paren, cte.ref3nomempr as ref3nomempr, cte.ref2nomempr as ref2nomempr, cte.ref4nomempr as ref4nomempr, cte.ref1dom as ref1dom, cte.ref2dom as ref2dom, cte.ref3dom as ref3dom, cte.ref4dom as ref4dom, cte.ref1refdom as ref1refdom, cte.ref2refdom as ref2refdom, cte.ref3refdom as ref3refdom, cte.ref4refdom as ref4refdom, cte.ref1tels as ref1tels, cte.ref2tels as ref2tels, cte.ref3tels as ref3tels, cte.ref4tels as ref4tels, cte.ref1ingresos as ref1ingresos, cte.ref2ingresos as ref2ingresos, cte.ref3ingresos as ref3ingresos, cte.ref4ingresos as ref4ingresos from vrem v LEFT JOIN vremos vos ON v.idvrem=vos.idvrem LEFT JOIN auto auto ON vos.idauto=auto.idauto LEFT JOIN person cte ON v.idcte=cte.idperson LEFT JOIN dom ON v.iddom=dom.iddom LEFT JOIN person cteo ON vos.idperson=cteo.idperson LEFT JOIN alm a ON v.idalm=a.idalm LEFT JOIN ces ON v.idces=ces.idces LEFT JOIN ruta ON v.idruta=ruta.idruta LEFT JOIN person promo ON v.idpromo=promo.idperson LEFT JOIN person alm ON a.idperson=alm.idperson LEFT JOIN person av1 ON v.idaval1=av1.idperson LEFT JOIN person av2 ON v.idaval2=av2.idperson LEFT JOIN ccfdi mp ON v.mp=mp.clave and mp.tipo='m' LEFT JOIN ccfdi fp ON v.fp=fp.clave and fp.tipo='f' LEFT JOIN ccfdi dia ON v.diavisita=dia.clave AND dia.tipo='d' LEFT JOIN ccfdi perp ON v.perpago=perp.clave AND perp.tipo='p' LEFT JOIN ctaf ON v.idctaf=ctaf.idctaf LEFT JOIN gposol gp ON v.idgposol=gp.idgposol LEFT JOIN fmt fm ON fm.idfmt= LEFT JOIN sec_users u ON v.usuario=u.login WHERE v.foliodcto='' |