title: MySQL group chunks by column value, sorted by other column
body: <p>I have a table like:</p>
  
  <pre>
  time       | status
  1390836600 | 1
  1390836605 | 1
  1390836610 | 0
  1390836615 | 0
  1390836620 | 1
  1390836625 | 1
  1390836630 | 1
  </pre>
  
  <p>I need to output the data "grouped" by the status, and sorted by time. The trick is that I need the groupings in chunks for each time the status changes, with the fields: <code>MIN(time), status</code></p>
  
  <p>So for the example data above I'd need an output like</p>
  
  <pre>
  MIN(time)  | status
  1390836600 | 1
  1390836610 | 0
  1390836620 | 1
  </pre>
  
  <p>This is not the behaviour of <code>GROUP BY</code>, which would just group ALL rows with the same status and only output 2 rows. But is something like this possible?</p>