SELECT DISTINCT countries.country, countries.id_country, regions.region, regions.id_region, towns.Town, towns.id_town FROM countries, regions, towns, sites WHERE sites.id_country = countries.id_country AND sites.id_region = regions.id_region AND sites.id_town = towns.id_town AND sites.id_all = '1' ORDER BY towns.Town

Table 'cl5vanco_sites2.regions' doesn't exist