For some reason the mediawiki database is really hard to get a hold of. In retrospect, it turns out to be a very good reason, but it takes a lot of research to find out why.
Mediawiki does just save a page as you see it on the screen, it saves a page the first time you make it and then it save all the changes. When it is time to show the page it reconstructs the page using the changes and the original, a process that can be a bit time consuming when you don’t use a cache.
So I needed to get the latest new articles from the database to show on the launchpad of this site.
First thing you think about is getting the results out of the page table like this
SELECT page_title FROM mw_page where page_is_new = 1
But that doesn’t really work, because as soon as someone edits a page, it’s no longer considered new. And there is a total absence of any time related column in that table.
SO after some searching on the net, I came up with this.
SELECT rc_title AS page_title
FROM mw_recentchanges, mw_page
WHERE rc_cur_id = page_id AND rc_new = 1 AND page_is_redirect = 0
ORDER BY rc_timestamp DESC
However, the recentchanges table only holds data for the last 30 days, but that’s just fine for me.