title: mysql Select one column twice from the same table with different dates in the where clause
body: <p>I have two sql queries which i want to combine in one SQL Query and display on one table:</p>
  
  <pre><code>SELECT subname,subscribers as sub1 FROM reports_subreport where  country ='1' and mp='0' and date ='2013-10-15' and NOT(subname LIKE '%Test%')  order by site,subname
  
  
  SELECT subscribers as sub2 FROM reports_subreport where country ='1' and mp='0' and date ='2013-10-08' and NOT(subname LIKE '%Test%')  order by site,subname
  </code></pre>
  
  <p>Should Display something Like This in a table:</p>
  
  <p><strong>subname</strong>  <strong>sub1</strong>    <strong>sub2</strong></p>
  
  <p>ENT            222          202</p>
  
  <p>Could you please help me out here because iam new to mysql and php?</p>