Why mysql return error on group concat at subqueries?

Question

i have mysql error Subquery returns more than 1 row on this query with GROUP_CONCAT. Why I gat this error and how i can solve this problem?

 select SQL_CALC_FOUND_ROWS s.url, 
        GROUP_CONCAT(
        (select name 
             from labels_data ld, 
                  labels l 
             where ld.id=l.site_id=s.id 
         limit 2),
        ', '),
 ... more valid sql code ...
 as labels from sites s

Gordon Linoff · Accepted Answer · 2013-02-22 14:17:03Z

3

You need to put the group_concat into the subquery. The subquery is returning more than one row (at least normally). It has a limit 2.

  (select group_concat(name , ', ')
    from labels_data ld join
         labels l 
         on ld.id=l.site_id=s.id 
    limit 2
  )

I also recommend that you use proper ANSI join syntax.

answered Feb 22, 2013 at 14:17

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

sgeddes Over a year ago

+1 -- but is that JOIN syntax correct? ld.id=l.site_id=s.id? Here's a sample Fiddle moving it to the WHERE clause: sqlfiddle.com/#!2/8dd09/1

Collectives™ on Stack Overflow

Why mysql return error on group concat at subqueries?

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related