Revision 48139
Added by Alessia Bardi almost 7 years ago
| dataciteSets_findDataRepos.sql | ||
|---|---|---|
| 1 | 1 |
SELECT |
| 2 |
id as id,
|
|
| 3 |
officialname as name,
|
|
| 4 |
englishname as englishname,
|
|
| 5 |
datasourceclass as class
|
|
| 2 |
id AS id,
|
|
| 3 |
officialname AS name,
|
|
| 4 |
englishname AS englishname,
|
|
| 5 |
datasourceclass AS class
|
|
| 6 | 6 |
FROM |
| 7 | 7 |
datasources |
| 8 | 8 |
WHERE |
| 9 |
datasourceclass like '%datarepository%' |
|
| 9 |
datasourceclass LIKE '%datarepository%' |
|
Also available in: Unified diff
integrated (hopefully) all required changes from dnet40