{"iTotalDisplayRecords":"0","query":"\r\n SELECT SQL_CALC_FOUND_ROWS `id`, `booking_id`, `bank_id`, `loan_applied_amount`, `loan_applied_date`, `loan_sanction_amount`, `loan_sanction_date`, `loan_disbursed_amount`, `loan_disbursed_date`, `loan_status`, `remark`, `added_by`, `added_on`, `bank_name`, `crm_site_id`, `crm_site_no`, `crm_project_id`, `crm_site_dimension`, `crm_site_area`, `crm_site_cost`, `crm_site_type`, `crm_site_premium_type`, `crm_site_status`, `status_name`, `project_name`, `booking_site_id`, `booking_client_profile`, `booking_consideration_area`, `booking_rate_per_sq_ft`, `booking_premium_type`, `booking_status`, `booking_date`, `crm_booking_fund`, `booking_added_by`, `booking_added_on`, `booking_approved_by`, `booking_approved_on`, `booked_user_name`, `enquiry_number`, `enquiry_id`, `booked_customer_name`, `crm_customer_contact_no_one`, `crm_customer_contact_no_two`, `crm_customer_contact_no_three`, `crm_customer_contact_no_four`, `crm_customer_email_id_one`, `basic_cost_company_name`, `other_charge_company_name`, `basic_cost_company_id`, `other_cost_company_id`\r\n FROM customer_loan_view\r\n Where `booking_status` = '1' \r\n ORDER BY added_on desc\r\n \r\n ","aaData":[]}