title: show result from left join in one field
body: <p>I have this problem with getting all the retrieved values from a left join into one field. When I use the group_concat it concatenates all the values into just one record.</p>
  
  <p>What I need is to retrieve all the image file names from the product based on the left join and then concatenate them in to one field in the record.</p>
  
  <pre><code>select  
      pd.products_id, 
      pd.products_name, 
      pd.products_description, 
      pd.products_more,
      pd.seo_title,
      pd.seo_description,
  
      pa.price,
      pa.price_excl,
      pa.price_action,
  
      pov.products_options_values_name as size, 
  
      cdc.categories_name as category_name1,  
      cdp.categories_name as category_name2,
      group_concat(images.filename) as files
  
  from products_description as pd
  
  left join(products as p) ON(p.products_id = pd.products_id) 
  left join(categories as c) ON(p.parent_id = c.categories_id)
  left join(categories_description as cdp) ON(p.parent_id = cdp.categories_id)
  left join(categories_description as cdc) ON(c.parent_id = cdc.categories_id)
  left join(products_attributes AS pa) ON(pd.products_id = pa.products_id)
  left join(products_options_values AS pov) ON(pov.products_options_values_id = pa.options_values_id)
  left join(images) ON(p.products_id = images.item_id);
  </code></pre>
  
  <p>With out the group_contact it returns for example 2000 products it returns for instance 3 records that are the same product only different shoe size. The same images need to be added to the same product concatenated.</p>
  
  <p>A few columns of a few records to understand better what I need to retrieve.</p>
  
  <pre><code>products_id | products_name | size | files
  
  1             shoe1           35     image1.jpg,image2.jpg,image3.jpg
  1             shoe1           36.5   image1.jpg,image2.jpg,image3.jpg
  1             shoe1           37     image1.jpg,image2.jpg,image3.jpg
  </code></pre>