SELECT domain, SUBSTRING_INDEX( domain, '.', -1 ) AS tld, inet_ntoa(ip) as ip, greencheck, countrylong, hoster FROM `tgwf_alexa_201601` order by id
