dnet45/modules/dnet-openaireplus-datasource-manager/trunk/src/main/resources/eu/dnetlib/enabling/datasources/simpleFindRepos.sql.st @ 49662
| 1 |
SELECT
|
|---|---|
| 2 |
d.id AS id, |
| 3 |
d.officialname AS name, |
| 4 |
array_agg(DISTINCT a.id) AS apis |
| 5 |
FROM
|
| 6 |
datasources d |
| 7 |
LEFT OUTER JOIN api a ON (d.id = a.datasource) |
| 8 |
WHERE
|
| 9 |
datasourceclass = '$type$' |
| 10 |
GROUP BY |
| 11 |
d.id, |
| 12 |
d.officialname |
| 13 |
ORDER BY |
| 14 |
d.officialname |
| 15 |
|