title: MySQL optimize subqueries
body: <p>I want to optimize this query (since subqueries aren't fast in general), but I'm lost because I cannot rewrite this using joins which will be better for performance, can you help mi with this?</p>
  
  <pre><code>SELECT id, company, street, number, number_addition, postalcode, telephone
  FROM clients
      WHERE (postalcode BETWEEN '1000' AND '9000') AND street = (
          SELECT DISTINCT street FROM clients WHERE (postalcode BETWEEN '1000' AND '9000') AND postalcode &lt;= (
              SELECT MIN(postalcode) FROM clients WHERE street = 'Main Street' AND     (postalcode BETWEEN '1000' AND '9000'))
          ORDER BY postalcode DESC LIMIT 1, 1)
  ORDER BY postalcode DESC, street DESC, number DESC, number_addition DESC, telephone DESC
  LIMIT 1
  </code></pre>
  
  <p>Thanks for your time guys.</p>