I have a query that I hope you could help me convert to eloquent "syntax" since my whole project was written in such a manner. I was also wondering if it's possible to remove subqueries and use only join method since I have read multiple times that performance is better that way.
Here is my query:
select images.*,
users.username,users.profile_picture as user_profile_picture,
(select count(*) from likes where image_id=images.id and user_id={id}) as liked,
(select count(*) from likes where image_id=images.id) as total_likes from images left join
users on images.user_id = users.id order by images.created_at desc limit 20
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire