Revision 57804
Added by Michele Artini over 4 years ago
| schema.sql | ||
|---|---|---|
| 174 | 174 |
count(DISTINCT c.oa_original_id) as n_conflicts |
| 175 | 175 |
FROM organizations org |
| 176 | 176 |
LEFT OUTER JOIN openaire_simrels e ON (org.id = e.local_id AND e.oa_original_id NOT LIKE 'openorgs____::%' AND e.reltype = 'suggested') |
| 177 |
LEFT OUTER JOIN openaire_simrels c ON (org.id = c.local_id AND c.oa_original_id LIKE 'openorgs____::%' AND e.reltype = 'suggested')
|
|
| 177 |
LEFT OUTER JOIN openaire_simrels c ON (org.id = c.local_id AND c.oa_original_id LIKE 'openorgs____::%' AND c.reltype = 'suggested')
|
|
| 178 | 178 |
GROUP BY org.id; |
| 179 | 179 |
|
| 180 | 180 |
CREATE VIEW organizations_simple_view AS SELECT |
Also available in: Unified diff