I have 5 tables in my Laravel app. 3 main tables are books
, places
, and tags
. The books
table has a pivot table to relate it to tags: book_tags
. The places
table also has a pivot table: place_tags
. Now, for each place, I'd like to get the books based on tags that are both in place_tags
and book_tags
.
books
book_tags
places
place_tags
tags
I've looked through the laravel docs and the closest this seems to come to is a many to many polymorphic relationship, but with that, there'd be only one pivot table with a tag_type
, which is not what I have.
How would I build this query to retrieve the books for each place based on tags in both pivot tables? Answers in MySQL are cool too, I just don't know how this would look like as a query...
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire