Mar 13, 2017
0
Level 1
join 3 or more tables with laravel relationship
my tables are
(vod_movie --> id ) (genry --> id ) ( vod_movie_genry --> vod_movie_id, genry_id ) ( cus_package_movie --> id, vod_movie_id )
I need to write a query as
SELECT vg.genre_title,m.movie_title FROM vod_movie_genre vg
LEFT JOIN vod_movie_genre_summeries s ON vg.id=s.vod_movie_genre_id
LEFT JOIN vod_movie m ON s.vod_movie_id=m.id
LEFT JOIN cus_packages_movies pm ON m.id=pm.movie_id
WHERE pm.customer_package_id='323' AND pm.subscription_period_id='9'
ORDER BY m.id
using laravel relationships. I'm ok with query builder.
Please or to participate in this conversation.