Latest threads from vb5 forum

[THETMZ]

Hello,

I was using a php script for selecting latest vb forum threads (including thread name + last post author + date) all linked to specific thread / post. It was working great on vb3. Now when I bought vb5, i need to change the script. Actually I got mostly everything working except I am unable to get URL for specific thread / post.

My current querry is as follows:

SELECT lastcontentid,title,lastcontent,lastcontentauthor,nodeid FROM vb_node where contenttypeid = 30 ORDER BY lastcontentid DESC LIMIT $limit"

Any suggestions how to do that?