Finder::where("cars", "SELECT * FROM (SELECT vehicle.id, indices.critical, vehicle.inspectiondate, vehicle.licensenumber, vehicle.vehicleid as vehicleid2, chassismodel.modelname, message.longmessage FROM (SELECT MAX(vehicle.id) AS id, MAX(CASE WHEN tyre.pressureiscritical OR tyre.flat OR tyre.profiledepthcritical THEN 1 ELSE 0 END) AS critical FROM vehicle, chassismodel, axle, tyregroup, tyre WHERE chassismodel.vehicleid = vehicle.id AND axle.chassismodelid = chassismodel.id AND tyregroup.axleid = axle.id AND tyre.tyregroupid = tyregroup.id GROUP BY vehicle.inspectiondate,vehicle.id) AS indices, vehicle, chassismodel, message WHERE message.vehicleid = vehicle.id AND indices.id = vehicle.id AND chassismodel.vehicleid = vehicle.id ".$sqlWhereDate." ".$sqlWhereLicensenumber." ".$sqlIfCritical." ORDER BY vehicle.inspectiondate DESC ".$sqlLimit.") AS values ".$sqlOrderBy");