joomla/joomla-cms — pull request #1627 by AmyStephen (2013-08-01 03:59:53+00:00)
Title: Move contact lookup outside of the Article and Articles Query

Fix the Contact Join problem for 2.5 (which is feature frozen) by removing the contact portion of the Article and Articles Query, and then adding the Contact ID lookup in the item resultset loop.

The 2.5.x change is very isolated, only impacts the model, and does not introduce a new feature for the plugin that is in 3.x or any layout changes.

This change fixes:
- The current SQL Server failure.
- Any duplicated content due to multiple contacts assigned to authors.
- Any dropped content due to no contact assigned to the author.

There are no BC issues.