bug #7828
Updated by Andreas Müller almost 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.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.