Project

General

Profile

« Previous | Next » 

Revision 57607

warnings

View differences:

schema.sql
1 1
DROP VIEW organizations_view;
2 2
DROP VIEW organizations_simple_view;
3 3
DROP VIEW users_view;
4
DROP VIEW warnings_view;
4 5

  
5 6
DROP TABLE IF EXISTS other_ids;
6 7
DROP TABLE IF EXISTS other_names;
......
195 196
GROUP BY u.email, u.valid, u.role
196 197
ORDER BY u.email;
197 198

  
199
CREATE VIEW warnings_view AS SELECT
200
    o1.id      AS id_1,
201
    o1.name    AS name_1,
202
    o1.type    AS type_1,
203
	o1.city    AS city_1,
204
	o1.country AS country_1,
205
    o2.id      AS id_2,
206
    o2.name    AS name_2,
207
    o2.type    AS type_2,
208
	o2.city    AS city_2,
209
	o2.country AS country_2
210
FROM
211
	openaire_simrels s
212
	LEFT OUTER JOIN organizations o1 ON (s.local_id = o1.id)
213
    LEFT OUTER JOIN organizations o2 ON (s.oa_original_id = o2.id)
214
WHERE
215
	s.oa_original_id LIKE 'openorgs____::%' AND o1.id IS NOT NULL AND O2.id IS NOT NULL;
216
	
198 217

  
218

  
199 219
	

Also available in: Unified diff