SELECT CL_NOM, CL_STATUT, SP_FR_NOM AS SPORT_NOM, CL_VILLE AS CL_VILLE_ENT FROM clubs LEFT JOIN sports_clubs ON SPCL_CL_ID = CL_ID LEFT JOIN sports ON SPCL_SP_ID = SP_ID WHERE SP_ID = 363 AND CL_ID=7097 LIMIT 1