Advertisement
TDCustmerSupportJP

Untitled

Aug 13th, 2017
22,299
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.63 KB | None | 0 0
  1. SELECT td_ip,
  2.   TD_IP_TO_TIME_ZONE(td_ip) AS time_zone,
  3.   TD_IP_TO_POSTAL_CODE(td_ip) AS postal,
  4.   TD_IP_TO_COUNTRY_CODE(td_ip) AS country_code,
  5.   TD_IP_TO_COUNTRY_NAME(td_ip) AS country_name,
  6.   TD_IP_TO_CITY_NAME(td_ip) AS city_name,
  7.   TD_IP_TO_LATITUDE(td_ip) AS lat,
  8.   TD_IP_TO_LONGITUDE(td_ip) AS lon,
  9.  
  10.   TD_LAT_LONG_TO_COUNTRY(
  11.     'FULL_NAME', -- 'THREE_LETTER_ABBREVIATION', 'POSTAL_ABBREVIATION', 'SORTABLE_NAME' --
  12.     TD_IP_TO_LATITUDE(td_ip),
  13.     TD_IP_TO_LONGITUDE(td_ip)
  14.   ) country2,
  15.  
  16.   TD_IP_TO_CONNECTION_TYPE(td_ip) AS conn,
  17.   TD_IP_TO_DOMAIN(td_ip) AS domain
  18. FROM access_log
  19. WHERE td_ip IS NOT NULL
  20. LIMIT 10
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement