SELECT member_directory.*, descriptions.RHA_Executive_Description, descriptions.position_label
FROM member_directory left join descriptions
on member_directory.position = descriptions.position
WHERE Community_ID = 14 and member_directory.position <> 'advisor'
ORDER BY Display_Order ASC
SELECT *
FROM candidate_description
WHERE show_it = 1
ORDER BY Title ASC
SELECT *
FROM upcoming_events_calendar_form
where event_date >= #now()#
SELECT *
FROM accomplishments
ORDER BY RAND()
SELECT *
FROM rha_meetingdates
where Meeting_date >= #now()#
SELECT *
FROM homepage_headlines
ORDER BY headline_num ASC
The Residence Hall Association
