lol.sql

SELECT net_country.name_ru AS country_name, net_city.name_ru AS city_name FROM net_country_ip JOIN net_country ON (net_country_ip.begin_ip <= '1347219964' AND net_country_ip.end_ip >= '1347219964') AND (net_country_ip.country_id = net_country.id) JOIN net_city_ip ON (net_city_ip.begin_ip <= '1347219964' AND net_city_ip.end_ip >= '1347219964') JOIN net_city ON net_city_ip.city_id = net_city.id