Attention

Error while accessing the database 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 ') AND FIND_IN_SET(sbrw.idwarehouse,)) nm_sel_esp' at line 1 select count(*) from (select DISTINCT oc.iConsecutivo, c.sCveCliente, c.sRazonSocial AS Cliente, tr.sCveTransportista, tr.sNombre AS Transportista, COALESCE(sbr.inbd,'') AS Inbond, COALESCE(sbr.tk_id, oc.sNumCajaTrailer) AS TKID, COALESCE(sbr.dd, '') AS DD, COALESCE(sbr.pedimento, t.sNumPedimento) AS Pedimento, COALESCE(sbr.clave, t.sCveDocumento) AS Clave, COALESCE(sbr.driver, '') AS driver, COALESCE(sbr.inv, doc.sInstruccionesEspecialesEntrega) AS INV, COALESCE(sbr.seal,TRIM(CONCAT(oc.sSellos_1,',',oc.sSellos_2,',',oc.sSellos_3))) AS Sellos, COALESCE(sbr.time, '') AS Tiempo, COALESCE(sbr.custom_stoplight, 0) AS CustomStoplight, CASE WHEN sbr.iconsecutivo IS NULL THEN 0 ELSE 1 END AS Saved from cb_orden_carga oc LEFT JOIN cb_detalle_orden_carga doc on doc.iConsecutivoOrdenCarga = oc.iConsecutivo LEFT JOIN cb_trafico t ON doc.sCveTrafico = t.sCveTrafico LEFT JOIN cu_linea_transportista_mexicana tr ON tr.sCveTransportista = doc.sCveTransportistaMexicano LEFT JOIN cu_cliente c ON t.sCveCliente = c.sCveCliente LEFT JOIN sbr_clients_warehouse sbrw ON c.sCveCliente = sbrw.idClient LEFT JOIN sbr ON sbr.iconsecutivo = oc.iconsecutivo where (oc.dFechaSalida BETWEEN DATE_FORMAT('2022-01-24', '%Y%m%d%H%i%S') AND DATE_FORMAT('2022-01-24', '%Y%m%d%H%i%S')) AND FIND_IN_SET(t.iConsecutivoOficina,) AND FIND_IN_SET(sbrw.idwarehouse,)) nm_sel_esp