Many to Many Relationship and group by on database column

Need help Database
1

Hi,
I am new to bubble and I am working on SAAS application and I have 3 tables,

Subscribers (has name and email)
Plans(has name and monthly amount)
Subscribes( has plan, subscriber and create date)
I’ll give an example
John, Mark, Michele are subscribers
Free, Pro, Enterprise are plans
john subscribed to free then pro
Mark subscribed to Pro then Enterprise
Michele subscribed to Pro then Enterprise
then I ask for the subscribers of the plans
plan Enterprise will return Mark, Michele
plan Pro will return john
I want to select all subscribers that belongs to plan with the maximum create date of subscribes
Thank You

2

Hey,

Try something like:
Do a search for ‘Subscribes’, sorted by ‘create date’ , descending yes : first item’s subscribers.

This should work.

Animisha

3

Hey,
I tried it but it doesn’t work, What I want is returning all subscribers to a plan in the current date
I’ll give an example
John, Mark, Michele are subscribers
Free, Pro, Enterprise are plans
john subscribed to free then pro
Mark subscribed to Pro then Enterprise
Michele subscribed to Pro then Enterprise
then I ask for the subscribers of the plans
plan Enterprise will return Mark, Michele
plan Pro will return john
Thank you