{"iTotalDisplayRecords":0,"query":"\r\n SELECT SQL_CALC_FOUND_ROWS `crm_agreement_id`, `crm_agreement_booking_id`, `crm_agreement_registerer`, `crm_agreement_remarks`, `crm_agreement_status`, `crm_agreement_date`, `crm_agreement_added_by`, `crm_agreement_added_on`, `booked_user_name`, `agreement_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`\r\n FROM crm_site_agreements\r\n Where `booking_status` = '1' AND `crm_site_status` = '4' \r\n ORDER BY crm_agreement_date desc\r\n ","aaData":[]}