Need help implementing a join


I have a User data type and a Post data type.

The Post data type has a Creator (User) property and a Tags (list of Tags) property.

Users can follow other Users.

Users can follow Tags.

I need a Bubble query that selects all Users
(Post.Tags includes a Tag followed by User OR Post.Creator is a user followed by User)
AND Post.Created Date > CurrentDate-24 hours.

Below are my data types.

I’d suggest starting by trying to do each search individually to ensure it works the way you want it to. Then you can merge those searches together with :merged with:

Separately, regarding data structure and which way to link datatypes, great post and discussion here: