select a.activity_id, a.name, ea.available_p from events_activities ea, acs_activities a where ea.activity_id = a.activity_id and package_id = :package_id and ea.available_p = 't' order by name asc select a.activity_id, a.name, ea.available_p from events_activities ea, acs_activities a where ea.activity_id = a.activity_id and package_id = :package_id and ea.available_p = 'f' order by name asc