Project

General

Profile

« Previous | Next » 

Revision 61861

Added by Michele Artini over 2 years ago

new dsm_services table

View differences:

pangaea_journal_findmatches.sql
4 4 
		p.oa_source_id,
5 5 
		p.id,
6 6 
		d.id
7 
	FROM dsm_datasources d, pangaea_temp_journals p
7 
	FROM dsm_services d, pangaea_temp_journals p
8 8 
	WHERE
9 9 
		d.collectedfrom = 'driver______::1790119e-d281-4b7a-aedf-866d1d853a07' AND d.issn IS NOT NULL AND d.id LIKE 'doajarticles::%' AND p.issn = d.issn
10 10 
		AND
......
20 20 
		p.id || '@@' || p.oa_source_id,
21 21 
		'issn',
22 22 
		p.issn
23 
	FROM dsm_datasources d, pangaea_temp_journals p
23 
	FROM dsm_services d, pangaea_temp_journals p
24 24 
	WHERE
25 25 
		d.collectedfrom = 'driver______::1790119e-d281-4b7a-aedf-866d1d853a07' AND d.issn IS NOT NULL AND d.id LIKE 'doajarticles::%' AND p.issn = d.issn
26 26 
		AND

Also available in: Unified diff