SELECT tjid
FROM userlist
GROUP BY tjid
HAVING COUNT( mid ) =2
FROM userlist
GROUP BY tjid
HAVING COUNT( mid ) =2
LIMIT 0 , 30
SELECT * FROM userlist GROUP BY tjid HAVING COUNT( mid ) =2 LIMIT 0 , 30