Change remove_order_items subqueries to inner joins.

Closes #6804
Hat tip Jason @ WPEngine