D-Net

SELECT

	po.project                                                              AS project,

	po.resporganization                                                     AS resporganization,

	po.participantnumber                                                    AS participantnumber,

	po.startdate                                                            AS startdate,

	po.enddate                                                              AS enddate,

	po.inferred                                                             AS inferred,

	po.deletedbyinference                                                   AS deletedbyinference,

	po.trust                                                                AS trust,

	po.inferenceprovenance                                                  AS inferenceprovenance,

	poc.code || '@@@' || poc.name || '@@@' || pos.code || '@@@' || pos.name AS semantics,

	pac.code || '@@@' || pac.name || '@@@' || pas.code || '@@@' || pas.name AS provenanceaction

	LEFT OUTER JOIN projects p ON (po.project = p.id)

	LEFT OUTER JOIN class pac ON (pac.code = p.provenanceactionclass)

	LEFT OUTER JOIN scheme pas ON (pas.code = p.provenanceactionscheme)

	LEFT OUTER JOIN class poc ON (poc.code = po.semanticclass)

	LEFT OUTER JOIN scheme pos ON (pos.code = po.semanticscheme)