nathanpitman/group_by.ext.ee_addon

An ExpressionEngine 2.x extension to add 'group by' support to the channel:entries tag pair.

'Group By' for ExpressionEngine

This simple ExpressionEngine extension adds SQL style 'group by' (aggregate) support to the {channel:entries} tag pair. Pass a 'groupby' parameter in your channel entries loops (currently only supports standard entry fields and custom fields by id; 'field_id_1')

{exp:channel:entries channel="advertising" groupby="field_id_1"}
{title}
{/exp:channel:entries}

In the example above this is being used to output banner ads which are related (with field_id_1) to a sponsor and ensure that only 1 ad from each sponsor is shown.