The problem is that that a join was added to the query to the contact table. You might very well be write about other issues in the database packages - but those problems are only manifesting because this incorrect join is attempted. 

Right solution is to get the contact table out of the join. That fixes all of the dozens and dozens of problems that have happened over the past three years.

https://github.com/joomla/joomla-cms/pull/1623