{"iTotalDisplayRecords":"0","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `crm_site_id`, `crm_site_no`, `crm_project_id`, `crm_site_area`, `crm_site_cost`, `crm_site_type`, `crm_site_status`, `status_name`, `project_name`, `booking_id`, `booking_site_id`, `booking_client_profile`, `booking_consideration_area`, `booking_rate_per_sq_ft`, `booking_status`, `booking_date`, `booking_added_by`, `booking_added_on`, `booking_approved_by`, `booking_approved_on`, `booked_user_name`, `enquiry_number`, `booked_customer_name`, `crm_customer_contact_no_one`, `crm_customer_email_id_one`, `crm_agreement_id`, `crm_agreement_date`, `crm_agreement_added_on`, `crm_registration_id`, `crm_registration_date`, `crm_registration_added_by`, `crm_registration_added_on`, `crm_katha_transfer_id`, `crm_katha_transfer_date`, `crm_katha_transfer_added_by`, `crm_katha_transfer_added_on`, `khatha_hand_over_date`, `enquiry_source_master_name`, `enquiry_id`, `basic_cost_company_name`, `other_charge_company_name`, `basic_cost_company_id`, `other_cost_company_id`, `invoice_date`, `invoice_serial_number`\r\n    FROM other_charge_report\r\n     Where `crm_site_status` IN ('3','4','5','6') AND booking_status = '1'\r\n    ORDER BY invoice_date desc","aaData":[]}