title: MySQL - Filter records which date is biggest
body: <p>I have this mysql select query:</p>
  
  <pre><code>SELECT s.* 
  FROM campaign_statistic AS s INNER JOIN campaign AS c ON s.campaign_id = c.campaign_id 
  WHERE c.campaign_id = 51 
  AND date(s.created_date) BETWEEN date(c.start_date) AND date(c.end_date)
  </code></pre>
  
  <p>and getting this result:</p>
  
  <pre><code>id  campaign_id     instagram_id    media_id                        has_tag     comments_count  likes_count     created_date            status
  **  ***********     ************    ****************************    ********    *************   ***********     *******************     ******
  1   51              1230544324      957801995790641919_1230544324   together    1               16              2015-11-01 13:10:29     1
  2   51              1230544324      957799073015065299_1230544324   together    2               11              2015-11-01 13:10:29     1
  3   51              1230544324      957790310736521811_1230544324   together    5               20              2015-11-01 13:10:29     1
  4   51              1230544324      957801995790641919_1230544324   together    1               16              2015-11-02 13:10:29     1
  5   51              1230544324      957799073015065299_1230544324   together    2               11              2015-11-02 13:10:29     1
  6   51              1230544324      957790310736521811_1230544324   together    5               20              2015-11-02 13:10:29     1
  7   51              1230544324      957801995790641919_1230544324   together    1               16              2015-11-03 13:10:29     1
  8   51              1230544324      957799073015065299_1230544324   together    2               11              2015-11-03 13:10:29     1
  9   51              1230544324      957790310736521811_1230544324   together    5               20              2015-11-03 13:10:29     1
  </code></pre>
  
  <p>but I am trying to get only those records which <code>created_date</code> is biggest from above result and biggest <code>created_date</code> is <code>2015-11-03</code>. </p>
  
  <p>I need this result:</p>
  
  <pre><code>id  campaign_id     instagram_id    media_id                        has_tag     comments_count  likes_count     created_date            status
  **  ***********     ************    ****************************    ********    *************   ***********     *******************     ******
  7   51              1230544324      957801995790641919_1230544324   together    1               16              2015-11-03 13:10:29     1
  8   51              1230544324      957799073015065299_1230544324   together    2               11              2015-11-03 13:10:29     1
  9   51              1230544324      957790310736521811_1230544324   together    5               20              2015-11-03 13:10:29     1
  </code></pre>
  
  <p>Any idea or suggestion?</p>
  
  <p>Thanks.</p>