SELECT u.*, um.meta_value, um2.last_activity, pt.postnum, ptt.threadnum
        FROM wp_wp_users u

        Left Join
            (Select user_id, meta_value From wp_wp_usermeta
            Where meta_key = "wp_wp_capabilities") um
        On um.user_id = u.ID

        Left Join
            (Select user_id, meta_value as last_activity From wp_wp_usermeta
            Where meta_key = "last_activity") um2
        On um2.user_id = u.ID

        Left Join
            (Select post_author, count(*) as postnum From wp_wp_posts
            Where post_type = "reply" or post_type = "page" or post_type = "post"
            Group by post_author) pt
        On pt.post_author = u.ID

        Left Join
            (Select post_author, count(*) as threadnum From wp_wp_posts
            Where post_type = "topic" or post_type = "forum"
            Group by post_author) ptt
        On ptt.post_author = u.ID