SELECT
    SUBSTR(site, 1 , LOCATE('/', site, 8)-1)
        as Domain
    FROM tablo
    GROUP BY Domain
    ORDER BY id DESC LIMIT 50
Dener misin ?