Revision 57397
Added by Michele Artini over 4 years ago
| queryOrganizationsFromOpenOrgsDB.sql | ||
|---|---|---|
| 13 | 13 |
'OpenOrgs Database' AS collectedfromname, |
| 14 | 14 |
o.country || '@@@dnet:countries' AS country, |
| 15 | 15 |
'sysimport:crosswalk:entityregistry@@@sysimport:crosswalk:entityregistry@@@dnet:provenance_actions@@@dnet:provenance_actions' AS provenanceaction, |
| 16 |
--array_agg(DISTINCT i.otherid || '###' || i.type) AS pid |
|
| 17 |
ARRAY[]::text[] AS pid |
|
| 16 |
array_agg(DISTINCT i.otherid || '###' || i.type || '@@@dnet:pid_types') AS pid |
|
| 18 | 17 |
FROM organizations o |
| 19 | 18 |
LEFT OUTER JOIN acronyms a ON (a.id = o.id) |
| 20 | 19 |
LEFT OUTER JOIN urls u ON (u.id = o.id) |
Also available in: Unified diff
(openorgs) added schemeid to pids in sql query