Top Thread Starter

Can someone please help me with a query that will pull the Top thread starter from a forum and the average threads that user has started in that forum? This is the only query I have left to do.

[Xenon]

[SQL]SELECT COUNT(*) as threads, postusername
FROM thread
WHERE forumid=xx
GROUP BY postuserid
ORDER BY threads DESC[/SQL]

[Boofo]

Thank you sir. How would I get the user's average percent compared to the total threads in that forum?

Edit: I figured the percentage part out. Thank you, again, sir.

How would I include the Announcements in the thread count? I have the Announcements as a thread hack (I think it is yours).

[Xenon]

announcements are in a different table, so it's not possible with one query.
they show up as multiple threads but they aren't real threads, therfore you have to run another query to get the announcements

(at least i think union queries aren't possible with mysql?)

[Boofo]

Ok, but can I still somehow include the announcements thread in the total threads and top thread poster stats?

[filburt1]

Investigating.

(and /me smacks Stefan for using * in a query )

[filburt1]

Still investigating after I made a bad JOIN that made MySQL completely lock up my computer

[filburt1]

Okay, I have no idea. However MySQL 4.0.0+ supports UNION syntax, Stefan.

[Xenon]

yes, 4.0.0+ i thought of, but i don't think 3.x versions support em.

*?
hey i'm just lazy

[Boofo]

Today at 01:51 PM filburt1 said this in Post #6
Investigating.

(and /me smacks Stefan for using * in a query )

What would you use other than * in that query? It works here. I'm always open to new ideas.