Skip to content
Update Database conversion authored by Émilie Pagé-Perron's avatar Émilie Pagé-Perron
......@@ -106,7 +106,7 @@ SET cdli_db.update_events.created_by =
SELECT cdli_db.authors.id FROM cdli_db.authors
join cdli_db_tmp.authors_view on cdli_db_tmp.authors_view.author_id = cdli_db.authors.id
join cdli_db.update_events on cdli_db_tmp.authors_view.mod_date = cdli_db.update_events.created
WHERE cdli_db_tmp.authors_view.mod_date = cdli_db.update_events.created AND cdli_db.update_events.type = "atf"
WHERE cdli_db_tmp.authors_view.mod_date = cdli_db.update_events.created AND cdli_db.update_events.update_type = "atf"
LIMIT 1
);
```
......
......