dnet45/modules/dnet-openaire-datasource-manager/trunk/src/main/resources/eu/dnetlib/enabling/datasources/queries/dsOrganizationsQuery.sql @ 51943
| 1 |
SELECT
|
|---|---|
| 2 |
org.id AS id, |
| 3 |
org.legalshortname AS legalshortname, |
| 4 |
org.legalname AS legalname, |
| 5 |
org.websiteurl AS websiteurl, |
| 6 |
org.logourl AS logourl, |
| 7 |
org.country AS country, |
| 8 |
org.collectedfrom AS collectedfrom, |
| 9 |
org.dateofcollection AS dateofcollection, |
| 10 |
org.provenanceaction AS provenanceaction |
| 11 |
FROM
|
| 12 |
dsm_organizations org |
| 13 |
LEFT OUTER JOIN dsm_datasource_organization dso ON (org.id = dso.organization) |
| 14 |
WHERE
|
| 15 |
dso.datasource = :dsId |