| Tourism guide of the French-speaking Switzerland.
IDREG: 3 IDRUB: 8 IDSRUB: 18 IDSSRUB: 40 | Local craft NBS: 1 ----------------- SELECT content.id,content.nom_e,content.minidesc_e,ville_village.nom_e as lieu FROM content,content_id,ville_village WHERE content.id = content_id.idcontent AND ville_village.id = content.id_ville_village AND content_id.idreg = '3' AND content_id.idrub = '8' AND content_id.idsrub = '18' AND content_id.existe_en_e = '1' AND content_id.idssrub = '40' ----------------- SELECT content.id,content.nom_e, content.minidesc_e, content.photo_principale, content.nivdiff, content.duree, content.altitude, ville_village.nom_e as lieu, srubrique.nom_e as nomsrub, ssrubrique.nom_e as nomssrub, sssrubrique.nom_e as nomsssrub, srubrique.nom_url_e as nomurlsrub, ssrubrique.nom_url_e as nomurlssrub, sssrubrique.nom_url_e as nomurlsssrub FROM content,content_id,ville_village, srubrique,ssrubrique,sssrubrique WHERE content.id = content_id.idcontent AND ville_village.id = content.id_ville_village AND content_id.idreg = '3' AND content_id.idrub = '8' AND content_id.idsrub = '18' AND srubrique.id = content_id.idsrub AND ssrubrique.id = content_id.idssrub AND sssrubrique.id = content_id.idsssrub AND content_id.existe_en_e = '1' AND content_id.idssrub = '40' ORDER BY content.nom_e LIMIT 0,10
Switzerland
Saas Fee