I have 2 tables (posts, revisions), and there is a relationship between them
A post has many revisions (One to Many relationship)
Revisions table has a column called status (approved or rejected)
Now, I want to select all posts, if its latest revision is approved
I tried a lot of methods, but I could get the posts that have an approved status
Update
I found a good solution in that reply