usergroup posts displayed on homepage

[dethfire]

looking to try and figure out how to get a list of posts from a usergroup on the homepage. like a list of the top most recent topics but only collected from a certain usergroup

[rake]

use this query:

SELECT thread.*,user.usergroupid,user.username FROM thread LEFT JOIN user ON(thread.postuserid=user.userid) WHERE usergroupid = X ORDER BY dateline DESC LIMIT Y

replace X with the usergroup id and Y with the number of threads you want to display

[dethfire]

thanks rake! what file should I put this in if say I want the thread listed in the navbar template?

[rake]

the navbar appears on most pages, so you'd have to put the code in the global.php file.

[dethfire]

ok so lets say I run my query on global, how do I output my results to the navbar template?