gistfile1.txt

select:
  applicants:
    - cas_id
    - last_name
    - first_name
  designations:
    - date_locked
  statuses:
    - name
join:
  applicants:
  designations: "designations.applicant_id = applicants.id"
  statuses: "designations.application_status_id = statuses.id"
where:
  applicants
    association_id: 11
  statuses:
    show: true
order:
  applicants:
    - last_name
    - first_name