title: Query to get the current values
body: <p>I've got the following tables</p>
  
  <pre><code>menu_supp
  menu_id    supp_id    supp_weight    supp_load_follow
  1          29         10.00          1
  1          31         20.00          2
  
  supps
  supp_id    user_id    supp_name
  29         1          Test supp 1
  31         1          Test supp 2
  
  supps_prop
  supp_id    supp_dry_w    supp_price    supp_date
  29         95.00         125.00        2015-10-25
  29         94.00         124.00        2015-11-06
  29         94.00         128.00        2015-11-12
  31         25.00         200.00        2015-06-25
  </code></pre>
  
  <p>Now I've got this query:</p>
  
  <pre><code>SELECT s.supp_id, s.supp_name, ms.supp_weight, sp.supp_price, sp.supp_dry_weight
  FROM menu_supp ms
  LEFT JOIN supps s ON ms.supp_id = s.supp_id
  LEFT JOIN supps_prop sp ON ms.supp_id = sp.supp_id
  WHERE menu_id = 1
  GROUP BY s.supp_id
  ORDER BY ms.supp_load_follow ASC
  </code></pre>
  
  <p>Which gives me this result:</p>
  
  <pre><code>supp_id     supp_name   supp_weight     supp_price  supp_dry_weight
  29          Test supp 1 10.00           125.00      95.00
  31          Test supp 2 20.00           200.00      25.00
  </code></pre>
  
  <p>From supp 29 it gets the oldest value. Where it should take the value based on the current date. How can I achieve that?</p>