Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT td_ip,
- TD_IP_TO_TIME_ZONE(td_ip) AS time_zone,
- TD_IP_TO_POSTAL_CODE(td_ip) AS postal,
- TD_IP_TO_COUNTRY_CODE(td_ip) AS country_code,
- TD_IP_TO_COUNTRY_NAME(td_ip) AS country_name,
- TD_IP_TO_CITY_NAME(td_ip) AS city_name,
- TD_IP_TO_LATITUDE(td_ip) AS lat,
- TD_IP_TO_LONGITUDE(td_ip) AS lon,
- TD_LAT_LONG_TO_COUNTRY(
- 'FULL_NAME', -- 'THREE_LETTER_ABBREVIATION', 'POSTAL_ABBREVIATION', 'SORTABLE_NAME' --
- TD_IP_TO_LATITUDE(td_ip),
- TD_IP_TO_LONGITUDE(td_ip)
- ) country2,
- TD_IP_TO_CONNECTION_TYPE(td_ip) AS conn,
- TD_IP_TO_DOMAIN(td_ip) AS domain
- FROM access_log
- WHERE td_ip IS NOT NULL
- LIMIT 10
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement