gistfile1.txt

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