SELECT r.name as rname, c.name as cname, ip.city as cid, c.region_id as rid FROM ip2city.ip_compact ip INNER JOIN ip2city.cities c ON ip.city=c.city_id left join ip2city.regions r on r.region_id=c.region_id where ip.start_ip<=644595541 and ip.end_ip>=644595541Terms and abbreviations. japanese cars catalog
/ 
