This query is to find geolocation of an IP address including latitude, longitude, city and country.
Legacy SQL doesn't support range conditions such as
BETWEEN when using
JOIN, so we need to filter data by
This means if IP address does not match any of the data inside
geolite_city_bq_b2b, records will not be able to receive.
Use Standard SQL if you want to receive records no matter you succeed to find geolocation or not.
Please refer to the following post for more detail.