{"iTotalDisplayRecords":"0","query":"\r\n SELECT SQL_CALC_FOUND_ROWS `crm_payment_schedule_id`, `crm_payment_schedule_booking_id`, `crm_payment_schedule_date`, `crm_payment_schedule_amount`, `crm_payment_schedule_milestone`, `crm_payment_schedule_remarks`, `crm_payment_schedule_added_by`, `crm_payment_schedule_added_on`, `crm_site_id`, `crm_site_no`, `crm_site_status`, `status_name`, `project_name`, `project_id`, `booking_id`, `booking_site_id`, `booking_client_profile`, `booking_status`, `booking_date`, `booking_added_by`, `booking_added_on`, `booked_user_name`, `booking_consideration_area`, `enquiry_number`, `enquiry_id`, `booked_customer_name`, `crm_customer_contact_no_one`, `follow_up_date_time`, `schedule_status`\r\n FROM payment_schedule\r\n Where `booking_status` = '1' AND (`crm_site_status` = '3' OR `crm_site_status` = '4' OR `crm_site_status` = '5' OR `crm_site_status` = '6') AND (crm_payment_schedule_milestone = 'KHATHA TRANSFER' OR crm_payment_schedule_milestone = 'KHATHA HOC') \r\n ORDER BY follow_up_date_time ASC\r\n \r\n ","aaData":[]}