SELECT * FROM ps_guest
WHERE realityName IN(
SELECT realityName FROM
`cts_ps`.`ps_guest`
GROUP BY realityName
HAVING COUNT(`realityName`)>1);
WHERE realityName IN(
SELECT realityName FROM
`cts_ps`.`ps_guest`
GROUP BY realityName
HAVING COUNT(`realityName`)>1);