in reply to
Please forgive me for asking this question here, but in my estimation it seems that there are MANY monks here with extensive database experience.
Your estimation is correct. A lot of us know a big deal about cars, too. But this site isn't the appropriate place for that. Sorry, I --'ed your post.
I'd feel really bad if I only complained without trying to answer your question, so here goes:
Hmm, you didn't really state what data you would expect very clearly.
Maybe it's one of these (untested):
SELECT title, doc_num, version FROM foo ORDER BY version DESC LIMIT 1
SELECT title, doc_num, MAX(version) AS maxver FROM foo GROUP BY title
+ORDER BY maxver DESC