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

SELECT THEM_ID,THEM_NOM,REST_V_ID FROM RESTAURANTS AS R LEFT JOIN R_THEME AS T ON T.THEM_ID=REST_THEM_ID WHERE REST_ARCHIVE=0 AND THEM_ID > 0 GROUP BY THEM_ID ORDER BY THEM_NOM