This should get you started...
<br />SELECT t1.U_Username, t2.B_Number <br />FROM w3t_Users AS t1 <br />LEFT JOIN w3t_Posts AS t2 ON t1.U_Number = t2.B_PosterId <br />WHERE t1.U_Groups LIKE '%-1-%' <br />ORDER BY t2.B_posted DESC <br />
What this will do is pull all post numbers (along with their display name) that were authored by members in group 1, and will sort it listing newest first.
Are you familiar enough with PHP to create a script to wrap around this?
