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<=644595542 and ip.end_ip>=644595542Wrong model
/ 