{"iTotalDisplayRecords":"0","query":"\r\nSELECT 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`, `follow_up_user_name`, `follow_up_by`\r\nFROM 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 != 'BOOKING' AND crm_payment_schedule_milestone != 'AGREEMENT' AND crm_payment_schedule_milestone != 'REGISTRATION' AND crm_payment_schedule_milestone != 'KHATHA TRANSFER' AND crm_payment_schedule_milestone != 'KHATHA HOC') \r\nORDER BY follow_up_date_time ASC\r\n\r\n","aaData":[]}