valiop ( SELECT b.blocks_id, b.startIpNum, b.endIpNum, l.country, l.region, l.city, l.latitude, l.longitude, c1.admin1_name, p.Country, p.geonameid FROM blocks AS b LEFT JOIN location AS l USING ( locId ) LEFT JOIN admin1Code AS c1 ON c1.country_code = l.country AND c1.admin1_code = l.region LEFT JOIN countryInfo AS p ON l.country = p.ISO WHERE `startIpNum` <= INET_ATON( '38.103.63.59' ) ORDER BY startIpNum DESC LIMIT 0 , 1 ) UNION ( SELECT b.blocks_id,b.startIpNum, b.endIpNum, l.country, l.region, l.city, l.latitude, l.longitude, c1.admin1_name, p.Country, p.geonameid FROM blocks AS b LEFT JOIN location AS l USING ( locId ) LEFT JOIN admin1Code AS c1 ON c1.country_code = l.country AND c1.admin1_code = l.region LEFT JOIN countryInfo AS p ON l.country = p.ISO WHERE `endIpNum` >= INET_ATON( '38.103.63.59' ) LIMIT 0 , 1 )