dnet45/modules/dnet-openaireplus-datasource-manager/trunk/src/main/resources/eu/dnetlib/enabling/datasources/findReposMap.sql.st @ 49662
| 1 |
SELECT
|
|---|---|
| 2 |
d.id AS id, |
| 3 |
d.officialname AS name, |
| 4 |
d.latitude AS lat, |
| 5 |
d.longitude AS lng |
| 6 |
FROM datasources d |
| 7 |
LEFT OUTER JOIN api a ON (d.id = a.datasource) |
| 8 |
WHERE a.active = true AND d.latitude IS NOT NULL AND d.longitude IS NOT NULL |