An Error occured!SQLSTATE[42S22]: Column not found: 1054 Unknown column 'co.country_value_' in 'field list'
select c.campsite_id, /*str_radius*/
c.campsite_name,
co.country_value_ as country,
cr.country_region_value_ as region,
c.campsite_country, c.campsite_region,c.campsite_street
from campsites c
inner join country co on co.country_id = c.campsite_country
inner join country_region cr on cr.country_region_id = c.campsite_region
where c.campsite_shortcut=''