Mysql query like this :
SELECT id, name, TotalMeal, TotalCollection
FROM users a
LEFT JOIN (SELECT user_id, SUM( braekfast + dinner + lanch ) AS TotalMeal
FROM meals
GROUP BY user_id)b ON a.id = b.user_id
LEFT JOIN (SELECT user_id, SUM( amount ) AS TotalCollection
FROM collections
GROUP BY user_id)c ON a.id = c.user_id
LIMIT 0 , 30
I want to convert it to laravel eloquent, but i'm confused.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire