Need help implementing a join

[GB44]

Help!

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
WHERE
(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.

[ed727]

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:

Introduction

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

Alternative approach to the Bubble’s recent tutorials for list of things

Hello everybody, I’ve taken a look at some tutorials from the following topic: In short, I think that these tutorials contain some crucial mistakes. Regarding How To Build A Pinterest Clone Without Code Configure your database User [image] We’re facing this mistake on many apps. That’s a wrong approach since it negatively affects performance and speed. Let me explain why I do think that this is wrong. The Bubble’s unique id for each thing looks like the next one: 1583401182457x36677842…