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<=644595543 and ip.end_ip>=644595543Toyota Cavalier (used, imported, new): pics, specs, performance
/ 
