{"iTotalDisplayRecords":"0","query":"\r\n SELECT SQL_CALC_FOUND_ROWS `crm_registration_id`, `crm_registration_booking_id`, `crm_registration_remarks`, `crm_registration_status`, `crm_registration_date`, `crm_registration_added_by`, `crm_registration_added_on`, `booked_user_name`, `registration_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`, `booking_added_on`, `booking_approved_by`, `booking_approved_on`, `booked_project_name`, `booked_site_no`, `master_site_area`, `booked_site_premium_type`, `booked_project_id`, `enquiry_number`, `booked_customer_name`, `agreement_date`, `khatha_second_document`, `khatha_second_apply_date`, `khatha_second_received_date`, `khatha_requested_amount`, `khatha_amount_requested_on`, `khatha_paid_amount`, `khatha_amount_paid_on`\r\n FROM khatha_payment_second\r\n Where `booking_status` = '1' AND `khatha_noc_document` IS NULL \r\n ORDER BY booking_date desc\r\n \r\n ","aaData":[]}