EDIT

bug #7828

Updated by Andreas Müller over 5 years ago

>1200 journals from the initial import in 2004 do have a date published. Journals generally should not have a date published. 

 This is critical for the deduplication as the date published is handled as difference. Also in general it should be cleaned. 

 ~~~ sql 

 SELECT    ref.* 
 FROM Reference ref  
 WHERE ref.datePublished_start IS NOT NULL AND ref.refType = 'JOU' ; 

 SELECT DISTINCT subref.title, subRef.id, subRef.*, ref.* 
 FROM Reference ref INNER JOIN Reference subRef ON subRef.inReference_id = ref.id 
 WHERE ref.datePublished_start IS NOT NULL AND ref.refType = 'JOU' AND subRef.datePublished_start IS NULL 
 ~~~ 

 Also journals should not have authors.

Back