title: order results based on join conditions order
body: <p>There are 3 mysql tables.</p>
  
  <pre><code>BOOKS have ID, AUTHOR1, AUTHOR2, PUBLISHER1, PUBLISHER2
  AUTHORS have ID, WEBSITE
  PUBLISHERS have ID, WEBSITE
  </code></pre>
  
  <p>Not all publishers or authors have a website.</p>
  
  <p>I have a query that returns matching sets of author and publisher websites for a given book ID. If they all have a website, this would mean 2 rows.</p>
  
  <pre><code>SELECT AUTHORS.WEBSITE as WEB1, PUBLISHERS.WEBSITE as WEB2
  FROM BOOKS
  LEFT OUTER JOIN AUTHORS ON (ID=AUTHOR1 OR ID=AUTHOR2)
  LEFT OUTER JOIN PUBLISHERS ON (ID=PUBLISHER1 OR ID=PUBLISHER2)
  WHERE BOOK.ID ='12345'
  LIMIT 2
  </code></pre>
  
  <p>While this works, it ends up returning the row matching the second author and publisher before the first author and publisher. Possibly based on alphabetical order.</p>
  
  <p>How can I make this query return the row containinting the websites of AUTHOR1 and PUBLISHER1 first?</p>