in reply to MySQL question
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