dnet45/modules/dnet-openaire-datasource-manager/trunk/src/main/resources/eu/dnetlib/enabling/datasources/queries/searchDsByType.sql @ 62942
1 |
SELECT
|
---|---|
2 |
ds.id AS id, |
3 |
ds.officialname AS name, |
4 |
ds.eosc_datasource_type AS eosc_datasource_type, |
5 |
array_agg(a.id) AS apis |
6 |
FROM
|
7 |
dsm_services ds |
8 |
LEFT OUTER JOIN dsm_api a ON (ds.id = a.service) |
9 |
WHERE
|
10 |
ds.eosc_datasource_type = :type AND ds.dedup_main_service = true |
11 |
GROUP BY |
12 |
ds.id, ds.officialname, ds.eosc_datasource_type |
13 |
ORDER BY |
14 |
ds.officialname |