title: Query MySQL - One table view multiples records
body: <p>I have a table with this contents:</p>
  
  <p><strong>Table1</strong>: MySQL Table Content ( Table: 'sensors' )</p>
  
  <pre><code>        Date         |    Topic    |  Value
  -------------------------------------------
  2016/06/15 13:22:11  |  pressure   |  10.52
  2016/06/15 13:22:11  | temperature |  55.25
  2016/06/15 13:23:42  | temperature |  40.12
  2016/06/15 13:25:10  |  pressure   |   8.10
  2016/06/15 13:25:13  | temperature |  47.24
  2016/06/15 13:27:30  |  pressure   |  11.47
  2016/06/15 13:27:30  | temperature |  52.27
  </code></pre>
  
  <p>And I want to do a select to retrive this view:</p>
  
  <p><strong>Table2</strong>: Query result from table 'sensors'</p>
  
  <pre><code>        Date         |  pressure   |  temperature
  -------------------------------------------------
  2016/06/15 13:22:11  |    10.52    |    55.25
  2016/06/15 13:23:42  |             |    40.12
  2016/06/15 13:25:10  |     8.10    |
  2016/06/15 13:25:13  |             |    47.24
  2016/06/15 13:27:30  |    11.57    |    52.27
  </code></pre>
  
  <p>I want select DISTINCT Date from 'sensors' table and then fill with the value from topic (if not exist at that time the value will be empty)</p>
  
  <p>PS. Table 'sensors' have multiples topics, but I only need the 'pressure' and 'temperature' values to build a chart.</p>
  
  <p>Thanks</p>