Good morning! Please tell me how can I select from the database all the posts using the sort pivotal table?
There is a table Posts and Users as well as the junction table post_user. Pivota table is as follows:
I need to select all posts from the database which have a status of "cheked-out" using data from pivotal table. The figure marked a post with these parameters. Please tell me how can I build such a query, or by what conditions it is possible to build a query. TC I'm new to Laravel and I don't know yet how to build such queries)