Switzerland Prealpes
Switzerland
Prealpes holidays
Activities
Resorts
Agglomerations
Accommodation
Photos album
Map
To be discovered
Gruyere / Pays d'Enhaut Valais region Lemanic Basin countryside of Suisse Romande Jura region
Gruyere
Prealpes
Valais
Lemanic
Countryside
Jura

Switzerland > Prealpes region > Activities

Sporting

   

Ski aera of the Berneuse
   
 

Order by:

results by page:
  copyright 2003 - 2009 Cityall S.à.r.l.  
  | Tourism guide of the French-speaking Switzerland.  
IDREG: 2
IDRUB: 2
IDSRUB: 2
IDSSRUB: 0 |
NBS: 5
-----------------
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 = '2' AND content_id.idrub = '2' AND content_id.idsrub = '2' AND content_id.existe_en_e = '1'
-----------------
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 = '2' AND content_id.idrub = '2' AND content_id.idsrub = '2' 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' ORDER BY content.nom_e LIMIT 0,10