Revision 52325
Added by Claudio Atzori almost 6 years ago
| materialised_views.sql | ||
|---|---|---|
| 240 | 240 |
LEFT OUTER JOIN projectpids pp ON (pp.project = p.id) |
| 241 | 241 |
LEFT OUTER JOIN identities i ON (i.pid = pp.pid) |
| 242 | 242 |
|
| 243 |
LEFT OUTER JOIN datasources dc ON (dc.id = p.collectedfrom) |
|
| 243 |
LEFT OUTER JOIN dsm_datasources dc ON (dc.id = p.collectedfrom)
|
|
| 244 | 244 |
|
| 245 | 245 |
LEFT OUTER JOIN project_fundingpath pf ON (pf.project = p.id) |
| 246 | 246 |
LEFT OUTER JOIN fundingpaths fp ON (fp.id = pf.funding) |
Also available in: Unified diff
using dsm_datasources in sql expressions