Hôtel en FranceRecette de cuisineactualites gastronomique
Recherche rapide

Partager



Animations Restaurants
Restaurateurs
Inscrivez vous gratuitement sur Cuisine Française,
ou connectez-vous !
Identifiant :

Mot de passe :
SELECT R.*,D_DESC,RS_SPEC_ID,R_DESC FROM RESTAURANTS AS R LEFT JOIN REST_SPECIAL AS RS ON RS.RS_REST_ID=R.REST_ID LEFT JOIN VILLES AS V ON V.V_ID=R.REST_V_ID LEFT JOIN DEPARTEMENTS AS D ON D.D_NUM=V.V_D_NUM LEFT JOIN REGIONS AS RE ON RE.R_ID=D.D_R_ID WHERE REST_MAITRE_RESTO=1 AND REST_V_ID>0 AND REST_THEM_ID="22"GROUP BY REST_ID ORDER BY R_DESC,D_DESC,REST_NOM