 |
Weiterführende Info |
|
|
|
|
|
Spital der erweiterten Grundversorgung
Das Spital Oberengadin ist zuständig für die medizinische Versorgung der Bevölkerung und den Gästen der Region Oberengadins. |
|
|
|
|
SELECT
pid,
CType,
deleted,
hidden,
colPos,
records,
starttime,
endtime
FROM
tt_content
WHERE
pid = '1' AND hidden = '0' AND deleted = '0' AND CType = 'shortcut' AND colPos = '3' AND
((starttime <= 1369249036 AND endtime >= 1369249036) OR (starttime <= 1369249036 AND endtime = '') OR (starttime = '' AND endtime >= 1369249036) OR (starttime = '' AND endtime = ''))
LIMIT
1
SELECT
uid,
pid,
deleted,
hidden,
name,
title,
email,
phone,
tx_ttaddressadd_funktion,
image,
fax
FROM
tt_address
WHERE
uid = '' AND hidden = '0' AND deleted = '0'
LIMIT
1
SELECT
pid,
CType,
deleted,
hidden,
colPos,
records,
starttime,
endtime
FROM
tt_content
WHERE
pid = '4' AND hidden = '0' AND deleted = '0' AND CType = 'shortcut' AND colPos = '3' AND
((starttime <= 1369249036 AND endtime >= 1369249036) OR (starttime <= 1369249036 AND endtime = '') OR (starttime = '' AND endtime >= 1369249036) OR (starttime = '' AND endtime = ''))
LIMIT
1
|
|
|
|
|
| Kontakt |
Spital Oberengadin
Empfang - Auskunft
Tel. +41 (0)81 851 81 11
Fax +41 (0)81 851 85 05
Kontakt |
|
|
|
|
|
|
|
