title: select query from mysql with order field
body: <p>i have mysql query like below</p>
  
  <pre><code>SELECT
  p.prop_name,
  p.prop_id,
  p.star,
  c. NAME,
  pr.prov_name,
  c.countryid,
  c. NAME,
  pr.provinceid,
  r.room_typeid,
  r.roomtype_name,
  rr.is_promo,
  r.price,
  rr.final_price FROM
  v_property p 
  INNER JOIN set_country c ON(p.countryid = c.countryid)
  INNER JOIN set_province pr ON(p.provinceid = pr.provinceid)
  INNER JOIN room_type r ON(p.prop_id = r.prop_id)
  INNER JOIN room_rate_promo rr ON(r.room_typeid = rr.room_typeid)
  WHERE
    rr.date = '2015-11-09'
  AND p.is_active = 1
  AND rr.rating_status = 'ON'
  AND p. STATUS = 1
  AND p.provinceid = '5'
  ORDER BY
    rr.final_price ASC
  </code></pre>
  
  <h2>and result show like bellow</h2>
  
  <p><a href="https://i.stack.imgur.com/fsyyt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fsyyt.png" alt="enter image description here"></a></p>
  
  <p>and i want <code>prop_name</code> show only one row of each <code>prop_name</code> and get by minimum <code>final_price</code> column and order by <code>is_promo</code> to up</p>