Tiempo de carga de la MultiQuery: 0 seconds



SELECT licensePlate, (SELECT idFrotcom from vehiculos where matricula=jobssaleforce.licensePlate) as idFrotcom , count(*) as activeJobs, (SELECT capacidad from vehiculos where matricula=jobssaleforce.licensePlate) as capacidad , (SELECT estadoVehiculo from vehiculos where matricula=jobssaleforce.licensePlate) as estadoVehiculo , (SELECT vehicleStatusDecimal from vehiculos where matricula=jobssaleforce.licensePlate) as vehicleStatusDecimal FROM `jobssaleforce` WHERE licensePlate != '' AND scheduledDate BETWEEN '1000-01-01T00:00:00' AND '2026-08-16T18:06:49' GROUP BY licensePlate



SELECT * FROM vehiculos WHERE 1