select id, lat, lon, concat_ws( ' ', address_1, address_2, address_3, city, state, zip ) 'address' from av_voice_locations where ( lat < 1 or lat is NULL or lon >-1 or lon is NULL ) and replace( concat( city, zip, state ), ' ', '' ) != ''

The Appalachian Voice is distributed to 4 locations.

Geocode Locations without a Lat and Lon