Re: only_full_group_by Query Rewrite Assist

[Peter Brawley]

Is this what you mean?

select userid, max(created) as created
from (
  (select uid as userid, max(created) as created from message 
   where uid<>1234 group by userid order by created desc limit 5
  )
  union 
  (select puid as userid, max(created) as created from message 
   where puid<>1234 group by userid order by created desc limit 5
  )
) recent
group by userid
order by created desc limit 5;
[/code[