finalizing south migratino and 'recently run' queries