title: Why is SQL GROUP_CONCAT Query not working?
body: <p>I have this query, but it gives me duplicate values in row</p>
  <pre><code>select products.name, products.image, products.image_second, 
  products.description, products.min_order, size_categories.size_id, 
  products.id, 
  GROUP_CONCAT( product_prices.price order by FIND_IN_SET(sizes.id, size_categories.size_id)) as price,
  GROUP_CONCAT( sizes.name order by FIND_IN_SET(sizes.id, size_categories.size_id) ) as sizes_name, 
  units.name as units_name 
  from `products` 
  inner join `subcategories` on `products`.`subcategories_id` = `subcategories`.`id` 
  inner join `size_categories` on `subcategories`.`categories_id` = `size_categories`.`categories_id` 
  inner join `sizes` on FIND_IN_SET(sizes.id, size_categories.size_id) &gt; '0' 
  inner join `units` on `units`.`id` = `products`.`units_id` 
  inner join product_prices on product_prices.products_id = products.id 
  where `products`.`id` = '1' 
  group by `products`.`name`, `products`.`image`, 
  `products`.`image_second`, 
  `products`.`description`, `products`.`min_order`, 
  `size_categories`.`size_id`, `products`.`id`
  </code></pre>
  <p>The result is like this</p>
  <pre><code>------ size_id | id | price          | sizes_name
  ------  1,2       1   43,32,43,32       2m,2m,3m,3m 
  
  </code></pre>
  <p>32 is the price of 2m, and 43 is the price of 3m.
  I need it in a single row and also i need to maintain the order (it should be like 32,43 and not like 43,32)
  like</p>
  <pre><code>------ size_id | id | price | sizes_name
  ------  1,2       1   32,43     2m,3m
  </code></pre>
  <p>Please Help</p>