Hey fury, can we have some stats again?

Jeslek

Banned
Please?

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;
:) Please? Cookie for you if you do...
 
Top