SELECT distinct o.title, o.source_opus, o.date_year, o.source_title, o.type FROM opus o, opus_autor oa WHERE o.source_opus = oa.source_opus and oa.creator_name LIKE 'Hägele, Nicola%' AND (o.bereich_id is not null or o.bereich_id is null) ORDER BY o.date_year DESC, o.title

1 Treffer

1

SELECT dokumentart FROM resource_type_de WHERE typeid='7'
SELECT creator_name, reihenfolge from opus_autor where source_opus = 62 ORDER BY reihenfolge
1. Koffein und Diurese
Hägele, Nicola
2004

1