Re: How to Limit Joined Table's Rows?

[Peter Brawley]

The manual page for Group_Concat() doesn't show Limit as a Group_Concat() option. We can't just make up syntax. What you can do is limit a result with Order By ... Limit ..., then process that result with Group_Concat(), eg given tables a(id) and b(id,t) ...

select a.id, group_concat(x.t)
from a
join (
  select id, t
  from b 
  order by t desc limit 10
) x using(id)
group by a.id;