title: Mix SQL Rows into one
body: <p>I am using the following SQL Query:</p>
  
  <pre><code>SELECT package_stats.developer 
        ,xf_user.username 
        ,xf_user.email 
        ,xf_user_profile.homepage 
        ,xf_user_profile.location 
        ,xf_user_profile.about 
        ,CASE WHEN field_id ='Github' THEN field_value ELSE '' END AS Github
        ,CASE WHEN field_id ='Repository' THEN field_value ELSE ''  END AS Repository
        ,CASE WHEN field_id ='twitter' THEN field_value ELSE '' END AS Twitter
  
  FROM package_stats, xf_user, xf_user_field_value, xf_user_profile 
  WHERE xf_user.username = package_stats.developer AND  xf_user_profile.user_id = xf_user.user_id AND xf_user_field_value.user_id = xf_user.user_id AND xf_user_field_value.field_value &lt;&gt; '' 
  </code></pre>
  
  <p>Which outputs the following:</p>
  
  <pre><code>developer   username    email      about     Github              Repository           Twitter 
  John Doe      jdoe    j@doe.com   It's me   https://github....       
  John Doe      jdoe    j@doe.com   It's me      
  John Doe      jdoe    j@doe.com   It's me                       https://link....   
  John Doe      jdoe    j@doe.com   It's me                                            https://twitter.com/...
  </code></pre>
  
  <p>How can I mix all those rows into a single row?</p>