SELECT rank, domain, SUBSTRING_INDEX( domain, '.', -1 ) AS tld, inet_ntoa(ip) as ip, countryshort FROM `tgwf_alexa_201510` order by rank, id
