Help write a simple search query?

I'm trying to write what should be a fairly simple SQL statement I can use to manually search content. What I've got so far searches within the body of all node revisions. I want to revise this to only search within the latest revision, but can't figure it out.

So far I have:

SELECT * FROM node_revisions WHERE body LIKE '%{searchterm}%'

But that will not filter out all the inactive revisions of a node.

Can anyone give me a hand to make my query limit the results to just the latest version of a node? (ie the greatest vid)