{"sql":"SELECT \n    s.start_time,\n    DATE_FORMAT(s.start_time, '%b %d') AS start_d, \n    DATE_FORMAT(s.start_time, '%H:%i') AS start_t,  \n    IF(s.timestamp > NOW() - INTERVAL 6 HOUR,TIME_FORMAT(timediff(NOW(),s.timestamp),'%H'),null) as new,\n    c.name as driver_name, \n    s.id,\n    s.start_location,\n    s.start_lat,\n    s.start_lng,\n    s.end_location,\n    s.end_lat,\n    s.end_lng,\n    s.vehicle,\n    s.state,\n    cat.name as category_name,\n    IF(u.id is null, null, true) as joined\nfrom \n    shuttle_routes as s\n    JOIN customers as c on c.id = s.driver\n    JOIN vehicles as v on v.id = s.vehicle\n    JOIN vehicle_categories as cat on cat.id = v.category\n    LEFT JOIN (select * from shuttle_users where customer = :user and state = 1) as u on u.route = s.id\nwhere \n    s.start_time > :now AND\n    s.state = 1\n    order by s.start_time","input":{"now":"2025-07-27, 05:34","user":0},"success":true,"data":[],"count":0,"empty":true}