Database-conversion.md

@@ -101,13 +101,14 @@ Select distinct cdli_db_old.revhistories.mod_date, cdli_db_old.revhistories.auth
 
 ```sql
 UPDATE cdli_db.update_events
+join cdli_db_tmp.authors_view on 
+     cdli_db_tmp.authors_view.mod_date = cdli_db.update_events.created
+
 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.update_type = "atf"
-LIMIT 1
+SELECT author_id FROM cdli_db_tmp.authors_view
+WHERE cdli_db_tmp.authors_view.mod_date = cdli_db.update_events.created 
+AND cdli_db.update_events.update_type = "atf" LIMIT 1
 );
 ```