Orders not being listed on the order page

Weird one - I had a 2.0.7 site in development with lots of test orders. They were all attached to 1 test user. There are also a few admin accounts. Before gong live last week I deleted the test user before the orders (should have done it the other way around?) and since then, orders, even for real customers don’t show up on the orders page. They do show up on the dashboard in the top left.

Any ideas? I went into the db and changed the user_id on any orders where user_id = 0 to user_id = 4, which is a current test user, but that didn’t change anything.