Advertisement
Guest User

Untitled

a guest
Oct 4th, 2012
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.20 KB | None | 0 0
  1. SELECT
  2.   l.*,
  3.   i.i_co
  4. FROM logs AS l
  5.   INNER JOIN ip_country i
  6.     ON (i_f <= REPLACE(l_radd, '.', '')
  7.         AND i_t >= REPLACE(l_radd, '.', ''))
  8. WHERE l_gid = 'mygid'
  9. ORDER BY l_time DESC
  10. LIMIT 5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement