EHEC

SELECT * FROM documents WHERE
fts @@ to_tsquery('dutch', 'blutiger & Durchfall')
AND LANGUAGE='de';


SELECT * FROM documents WHERE
fts @@ to_tsquery('dutch', 'Bauchschmerzen')
AND LANGUAGE='de';

SELECT * FROM documents WHERE
fts @@ to_tsquery('dutch', 'Magen-Darm')
AND LANGUAGE='de';


SELECT * FROM documents WHERE
fts @@ to_tsquery('dutch', 'EHEC-Darminfektionen')
OR
fts @@ to_tsquery('dutch', 'EHEC & Darminfektionen ')
AND LANGUAGE='de';



SELECT * FROM documents WHERE
fts @@ to_tsquery('dutch', 'hämolytisch-urämische')
AND LANGUAGE='de';


-- HUS
SELECT documents.id, text
FROM documents, instances
WHERE documents.id=instances.item_id
AND entity_id=200987 -- = HUS entity
ORDER BY TIMESTAMP DESC
LIMIT 100;