SELECT DISTINCT region, c.id_camping, nom, adresse, ville AS ville_fr, c.id_ville, province, en, COUNT(*) as NbCampings, r.coordonees 
	FROM camping c 
	INNER JOIN paiement p ON c.id_camping=p.id_camping 
	INNER JOIN region r ON c.region=r.id_region
	WHERE sitetour LIKE '%/3/%' 
	GROUP BY region 
	ORDER BY region ASC - User 'bcxisancamping' has exceeded the 'max_questions' resource (current value: 26408)