{
  "facility_sql": "SELECT /*FACILITY_TAG*/\r\n    m.ID AS Membership_Tracking_ID,\r\n    c.CUSTOMER_ID,\r\n    c.GUID,\r\n    c.FIRSTNAME AS First_Name,\r\n    c.LASTNAME AS Last_Name,\r\n    c.BDAY AS DOB,\r\n    c.CURRENT_STATUS AS Current_Status,\r\n    c.CUSTOMER_TYPE AS Current_Customer_Type,\r\n    c.MEMBERSHIP_FORM_OF_PAYMENT AS Form_of_Payment,\r\n    m.START_DATE AS Membership_Start_Date,\r\n\r\n    CASE\r\n        WHEN EXISTS (\r\n            SELECT 1\r\n            FROM notes n\r\n            WHERE n.CUSTOMER_ID = c.CUSTOMER_ID\r\n              AND n.NOTES LIKE '%transferred from%'\r\n              AND DATE(n.POSTDATE) BETWEEN '/*START_DATE*/' AND '/*END_DATE*/'\r\n              AND DATE(n.POSTDATE) <= DATE(m.START_DATE)\r\n        )\r\n        THEN 'Transferred Before Membership Start'\r\n        ELSE 'No Transfer'\r\n    END AS Transfer_Status\r\n\r\nFROM customers c\r\nJOIN membership_tracking m\r\n    ON m.CUSTOMER_ID = c.CUSTOMER_ID\r\nWHERE m.START_DATE BETWEEN '/*START_DATE*/' AND '/*END_DATE*/';",
  "merge_sql": "",
  "json": "{\r\n  \"facility_column_tag\": \"/*FACILITY_TAG*/\",\r\n  \"wants_start_date\": {\r\n    \"tag\": \"/*START_DATE*/\"\r\n  },\r\n  \"wants_end_date\": {\r\n    \"tag\": \"/*END_DATE*/\"\r\n  }\r\n}",
  "name": "New Members (With Transfer Status)"
}