Project

General

Profile

« Previous | Next » 

Revision 48139

Added by Alessia Bardi almost 7 years ago

integrated (hopefully) all required changes from dnet40

View differences:

find_journal_intersection.sql
1 
select
2 
	h.entry as id,
3 
	h.datasourceid as datasource,
4 
	d.officialname as name,
5 
	p.value as issn
6
7 
 from hostedby_map h, datasources d, hostedby_props p  where
8 
 h.oa_source_id= 're3data_____::r3d100010134' AND
9 
 h.datasourceid = d.id and p._dnet_resource_identifier_ = h._dnet_resource_identifier_ and p.key='issn'
1 
SELECT
2 
	h.entry        AS id,
3 
	h.datasourceid AS datasource,
4 
	d.officialname AS name,
5 
	p.value        AS issn
6 

  		




  
  7
  
    
FROM hostedby_map h, datasources d, hostedby_props p


  		




  
  8
  
    
WHERE


  		




  
  9
  
    
	h.oa_source_id = 're3data_____::r3d100010134' AND


  		




  
  10
  
    
	h.datasourceid = d.id AND p._dnet_resource_identifier_ = h._dnet_resource_identifier_ AND p.key = 'issn'


  		












Also available in:  Unified diff