(SELECT Colaboradors.codi, Zonas2.Zona_ca, Colaboradors.Id, Colaboradors.Colaborador_ca,Colaboradors.url_directa_ca, Colaboradors.mostrar, Colaboradors.codi, Colaboradors.Direccio, Colaboradors.Codi_postal, Colaboradors.Poblacio, Colaboradors.Email, Colaboradors.Telefon, Colaboradors.Web, Colaboradors.Latitud, Colaboradors.Longitud, Colaboradors.Zona, TipoColaboradors.Carpeta_es, TipoColaboradors.Carpeta_ca FROM Colaboradors, TipoColaboradors, Zonas, Zonas AS Zonas2, Colaboradors_TipoColaboradors WHERE Colaboradors_TipoColaboradors.Colaborador=Colaboradors.Id AND Colaboradors_TipoColaboradors.TipoColaborador='1' AND Colaboradors.Zona=Zonas.Id AND Zonas.Ensemble=Zonas2.Id AND Colaboradors.tipo=TipoColaboradors.Id AND Colaboradors.mostrar='S' AND Colaboradors.Estat='6' ORDER BY rand())
![Hotel ALBARES*** Hotel ALBARES***](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-albares-vielha.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hostal CASA PALMIRA Hostal CASA PALMIRA](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hostal-casa-palmira-espot.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel Restaurant LO PALLER** Hotel Restaurant LO PALLER**](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-lo-paller.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hostal CAL FRANCISCÓ Hostal CAL FRANCISCÓ](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hostal-cal-francisco-gosol.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel Restaurant VALLFERRERA Hotel Restaurant VALLFERRERA](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-vallferrera.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel TERRADETS i Restaurant del LLAC Hotel TERRADETS i Restaurant del LLAC](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-terradets-cellers.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![CASA LEONARDO - Allotjament Rural CASA LEONARDO - Allotjament Rural](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/casa-leonardo.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel Restaurant CAN BOIX DE PERAMOLA**** Hotel Restaurant CAN BOIX DE PERAMOLA****](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-can-boix.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel FARRÉ D´AVALL Hotel FARRÉ D´AVALL](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-farre-d-avall-barruera.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel MIRADOR** Hotel MIRADOR**](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-mirador-lles-de-cerdanya.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel PLAYASOL**** de Cadaqués Hotel PLAYASOL**** de Cadaqués](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-playa-sol-cadaques.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel ARAGÜELLS** Hotel ARAGÜELLS**](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-araguells-benasque.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel CIRIA*** Hotel CIRIA***](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-ciria.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![CERDANYA ECORESORT CERDANYA ECORESORT](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-muntanya-prullans-cerdanya-ecoresort.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![ELS TORRENTS - Hotel Rural i Restaurant ELS TORRENTS - Hotel Rural i Restaurant](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-els-torrents.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel Restaurant LES BRASES*** Hotel Restaurant LES BRASES***](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-restaurant-les-brases-sort.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel Apartaments TRAINERA Hotel Apartaments TRAINERA](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-apartaments-trainera.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel i Hostal PEY Hotel i Hostal PEY](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-hostal-pey-boi.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel PESSETS**** Hotel PESSETS****](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-pessets-sort.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel SAURAT*** Hotel SAURAT***](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-saurat-espot.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel Rural-Spa RESGUARD DELS VENTS**** Hotel Rural-Spa RESGUARD DELS VENTS****](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-resguard-dels-vents.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel CARDÓS Hotel CARDÓS](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-cardos.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![MAS GRAMUNTILL - Allotjament Rural MAS GRAMUNTILL - Allotjament Rural](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/masia-gramuntill.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Fonda CAN FASÈRSIA Fonda CAN FASÈRSIA](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/fonda-can-fasersia.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel ESTANYS BLAUS*** Hotel ESTANYS BLAUS***](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-estanys-blaus.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel LLACS DE CARDÓS* Hotel LLACS DE CARDÓS*](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-llacs-de-cardos.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![FONDA XESC - Restaurant i Hotel FONDA XESC - Restaurant i Hotel](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/fonda-xesc-gombren-ripolles.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Alberg Rural CA L´ANTON Alberg Rural CA L´ANTON](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/alberg-ca-anton-pujalt.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hostal Restaurant LA PLAÇA** Hostal Restaurant LA PLAÇA**](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hostal-la-placa-boi.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel Restaurant ARTURO Hotel Restaurant ARTURO](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-arturo.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hostal Restaurant FONDA DOMINGO Hostal Restaurant FONDA DOMINGO](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/restaurant-fonda-domingo.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel SABOCOS*** Hotel SABOCOS***](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-sabocos-panticosa.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)
![Hotel DETH PAIS Hotel DETH PAIS](https://www.rutespirineus.cat/imagenes/colaboradors/310x128/hotel-deth-pais.jpg)
Detall![detalle](https://www.rutespirineus.cat/imagenes/detalle.png)