The database was generated from a fresh 1.3.7 ZC and the cart was updated to 1.3.7.1, thats it.

I repaired both tables and ran the query again and same thing, hanging..