24h interdisziplinäres Notfallzentrum Falls Sie notfallmässig ins Spital eintreten müssen, melden Sie sich bitte am Empfang.
Sanitätsnotruf Tel. 144
Adresse Spital Oberengadin Via Nouva 3 CH-7503 Samedan
SELECT
pid,
CType,
deleted,
hidden,
colPos,
records,
starttime,
endtime
FROM
tt_content
WHERE
pid = '6' AND hidden = '0' AND deleted = '0' AND CType = 'shortcut' AND colPos = '3' AND
((starttime <= 1369032744 AND endtime >= 1369032744) OR (starttime <= 1369032744 AND endtime = '') OR (starttime = '' AND endtime >= 1369032744) OR (starttime = '' AND endtime = ''))
LIMIT
1
