joomla/joomla-cms — pull request #1542 by Bakual (2013-07-14 13:08:31+00:00)
Title: Fixing articles and article model query. It was failing if there are mul...

Fixing articles and article model query. It was failing if there are multiple contacts of different languages assigned to the same user, resulting in duplicated content shown.

There is also a huge performance loss if there are many articles due to the GROUP BY statement. According to the discussion on Google Groups:
https://groups.google.com/forum/?fromgroups=#!topic/joomla-dev-general/sVFw9reqGGw