Remove date published from journals in E+M
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.
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.