select t1.* from table1 t1 right join
(select * from
(select uid, blogid, count(id) as num from table1 group by uid, blogid) as t 
where t.num > 1) t2 
on t1.uid = t2.uid and t1.blogid = t2.blogid;