title: Concat grouped records
body: <p>I have two related Tables, "projects" and "projects_formats" by projectID.</p>
  
  <p>I need a Query that could supply me with projects and for each row I want to concat the set of Formats desired for such project.</p>
  
  <p>Now, my query is:</p>
  
  <pre><code>SELECT SQL_CALC_FOUND_ROWS
         f.*,
         CONCAT(f.formatID, ', ') as formats
  FROM projects as p INNER JOIN project_formats as f ON f.projectID=p.ID 
  WHERE p.ended=0
  GROUP BY f.projectID
  </code></pre>
  
  <p>Is this possible?</p>