title: MySQL Query to retrieve all values of a grouped column that's been filtered
body: <p>Say I have the following defined tables:</p>
  
  <pre><code>Table `content`:
  ===============
  id unsigned int(11)
  title varchar(500)
  
  Table `satellite`:
  ===============
  id unsigned int(11)
  label varchar(250)
  
  Table `content_satellite`:
  ===============
  content_id unsigned int(11)
  satellite_id unsigned int(11)
  </code></pre>
  
  <p>If I wanted to get a list of content rows that contain a GROUP_CONCAT()'ted list of associated satellites, FILTERED on a particular satellite type, what would the query be?</p>
  
  <p>Using the following query:</p>
  
  <pre><code>SELECT 
  c.title,
  GROUP_CONCAT(s.id) as satellite_ids
  FROM content c
  LEFT JOIN content_satellite cs ON cs.content_id = c.id
  LEFT JOIN satellite s ON cs.satellite_id = s.id
  WHERE satellite = 2
  GROUP BY c.id;
  </code></pre>
  
  <p>The resulting rows would have satellite_ids containing ONLY a single value "2" whether or not a particular content row is associated to multiple satellite types...</p>
  
  <p>How can I query these tables to retrieve a column that contains ALL satellite ids associated with each content rows that come back while filtering on a particular satellite type?</p>
  
  <p>EDIT - MySQL 5.5 is the Database type (didn't realize that mattered for a common basic SQL query such as this)</p>
  
  <p>EDIT2 - Left the GROUP by off my sql query</p>