php mysql query to pull last x number of posts

[gcombe74]

I migrated from phpbb3 to vbulletin.. and I used to pull the last 30 posts from my site by post id..

and oddly I can do that in vbulletin as well but only the posts that imported...

so the question is this..I was pulling by postid or lastpost... its easy to tell that vb5 has gone away from postid...

but is there query that I can run in vb5 to do this? can someone help me figure out how to reconstruct the url for pulling the last x number just php and mysql query?

Thanks