Restaurants en France : trouvez rapidement un restaurant en France près de chez vous.

SELECT S.SPEC_ID,SPEC_NOM,SPEC_CAT,REST_V_ID FROM REST_SPECIAL AS RS LEFT JOIN R_SPECIALITES AS S ON S.SPEC_ID=RS.RS_SPEC_ID LEFT JOIN RESTAURANTS AS R ON R.REST_ID=RS.RS_REST_ID WHERE REST_ARCHIVE=0 AND REST_R_SPEC <>"" GROUP BY S.SPEC_ID ORDER BY SPEC_CAT,SPEC_NOM