Attention

Error while accessing the database SelectLimit(SELECT CASE cj.iConsecutivoPatio WHEN 1 THEN 'CAPOTE TEST' WHEN 2 THEN 'CAPOTE' WHEN 3 THEN 'LAREDO' WHEN 4 THEN 'ANAYA' END as bodega, cu.sRazonSocial as cu_srazonsocial, CASE WHEN doc.sCveTrafico IS NULL THEN 'Vacia' ELSE 'Cargada' END as condicion, cj.sNumCajaTrailer as cj_snumcajatrailer, cj.sCveLineaCaja as cj_scvelineacaja, cj.dFechaIngreso as cj_dfechaingreso, cj.sCveTransferEntrada as cj_scvetransferentrada, CASE WHEN cj.dFechaSalidaCaja IS NOT NULL THEN 'SALIDA' ELSE 'ENTRADA' END as evento, cj.iConsecutivo as recibopatio, cj.iRecibo as numderecibo, doc.sCveTrafico as doc_scvetrafico, cj.eEstatus as cj_eestatus from pt_control_caja cj INNER JOIN cu_cliente cu ON cj.sCveCliente = cu.sCveCliente LEFT JOIN cb_detalle_orden_carga doc ON cj.iConsecutivoOrdenCarga = doc.iConsecutivoOrdenCarga where cj.iConsecutivoOficina = 3 AND ( cj.dFechaIngreso BETWEEN DATE_SUB(NOW(),INTERVAL 2 WEEK) AND NOW()) group by cj.iRecibo order by cj.dFechaIngreso DESC, cj.iConsecutivoOrdenCarga asc, 52, 0)