{"iTotalDisplayRecords":"0","aaData":[],"query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `name`, `crm_site_visit_plan_date`, `cell`, `project_id`, `project_name`, `enquiry_number`, `crm_site_visit_plan_id`, `crm_site_visit_plan_time`, `assignee`, `assignee_id`, `assigner`, `assigner_id`, `crm_site_visit_pickup_location`, `crm_site_visit_plan_confirmation`, `crm_site_visit_plan_status`, `crm_site_visit_status`, `crm_site_visit_plan_drive`\r\n    FROM \r\n    WHERE `assigner_id`=  AND `crm_site_visit_plan_status`=1 AND `crm_site_visit_plan_confirmation`= 1 AND `crm_site_visit_status`!='Planned'\r\n    \r\n    \r\n    ","role":null}