query = SELECT intern.id,intern.pref,intern.nome,intern.post,intern.href,intern.lingue,loc.uk,prov.abb,intern.album,intern.lastm,intern.lasturl,categorie.img,categorie.classe,loc.id,loc.href,loc.lingue,prov.uk,intern.id_gruppo,intern.logo_gruppo,intern.videoid FROM intern,loc,prov,categorie,intcat WHERE intern.loc=loc.id AND (categorie.classe=1 OR categorie.classe=2 OR categorie.classe=3 OR categorie.classe=4 OR categorie.classe=6 OR categorie.classe=9) AND intcat.intern=intern.id AND (intcat.servizi not like '%V%' OR intcat.servizi like '%W%') AND (categorie.id=intcat.cat1 OR categorie.id=intcat.cat2 OR categorie.id=intcat.cat3 OR categorie.id=intcat.cat4 OR categorie.id=intcat.cat5) AND intern.onoff=1 AND loc.prov=prov.id AND prov.reg='24' ORDER BY prov.it,loc.capol desc,loc.uk,categorie.classe,categorie.pos,intern.nome;
Auvergne and around
Burgundy and around
| Campings - Tourist Villages Vougeot |
|
|
Bretagne and around
| Campings - Tourist Villages Cancale |
|
|
| Campings - Tourist Villages Saint-Malo |
|
|
Centre - Val-de-Loire and around
| Campings - Tourist Villages Amboise |
|
|
| Hotels Chissay-en-Touraine |
| Campings - Tourist Villages Chissay-en-Touraine |
|
|
| Campings - Tourist Villages Luynes |
|
|
| Campings - Tourist Villages Montbazon |
|
|
| Hotels St. Symphorien le Château |
| Campings - Tourist Villages St. Symphorien le Château |
|
|
| Campings - Tourist Villages Tours |
|
|
Ile de France and around
| Campings - Tourist Villages Cernay-la-Ville |
|
|
| Campings - Tourist Villages Yerres |
|
|
Languedoc-Roussillon and around
Normandy and around
| Hotels Douains - Pacy-sur-Eure |
| Campings - Tourist Villages Douains - Pacy-sur-Eure |
|
|
| Campings - Tourist Villages Le Mont Saint Michel |
|
|
Paris and around
Pays de Loire and around
| Hotels Chênehutte-les-Tuffeaux |
| Campings - Tourist Villages Chênehutte-les-Tuffeaux |
|
|
| Campings - Tourist Villages Nantes |
|
|
Picardie and around
Rhône Alpes and around
| Campings - Tourist Villages Divonne-les-Bains |
|
|
| Farm Holidays Evian-les-Bains |
| Campings - Tourist Villages Evian-les-Bains |
|
|
