I'm afraid I can't think of a way of doing this in a single query - you can certainly group by brand_id, but that'll mean one result per group - there's no way to change that to five results per group.
-- Pat On 16/08/2011, at 12:37 AM, Linus Oleander wrote: > Is it possible to limit on a group using TS? > > Example: > > Car has an band, :brand_id. > > I want to select 50 cars, grouping then together so that 10 different > brands are selected. > > 5 x Volvo > 5 x BMW > .... > > Is that possible? > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
