I need to get a list from one table and for all entries a count of the related entries of another table.
Lets say I have a list of plans and each plan has maybe 1000 likes from users. I want to have the number of likes combined with the plans in just one call. I can’t include all likes as relations as the traffic could become a problem.
Is there any good way to achieve this with dreamfactory?
I wan’t to have something similar to this in plain sql:
eg. SELECT a.*, COUNT(b) FROM plans a LEFT JOIN likes b ON a.id=b.id