gistfile1.txt

mysql> select location.country from location, blocks where startIpNum < 2071690107 AND endIpNum > 2071690107 and blocks.locId = location.locId\G
*************************** 1. row ***************************
country: CN
1 row in set (0.87 sec)

mysql> select Location.country from Location, Blocks where startIpNum < 2071690107 AND endIpNum > 2071690107 and Blocks.locId = Location.locId
-> ;
+---------+
| country |
+---------+
| CN |
+---------+
1 row in set (0.59 sec)

mysql> select cc.cn from cc, ip where ip.start < 2071690107 AND ip.end > 2071690107 and ip.ci = cc.ci;
+-------+
| cn |
+-------+
| China |
+-------+
1 row in set (0.01 sec)