SELECT 
	TableHydrant.idHydrant AS idHydrant,	
	TableAnomalies.anomaliesHydrant AS anomaliesHydrant,	
	TableHydrantsAnomalies.numeroAnomalie AS numeroAnomalie,	
	TableCommunes.commune AS commune
FROM 
	TableCommunes,	
	TableHydrantsAnomalies,	
	TableAnomalies,	
	TableHydrant
WHERE 
		TableAnomalies.numeroAnomalie	=	TableHydrantsAnomalies.numeroAnomalie
	AND	TableHydrant.idHydrant	=	TableHydrantsAnomalies.idHydrant
	AND	TableCommunes.inseeCommune	=	TableHydrant.inseeCommune
	AND
	(
		TableCommunes.commune LIKE {Param_commune}%
	)
ORDER BY 
	idHydrant ASC