{"sql":"\nselect \n    v.*,\n    IF(v.ac = 1, 'true', null) as ac_text,\n    DATE_FORMAT(v.timestamp, '%Y %b %d') as registered, \n    IF(v.verified = 1, 'true', null) as verified_text,\n    c.id as customer,\n    t.name as categorylabel \nfrom \n    vehicles as v,\n    customers as c,\n    vehicle_categories as t\nwhere \n    c.id = v.driver and \n    t.id = v.category and\n    driver = :driver","input":{"driver":false},"success":true,"data":[],"count":0,"empty":true}