BkxmS63K

1CREATE TABLE IF NOT EXISTS ChatDuplicates LIKE Chat;
2
3INSERT INTO ChatDuplicates
4SELECT * FROM Chat
5WHERE chatID IN(
6    SELECT chatID
7    FROM discoverydb.Chat WHERE chatID NOT IN ( 
8	    SELECT chatID FROM ChatDuplicates 
9    ) 
10    GROUP By CONCAT(message,userID) HAVING COUNT(CONCAT(message,userID)) >= 2
11)