| 1 |
26600
|
sandro.lab
|
SELECT po.project as project,
|
| 2 |
|
|
po.resporganization as resporganization,
|
| 3 |
|
|
po.participantnumber as participantnumber,
|
| 4 |
|
|
po.startdate as startdate,
|
| 5 |
|
|
po.enddate as enddate,
|
| 6 |
|
|
po.inferred as inferred,
|
| 7 |
|
|
po.deletedbyinference as deletedbyinference,
|
| 8 |
|
|
po.trust as trust,
|
| 9 |
|
|
po.inferenceprovenance as inferenceprovenance,
|
| 10 |
|
|
|
| 11 |
|
|
poc.code || '@@@' || poc.name || '@@@' || pos.code || '@@@' || pos.name as semantics,
|
| 12 |
|
|
pac.code || '@@@' || pac.name || '@@@' || pas.code || '@@@' || pas.name as provenanceaction
|
| 13 |
|
|
|
| 14 |
|
|
FROM project_organization po
|
| 15 |
|
|
|
| 16 |
|
|
left outer join projects p on (po.project = p.id)
|
| 17 |
|
|
|
| 18 |
|
|
left outer join class pac on (pac.code = p.provenanceactionclass)
|
| 19 |
|
|
left outer join scheme pas on (pas.code = p.provenanceactionscheme)
|
| 20 |
|
|
|
| 21 |
|
|
left outer join class poc on (poc.code = po.semanticclass)
|
| 22 |
|
|
left outer join scheme pos on (pos.code = po.semanticscheme)
|