{"draw":0,"recordsTotal":27347,"recordsFiltered":27347,"data":[],"sql":"SELECT   `ma`.*, `md`.`device_name`, `md`.`device_class`,c.city_name,fs.facility_type,fs.facility_name   FROM master_asset AS `ma` LEFT JOIN `master_device` AS `md` ON (`md`.`device_code` = `ma`.`device_code`) INNER JOIN  `master_facility_type` AS  `fs` ON (  `ma`.`facility_code` =  `fs`.`facility_code` AND  `ma`.`facility_id` =  `fs`.`facility_id` AND  `ma`.`city_id` =  `fs`.`city_id` ) LEFT JOIN  `setup_city` AS  `c` ON (  `fs`.`city_id` =  `c`.`city_id` ) WHERE 1 = 1    ORDER BY `ma`.`srno`      LIMIT  , "}