Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Add Comment
Please, Sign In to add comment