How to show recent entries restricted to one per author?

Question

I would like to show a list of recent entries, restricting the list to one per author. Essentially the logic I'm looking for is "show 10 recent articles, but if the author of the next article already has an article on the list, skip it."

I'm thinking I'll have to use PHP to add a second level of logic, but I'm hoping someone else has an idea.

A possible kink: I'm using Solspace's User.

Answer 1

You might could do something like this (php must be enabled on input)

<?php
$entries = array();
$sql = "SELECT author_id as author, 
        max(entry_id) as entry_id 
        FROM exp_channel_titles
        WHERE channel_id = '4'
            AND status = 'open'
        GROUP BY author 
        ORDER BY entry_id DESC 
        LIMIT 10";
$authorEntriesQuery = ee()->db->query($sql);
foreach($authorEntriesQuery->result_array() as $row)
{
    $entries[] = $row['entry_id'];
}
$entriesString = implode('|',$entries);
?>
{exp:channel:entries channel="blog" entry_id="<?echo $entriesString?>"}
{title}<br>
{/exp:channel:entries}

You would have to change the channel number obviously and if you have any custom statuses you need to account for, then change that section.

I tested this and got the most recent posts from individual authors.