{"iTotalDisplayRecords":"0","query":"\r\n SELECT SQL_CALC_FOUND_ROWS `crm_cancellation_id`, `crm_cancellation_booking_id`, `crm_cancellation_date`, `crm_cancellation_reason`, `crm_cancellation_status`, `crm_cancellation_remarks`, `crm_cancellation_added_by`, `crm_cancellation_added_on`, `crm_cancellation_approved_by`, `crm_cancellation_approved_on`, `booked_user_name`, `cancelation_added_user_name`, `booking_id`, `booking_site_id`, `booking_client_profile`, `booking_initial_amount`, `booking_initial_payment_details`, `booking_consideration_area`, `booking_rate_per_sq_ft`, `booking_premium_type`, `booking_remarks`, `booking_status`, `booking_date`, `booked_user_name`, `booking_added_on`, `booking_approved_by`, `booking_approved_on`, `booked_project_name`, `booked_project_id`, `booked_site_no`, `master_site_area`, `booked_site_premium_type`, `enquiry_number`, `booked_customer_name`, `booked_customer_mobile`, `crm_cancellation_reason_name`, `cancelation_approved_user_name`\r\n FROM crm_site_cancelled\r\n Where `booking_status` = '3' \r\n ORDER BY crm_cancellation_date desc\r\n \r\n ","aaData":[]}