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 = '6' AND hidden = '0' AND deleted = '0' AND CType = 'shortcut' AND colPos = '3' AND
((starttime <= 1368972139 AND endtime >= 1368972139) OR (starttime <= 1368972139 AND endtime = '') OR (starttime = '' AND endtime >= 1368972139) OR (starttime = '' AND endtime = ''))
LIMIT
1
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 <= 1368972139 AND endtime >= 1368972139) OR (starttime <= 1368972139 AND endtime = '') OR (starttime = '' AND endtime >= 1368972139) OR (starttime = '' AND endtime = ''))
LIMIT
1
