Re: How can I optimize this query?

[Rick James]

See if this is closer to finding all the results in a single query:

SELECT cl.country, cl.region, cl.city
    FROM ( SELECT
                ( SELECT endIpNum
                    FROM geoipdb.CityBlocks
                    WHERE endIpNum >= o.longip
                    ORDER BY endIpNum
                    LIMIT 1
                )  AS endIpNum
            FROM ( SELECT distinct longip FROM whyu.stats ) o
          ) a
    JOIN geoipdb.CityBlocks cb    ON cb.endIpNum = a.endIpNum
    JOIN geoipdb.CityLocation cl  ON cl.locId = cb.locId;

This requires a UNIQUE index on cb.endIpNum.