Generation Time: Nov 30, 2009 at 02:38 AM
Generated by: phpMyAdmin 2.11.6-rc1 / MySQL 5.0.86-Max-log
SQL query: EXPLAIN SELECT p.author_id member_id, m.name member_name, COUNT(p.pid) posts FROM forum_posts p INNER JOIN forum_members m ON p.author_id = m.member_id INNER JOIN forum_topics t ON t.forum_id = 120 AND t.tid = p.topic_id WHERE p.author_id != 0 AND p.new_topic = 0 GROUP BY p.author_id ORDER BY posts DESC LIMIT 1;
Rows: 3

id	select_type	table	type    possible_keys				key			key_len	ref						rows	Extra
1	SIMPLE		t		ref		PRIMARY,forum_id,last_post	forum_id    2		const					25420	Using temporary; Using filesort
1	SIMPLE		p		ref		author_id,topic_id			topic_id	4		wmonline2.t.tid			5		Using where
1	SIMPLE		m		eq_ref	PRIMARY						PRIMARY		3		wmonline2.p.author_id	1