either you use

LookupResources

to get the IDs of the events and groups for which the user has access and then use that as a

WHERE id = ANY([<stuff>])

clause