MySQL Removing Duplicates

mysql> SELECT 
    seriesName,
    airedSeason,
    airedEpisodeNumber,
    episodeName,
    episodes.firstAired,
    episodes.id
FROM
    episodes
        JOIN
    series ON series.id = episodes.seriesID
WHERE
    episodes.id IN (SELECT DISTINCT
            (episodeID)
        FROM
            (SELECT 
                COUNT(*) AS qty, CAST(url AS BINARY), episodeID, url
            FROM
                links
            GROUP BY CAST(url AS BINARY) , url , episodeID
            HAVING qty > 1) AS temp);

mysql> DELETE T1 FROM links T1
        INNER JOIN
    links T2 
WHERE
    T1.id > T2.id
    AND CAST(T1.url AS BINARY) = CAST(T2.url AS BINARY)
    AND T2.episodeID = T1.episodeID
    AND T1.episodeID IN (7422123 , 7422121, 7169539, 6818831);