Rachel Webber
General Manager
0481 859 189
Kellie Norton 75
Administration and Member Support Officer
0467 269 117
| query | |||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RESULTSET |
|
||||||||||||||||||||||||||||||||||||
| CACHED | false | ||||||||||||||||||||||||||||||||||||
| EXECUTIONTIME | 0 | ||||||||||||||||||||||||||||||||||||
| SQL | SELECT sisa_People.PeopleID as ID,sisa_People.PeopleLastName as LN, sisa_People.PeopleFirstName as FN, sisa_People.PeopleEmailAddress AS Email, sisa_People.PeoplePhoto AS Photo, sisa_People.PeopleTypeLink, sisa_PeopleType.PeopleTypeName AS Job, sisa_People.PeopleTypeLink AS Office FROM sisa_People, sisa_PeopleType WHERE (sisa_People.PeopleTypeLink = sisa_PeopleType.PeopleTypeID) AND (sisa_People.PeopleAvailable = 1) AND (sisa_People.PeopleSISAStaff = 1) ORDER BY sisa_People.PeopleLastName,sisa_People.PeopleFirstName | ||||||||||||||||||||||||||||||||||||