title: Refactor SQL (workaround RIGHT OUTER JOIN)
body: <p>Since SQLite does not support RIGHT OUTER JOINS I pose the following challenge (read: invitation to do my work for me):</p>
  
  <p>Refactor this query so it no longer utilises SQLite-unsupported constructs like RIGHT/FULL OUTER JOINs.</p>
  
  <pre><code>SELECT     strings.*, translations.text
  FROM         translations INNER JOIN
                        language ON translations.language_id = language.id RIGHT OUTER JOIN
                        strings ON translations.string_id = strings.id
  WHERE     (language.handle = 'english')
  </code></pre>
  
  <p>I sense it can be achieved with subqueries or by pivoting the tables and performing a LEFT OUTER JOIN but my attempts have failed; my SQL's not what it used to be.</p>
  
  <p>Here's a query builder outline showing the applicable schema: <a href="http://dl.getdropbox.com/u/264612/sql-refactor.PNG" rel="nofollow noreferrer">http://dl.getdropbox.com/u/264612/sql-refactor.PNG</a></p>
  
  <p>First to crack it gets an e-hug from dekz</p>