Jeslek
Banned
Please?
Please? Cookie for you if you do...
Code:
select sum(topic_replies) total, username
from phpbb_topics, phpbb_users
where topic_poster = user_id
group by topic_poster
order by total desc;
select avg(t.topic_replies) averagereplies, avg(t.topic_views)
averageviews, u.username, count(t.topic_id) topicsstarted
from phpbb_topics t, phpbb_users u
where t.topic_poster = u.user_id
group by t.topic_poster
order by averagereplies desc;