title: Can't get multiple results with my query when adding a left join
body: <p>My query without a left join gathers 2 results as it should, when I add the left join I acquire only 1.</p>
  
  <p>Firstly here is my query:</p>
  
  <pre><code>SELECT cb_keys.*, GROUP_CONCAT(DISTINCT cb_AllowedIPs.IP4) AS IP4, GROUP_CONCAT(DISTINCT cb_ModulesInKey.ActionID) AS Actions
  FROM cb_keys
  LEFT JOIN cb_allowedips ON cb_Keys.KeyID = cb_allowedips.KeyID
  LEFT JOIN cb_modulesinkey ON cb_keys.KeyID = cb_modulesinkey.KeyID
  WHERE cb_Keys.UserID = 2
  GROUP BY cb_Keys.UserID
  </code></pre>
  
  <p>Now I will reflect on some of my tables:
  <strong>cb_keys</strong></p>
  
  <pre><code>KeyID |  UserID | Key
  --------------------------
  1     |    2    | 20fjewof
  2     |    2    | eiwfjow2
  </code></pre>
  
  <p><strong>cb_allowedips</strong></p>
  
  <pre><code>ipID |  KeyID | Address
  --------------------------
  1    |    1   | 127.0.0.1
  2    |    2   | 127.0.0.1
  </code></pre>
  
  <p><strong>cb_modulesinkey</strong></p>
  
  <pre><code>modkeyID |  KeyID | ActionID
  --------------------------
  1        |    1   | 1
  2        |    2   | 4
  </code></pre>
  
  <p>So I am working with 2 Key rows which both have an identifier of 2 (which satisfies the WHERE condition), each of the keys have 1 address and finally each of the keys have 1 action. I have several of the addresses and actions in my database which is why I GROUP_CONCAT to make things easier in PHP.</p>
  
  <p>If I was to remove the joins, and had just my SELECT, FROM and WHERE I will return 2 rows, my intention is to return 2 rows but to add on the little extras that I am trying to do. Now as it stands with my joins added I only return 1 row rather than 2 even though they both satisfy.</p>
  
  <p>What have I done wrong?</p>