dnet45/modules/dnet-openaire-projects-exporter/trunk/src/main/resources/eu/dnetlib/openaire/exporter/sql/projects_tsv.sql.st @ 46537
1 |
SELECT
|
---|---|
2 |
code, |
3 |
acronym, |
4 |
title, |
5 |
call_identifier, |
6 |
startdate, |
7 |
enddate, |
8 |
oa_mandate_for_publications, |
9 |
oa_mandate_for_datasets, |
10 |
description, |
11 |
legalname, |
12 |
country, |
13 |
role, |
14 |
firstname, |
15 |
secondnames, |
16 |
email
|
17 |
FROM projects_tsv |
18 |
WHERE fundingpathid like '$fundingprefix$%'$filters.keys:{k| AND $k$=$filters.(k)$}$ |
19 |
ORDER BY acronym |
- « Previous
- 1
- 2
- 3
- Next »