{"sql":"\nselect \n    p.*,\n    c.name as category_text,\n    c.passengers as passengers,\n    c.note as category_note\nfrom \n    taxi_packages as p\njoin\n    vehicle_categories as c on c.id = p.category","input":false,"success":true,"data":[{"id":"10","user":"2","name":"Package Name","category":"2","type":"1","fee":"7700","freekm":"90","freeh":"6","extrakm":"80","extrah":"300","note":"","category_text":"Mini Car","passengers":"3","category_note":""},{"id":"14","user":"2","name":"Package Name","category":"3","type":"1","fee":"6300","freekm":"60","freeh":"3","extrakm":"90","extrah":"300","note":"","category_text":"HatchBack","passengers":"4","category_note":""},{"id":"12","user":"2","name":"Package Name","category":"6","type":"1","fee":"9300","freekm":"60","freeh":"4","extrakm":"130","extrah":"400","note":"Return Package None AC Minimum","category_text":"Van","passengers":"10","category_note":""},{"id":"13","user":"2","name":"Package Name","category":"4","type":"0","fee":"10600","freekm":"60","freeh":"3","extrakm":"140","extrah":"400","note":"Car","category_text":"Car","passengers":"4","category_note":""},{"id":"8","user":"2","name":"Name","category":"0","type":"0","fee":"150","freekm":"1","freeh":"0","extrakm":"80","extrah":"300","note":"General Tuk.","category_text":"TUK","passengers":"2","category_note":""},{"id":"7","user":"2","name":"Package Name","category":"1","type":"1","fee":"6000","freekm":"60","freeh":"4","extrakm":"90","extrah":"400","note":"Return TAXI","category_text":"Taxi","passengers":"3","category_note":""},{"id":"9","user":"2","name":"Package Name","category":"6","type":"0","fee":"2900","freekm":"10","freeh":"1","extrakm":"150","extrah":"400","note":"Minimum 10km","category_text":"Van","passengers":"10","category_note":""},{"id":"6","user":"2","name":"Package Name","category":"6","type":"0","fee":"9600","freekm":"60","freeh":"3","extrakm":"140","extrah":"500","note":"60km Drop off package","category_text":"Van","passengers":"10","category_note":""},{"id":"5","user":"2","name":"Package Name","category":"1","type":"1","fee":"8300","freekm":"90","freeh":"6","extrakm":"85","extrah":"300","note":"","category_text":"Taxi","passengers":"3","category_note":""},{"id":"4","user":"2","name":"Package Name","category":"3","type":"0","fee":"1100","freekm":"6","freeh":"0","extrakm":"130","extrah":"400","note":"","category_text":"HatchBack","passengers":"4","category_note":""},{"id":"1","user":"2","name":"Package Name","category":"2","type":"1","fee":"2600","freekm":"30","freeh":"1","extrakm":"90","extrah":"300","note":"note","category_text":"Mini Car","passengers":"3","category_note":""},{"id":"2","user":"2","name":"Package Name","category":"2","type":"0","fee":"300","freekm":"1","freeh":"0","extrakm":"120","extrah":"400","note":"Small Alto Nano","category_text":"Mini Car","passengers":"3","category_note":""},{"id":"3","user":"2","name":"Mini van 1","category":"5","type":"0","fee":"10600","freekm":"60","freeh":"3","extrakm":"150","extrah":"400","note":"Minimum 10km","category_text":"Mini Van","passengers":"6","category_note":""},{"id":"11","user":"2","name":"Mini Van Return 1","category":"5","type":"1","fee":"11600","freekm":"90","freeh":"6","extrakm":"100","extrah":"400","note":"Half Day","category_text":"Mini Van","passengers":"6","category_note":""},{"id":"15","user":"2","name":"Mini Van Basic","category":"5","type":"0","fee":"1300","freekm":"6","freeh":"1","extrakm":"130","extrah":"400","note":"","category_text":"Mini Van","passengers":"6","category_note":""},{"id":"16","user":"2","name":"Package Name","category":"10","type":"1","fee":"162000","freekm":"600","freeh":"24","extrakm":"270","extrah":"600","note":"None AC","category_text":"Large Bus","passengers":"60","category_note":""},{"id":"17","user":"2","name":"Package Name","category":"6","type":"1","fee":"10700","freekm":"70","freeh":"6","extrakm":"130","extrah":"400","note":"70km Return package","category_text":"Van","passengers":"10","category_note":""},{"id":"18","user":"2","name":"Package Name","category":"6","type":"1","fee":"20900","freekm":"190","freeh":"10","extrakm":"90","extrah":"300","note":"Day Package \r\n","category_text":"Van","passengers":"10","category_note":""},{"id":"19","user":"2","name":"Package Name","category":"9","type":"1","fee":"20000","freekm":"100","freeh":"10","extrakm":"180","extrah":"600","note":"Small Bus Return","category_text":"Small Bus","passengers":"26","category_note":""},{"id":"20","user":"2","name":"Package Name","category":"6","type":"0","fee":"14400","freekm":"90","freeh":"5","extrakm":"140","extrah":"300","note":"","category_text":"Van","passengers":"10","category_note":""},{"id":"21","user":"2","name":"AC small BUS","category":"9","type":"1","fee":"36000","freekm":"200","freeh":"12","extrakm":"180","extrah":"600","note":"12 -15 Hours Negotiation can be done with some vehicles. ","category_text":"Small Bus","passengers":"26","category_note":""},{"id":"22","user":"2","name":"Half Day","category":"4","type":"1","fee":"10900","freekm":"90","freeh":"6","extrakm":"110","extrah":"300","note":"Half Day","category_text":"Car","passengers":"4","category_note":""},{"id":"23","user":"2","name":"Package Name","category":"11","type":"0","fee":"13500","freekm":"90","freeh":"0","extrakm":"150","extrah":"400","note":"Buddy Lorry","category_text":"MPV","passengers":"3","category_note":""},{"id":"24","user":"2","name":"Lux Car Return 1","category":"13","type":"1","fee":"26500","freekm":"200","freeh":"10","extrakm":"120","extrah":"300","note":"","category_text":"Lux Car","passengers":"4","category_note":""},{"id":"25","user":"2","name":"Package Name","category":"11","type":"0","fee":"1500","freekm":"3","freeh":"1","extrakm":"250","extrah":"400","note":"","category_text":"MPV","passengers":"3","category_note":""},{"id":"26","user":"2","name":"Package Name","category":"7","type":"1","fee":"39000","freekm":"300","freeh":"18","extrakm":"130","extrah":"400","note":"","category_text":"Luxury Van","passengers":"15","category_note":""},{"id":"27","user":"2","name":"Package Name","category":"8","type":"0","fee":"24000","freekm":"90","freeh":"6","extrakm":"200","extrah":"600","note":"Wedding Package","category_text":"SUV","passengers":"6","category_note":""},{"id":"28","user":"2","name":"Private Delivery","category":"12","type":"0","fee":"900","freekm":"1","freeh":"0","extrakm":"140","extrah":"400","note":"","category_text":"CAB","passengers":"9","category_note":""},{"id":"29","user":"2","name":"Package Name","category":"7","type":"1","fee":"29600","freekm":"190","freeh":"12","extrakm":"150","extrah":"400","note":"","category_text":"Luxury Van","passengers":"15","category_note":""},{"id":"30","user":"2","name":"Package Name","category":"10","type":"1","fee":"55000","freekm":"200","freeh":"12","extrakm":"270","extrah":"600","note":"","category_text":"Large Bus","passengers":"60","category_note":""},{"id":"31","user":"2","name":"Package Name","category":"4","type":"1","fee":"20900","freekm":"190","freeh":"10","extrakm":"100","extrah":"400","note":"","category_text":"Car","passengers":"4","category_note":""},{"id":"32","user":"2","name":"R170CAB85","category":"12","type":"1","fee":"15300","freekm":"170","freeh":"10","extrakm":"85","extrah":"400","note":"","category_text":"CAB","passengers":"9","category_note":""},{"id":"33","user":"2","name":"Mini Van Return 2","category":"5","type":"1","fee":"17100","freekm":"190","freeh":"12","extrakm":"90","extrah":"400","note":"","category_text":"Mini Van","passengers":"6","category_note":""},{"id":"34","user":"2","name":"Package Name","category":"7","type":"0","fee":"18700","freekm":"90","freeh":"6","extrakm":"180","extrah":"400","note":"","category_text":"Luxury Van","passengers":"15","category_note":""},{"id":"35","user":"2","name":"Private Car ","category":"13","type":"0","fee":"8900","freekm":"30","freeh":"3","extrakm":"180","extrah":"400","note":"","category_text":"Lux Car","passengers":"4","category_note":""},{"id":"36","user":"2","name":"Mini Van 2","category":"5","type":"0","fee":"20800","freekm":"130","freeh":"4","extrakm":"150","extrah":"400","note":"","category_text":"Mini Van","passengers":"6","category_note":""},{"id":"37","user":"2","name":"Package Name","category":"4","type":"0","fee":"3000","freekm":"20","freeh":"1","extrakm":"150","extrah":"400","note":"","category_text":"Car","passengers":"4","category_note":""},{"id":"38","user":"2","name":"Package Name","category":"7","type":"1","fee":"15600","freekm":"100","freeh":"6","extrakm":"150","extrah":"400","note":"","category_text":"Luxury Van","passengers":"15","category_note":""},{"id":"39","user":"2","name":"Package Name","category":"2","type":"1","fee":"17000","freekm":"200","freeh":"10","extrakm":"80","extrah":"300","note":"","category_text":"Mini Car","passengers":"3","category_note":""},{"id":"40","user":"2","name":"Package Name","category":"6","type":"1","fee":"5400","freekm":"30","freeh":"2","extrakm":"130","extrah":"500","note":"","category_text":"Van","passengers":"10","category_note":""},{"id":"41","user":"2","name":"Package Name","category":"3","type":"1","fee":"8300","freekm":"90","freeh":"6","extrakm":"90","extrah":"300","note":"","category_text":"HatchBack","passengers":"4","category_note":""},{"id":"42","user":"2","name":"Wedding Day 1","category":"14","type":"0","fee":"30000","freekm":"120","freeh":"10","extrakm":"200","extrah":"600","note":"Wedding Package ","category_text":"VIP Car","passengers":"3","category_note":""},{"id":"43","user":"2","name":"Package Name","category":"14","type":"0","fee":"20000","freekm":"60","freeh":"9","extrakm":"200","extrah":"600","note":"","category_text":"VIP Car","passengers":"3","category_note":""},{"id":"44","user":"2","name":"Package Name","category":"1","type":"0","fee":"300","freekm":"1","freeh":"0","extrakm":"120","extrah":"400","note":"Taxi On demand","category_text":"Taxi","passengers":"3","category_note":""},{"id":"45","user":"2","name":"Package Name","category":"3","type":"1","fee":"27000","freekm":"300","freeh":"15","extrakm":"90","extrah":"400","note":"","category_text":"HatchBack","passengers":"4","category_note":""},{"id":"46","user":"2","name":"Package Name","category":"4","type":"1","fee":"30000","freekm":"300","freeh":"12","extrakm":"100","extrah":"300","note":"","category_text":"Car","passengers":"4","category_note":""},{"id":"47","user":"2","name":"Package Name","category":"0","type":"1","fee":"1200","freekm":"9","freeh":"1","extrakm":"70","extrah":"300","note":"","category_text":"TUK","passengers":"2","category_note":""},{"id":"48","user":"2","name":"Package Name","category":"6","type":"1","fee":"33000","freekm":"300","freeh":"16","extrakm":"100","extrah":"400","note":"","category_text":"Van","passengers":"10","category_note":""},{"id":"49","user":"2","name":"Kandy<>Mee Mure 1x1night Tour","category":"8","type":"1","fee":"16000","freekm":"100","freeh":"6","extrakm":"150","extrah":"900","note":"*Welcome *2xLunch *Night Meal *Breakfast *Tea Evening \r\n*Herbal Tea Morning *Local Snak Food ","category_text":"SUV","passengers":"6","category_note":""},{"id":"50","user":"2","name":"Mini Van Return 3","category":"5","type":"1","fee":"3900","freekm":"30","freeh":"3","extrakm":"120","extrah":"400","note":"","category_text":"Mini Van","passengers":"6","category_note":""},{"id":"51","user":"2","name":"30km Load","category":"11","type":"0","fee":"6000","freekm":"30","freeh":"3","extrakm":"160","extrah":"400","note":"","category_text":"MPV","passengers":"3","category_note":""},{"id":"52","user":"2","name":"Lux Car Half Day","category":"13","type":"1","fee":"11200","freekm":"90","freeh":"6","extrakm":"120","extrah":"400","note":"","category_text":"Lux Car","passengers":"4","category_note":""},{"id":"55","user":"2","name":"Kandy<>Mee Mure Day Tour","category":"8","type":"0","fee":"30000","freekm":"150","freeh":"16","extrakm":"200","extrah":"600","note":"Seat - 9\/ Transport only 4.00 -20.00","category_text":"SUV","passengers":"6","category_note":""},{"id":"53","user":"2","name":"Luxary Short","category":"7","type":"0","fee":"11000","freekm":"30","freeh":"4","extrakm":"200","extrah":"400","note":"KDH","category_text":"Luxury Van","passengers":"15","category_note":""},{"id":"54","user":"2","name":"Lux Car Drop","category":"13","type":"0","fee":"18600","freekm":"90","freeh":"6","extrakm":"180","extrah":"400","note":"","category_text":"Lux Car","passengers":"4","category_note":""},{"id":"56","user":"2","name":"Kandy<>Mee Mure 1night","category":"8","type":"1","fee":"17000","freekm":"150","freeh":"48","extrakm":"1000","extrah":"1000","note":"Mee Mure - Night Transport only 17000 (9-10 People Max)","category_text":"SUV","passengers":"6","category_note":""},{"id":"57","user":"2","name":"Home Delivery","category":"15","type":"0","fee":"150","freekm":"1","freeh":"1","extrakm":"40","extrah":"0","note":"Delivery Orders Only","category_text":"Delivery","passengers":"1","category_note":""},{"id":"58","user":"2","name":"Hunnasgiriya - Meemure ","category":"8","type":"1","fee":"24000","freekm":"50","freeh":"6","extrakm":"150","extrah":"900","note":"Drop and return Next Day - ","category_text":"SUV","passengers":"6","category_note":""},{"id":"59","user":"2","name":"Car 90km","category":"3","type":"0","fee":"11900","freekm":"90","freeh":"2","extrakm":"120","extrah":"400","note":"WegonR","category_text":"HatchBack","passengers":"4","category_note":""},{"id":"60","user":"2","name":"Return package","category":"12","type":"1","fee":"4600","freekm":"30","freeh":"2","extrakm":"90","extrah":"400","note":"","category_text":"CAB","passengers":"9","category_note":""},{"id":"61","user":"2","name":"Forward Delivery ","category":"15","type":"0","fee":"400","freekm":"10","freeh":"1","extrakm":"30","extrah":"0","note":"","category_text":"Delivery","passengers":"1","category_note":""},{"id":"62","user":"2","name":"300Taxi","category":"1","type":"1","fee":"23100","freekm":"290","freeh":"10","extrakm":"80","extrah":"400","note":"","category_text":"Taxi","passengers":"3","category_note":""}],"count":62}