Genießen Sie diese unvergessliche Schneeschuhwanderung im Hafen von Navafría für vier Stunden mit Freunden oder der Familie. Wenn Sie kommen, versichern wir Ihnen, dass Sie es nie bereuen werden!
SELECT IF(ISNULL(N_OFERTAS),0,N_OFERTAS)+IF(ISNULL(N_EMPRESAS),0,N_EMPRESAS) AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas,
PO.ID_POBLACION, PO.DESC_POBLACION, PO.URL_POBLACION AS URL_POBLACION, PO.ID_REGION,
REI.DESC_REGION, REI.URL AS URL_REGION,
'' AS ID_GRUPO, SECI.DESC_SECTOR AS DESC_SECTOR, SECI.URL AS URL_SECTOR
FROM
LO_POBLACION_ES_STATS PS
INNER JOIN LO_POBLACION_ES PO ON PS.ID_POBLACION = PO.ID_POBLACION AND PO.IDIOMA = 'de' AND PO.ID_REGION IN (3044)
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PO.ID_REGION AND REI.IDIOMA = 'de'
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_SECTOR AND SECI.FK_ID_IDIOMA_SI18N = 'de'
WHERE (PS.N_OFERTAS > 0 )
AND PS.ID_SECTOR = 38
GROUP BY PS.ID_POBLACION
ORDER BY N_OFERTAS DESC
SELECT IF(ISNULL(N_OFERTAS),0,N_OFERTAS)+IF(ISNULL(N_EMPRESAS),0,N_EMPRESAS) AS NEMPRESAS, N_OFERTAS AS NumOfertas, N_EMPRESAS as NumEmpresas,
PO.ID_POBLACION, PO.DESC_POBLACION, PO.URL_POBLACION AS URL_POBLACION, PO.ID_REGION,
REI.DESC_REGION, REI.URL AS URL_REGION,
'' AS ID_GRUPO, SECI.DESC_SECTOR AS DESC_SECTOR, SECI.URL AS URL_SECTOR
FROM
LO_POBLACION_ES_STATS PS
INNER JOIN LO_POBLACION_ES PO ON PS.ID_POBLACION = PO.ID_POBLACION AND PO.IDIOMA = 'de' AND PO.ID_REGION IN (3044)
INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PO.ID_REGION AND REI.IDIOMA = 'de'
INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_SECTOR AND SECI.FK_ID_IDIOMA_SI18N = 'de'
WHERE (PS.N_OFERTAS > 0 )
AND PS.ID_SECTOR = 38
GROUP BY PS.ID_POBLACION
ORDER BY N_OFERTAS DESC
preise Schneeschuhwandern in Navafría nach Standort:
