вот собственно сам запрос
SELECT u.id, b. * , u.id AS uid, u.nickname AS author, u.login as author_login, IFNULL( SUM( r.points ) , 0 ) AS points FROM cms_users u, cms_blogs b WHERE b.user_id = u.id
COUNT(p.user_id) as records,
SELECT u.id, b. * , u.id AS uid, u.nickname AS author, u.login as author_login, IFNULL( SUM( r.points ) , 0 ) AS points FROM cms_users u, cms_blogs b WHERE b.user_id = u.id