SELECT COUNT(*)
FROM reactions_tweet_1
WHERE id
NOT IN
    (SELECT MAX(dup.id)
    FROM reactions_tweet_1
    AS dup
    GROUP BY dup.tweet_id);