title: LIMIT ignored in query with GROUP_CONCAT
body: <p>I need to select some rows from second table and concatenate them in comma-separated string. Query works well except one problem - It always selects all rows and ignores LIMIT.</p>
  
  <p>This is part of my query which gets that string and ignores LIMIT:</p>
  
  <pre><code>select 
      group_concat(value order by `order` asc SEPARATOR ', ') 
  from slud_data 
      left join slud_types on slud_types.type_id=slud_data.type_id 
  where slud_data.product_id=18 and value!='' and display=0 limit 3;
  
  
  // Result:
  +---------------------------------------------------------+
  | group_concat(value order by `order` asc SEPARATOR ', ') |
  +---------------------------------------------------------+
  | GA-XXXX, Bentley, CONTINENTAL FLYING SPUR, 2006         |
  +---------------------------------------------------------+
  
  // Expected result: (only 3 comma-separated records, not 4)
  </code></pre>
  
  <p>Full query:</p>
  
  <pre><code>SELECT *,product_id id,
      (select group_concat(value order by `order` asc SEPARATOR ', ') from slud_data left join slud_types on slud_types.type_id=slud_data.type_id where slud_data.product_id=t1.product_id and value!='' and display=0 limit 3) text
  FROM slud_products t1 
  WHERE 
      now() &lt; DATE_ADD(date,INTERVAL +ttl DAY) and activated=1
  ORDER BY t1.date desc
  </code></pre>