Ok, enough of trying to find the right queries after the upgrade to 1.5 mediawiki.
Lets just log the sql queries from the server.
A page being requested
get page id
SELECT page_id FROM `page` WHERE page_namespace = '0' AND page_title = 'Ogg' LIMIT 1
get more info
SELECT page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len FROM `page` WHERE page_id = '17369' LIMIT 1
get the actual content
SELECT old_text,old_flags FROM `text` WHERE old_id = '32774'
brion: mutante: old_id=rev_text_id
brion: rev_id=page_latest