SELECT a.ID, 
c.FirstName, 
c.LastName, 
r.RegType, 
a.Invited, 
a.Registered, 
a.CheckedIn, 
a.Canceled, 
a.Status 

FROM Contacts c,
Attendees a LEFT JOIN Regtypes r on a.RegType = r.ID,

WHERE a.ContactID = c.ID AND 
a.ProgramID = 500 AND 
a.HostID = 0 

ORDER BY LastName, 
FirstName, 
Status;