Project

General

Profile

« Previous | Next » 

Revision 57750

bug fix

View differences:

modules/dnet-orgs-database-application/trunk/src/main/resources/sql/schema.sql
166 166
	org.creation_date,
167 167
	org.modified_by,
168 168
	org.modification_date,
169
	count(r.id1)      as n_rels,
170
	count(e.local_id) as n_enrichments,
171
	count(c.local_id) as n_conflicts
169
	count(DISTINCT r.id2)      as n_rels,
170
	count(DISTINCT e.oa_original_id) as n_enrichments,
171
	count(DISTINCT c.oa_original_id) as n_conflicts
172 172
FROM organizations org
173
	LEFT OUTER JOIN relationships r ON (org.id = r.id1)
173
	LEFT OUTER JOIN relationships r    ON (org.id = r.id1)
174 174
	LEFT OUTER JOIN openaire_simrels e ON (org.id = e.local_id AND e.oa_original_id NOT LIKE 'openorgs____::%')
175 175
	LEFT OUTER JOIN openaire_simrels c ON (org.id = c.local_id AND c.oa_original_id LIKE 'openorgs____::%')
176 176
GROUP BY org.id;

Also available in: Unified diff