Grösster Arbeitgeber im Oberengadin Das Spital Oberengadin beschäftigt rund 300 Personen (220 Vollzeitstellen) und ist somit übers ganze Jahr gesehen wohl der grösste Arbeitgeber im Oberengadin.
SELECT
pid,
CType,
deleted,
hidden,
colPos,
records,
starttime,
endtime
FROM
tt_content
WHERE
pid = '7' AND hidden = '0' AND deleted = '0' AND CType = 'shortcut' AND colPos = '3' AND
((starttime <= 1371599111 AND endtime >= 1371599111) OR (starttime <= 1371599111 AND endtime = '') OR (starttime = '' AND endtime >= 1371599111) OR (starttime = '' AND endtime = ''))
LIMIT
1
SELECT
pid,
CType,
deleted,
hidden,
colPos,
records,
starttime,
endtime
FROM
tt_content
WHERE
pid = '0' AND hidden = '0' AND deleted = '0' AND CType = 'shortcut' AND colPos = '3' AND
((starttime <= 1371599111 AND endtime >= 1371599111) OR (starttime <= 1371599111 AND endtime = '') OR (starttime = '' AND endtime >= 1371599111) OR (starttime = '' AND endtime = ''))
LIMIT
1
