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 'WHERE vos.folio=''' at line 1 SELECT 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, 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, mp.nombre as mpnombre, fp.nombre as fpnombre, dia.nombre as diavisita, perp.nombre as perpago, 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, 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, alm.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, 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, ces.nombre as cesnombre, promo.nombre as promonombre, ruta.nombre as rutanombre, ctaf.nombre as ctafnombre, v.cb as cb_cfdi, fm.lineas_det as lineas_det, fm.pag2 as pag2, fm.formato2 as formato2, v.impfrenov as renovado, v.total-v.impfrenov as entregado, v.interestotal as interestotal, v.saldoinsoluto as saldoinsoluto, v.total-v.saldoinsoluto as renueva, cte.numexpediente as numexpediente from vremos vos LEFT JOIN vrem v ON vos.idvrem=v.idvrem LEFT JOIN auto auto ON vos.idauto=auto.idauto LEFT JOIN person cte ON v.idcte=cte.idperson 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 fmt fm ON fm.idfmt= WHERE vos.folio=''