sqlite - Refactor SQL (workaround RIGHT OUTER JOIN) -

Since SQLite does not support right outs johns, I face the following challenge (read: My work for me Invitation to do):

Refactor this query so that it does not use cculity-unsupported structures such as Wright / Full Outdoor Johns.

  SELECT string. *, Translation. Translate from Translate to INNER .language_id = language.id Add strings to the translation. String_id = string.Indhere (language.handle = 'english')  

I think it can be obtained with sub-properties or axis in tables and in a left OUTER My attempts to join failed;

It is certain that it does not use SQL

Here is a query builder's framework showing the applicable schema:

Firstly it becomes decked with an e-gear

< P>

The following tests have not been done. Select

  strings. *, Translation. External translation from the text string to the left and the translation into the translation at .string_id = strings.id. Language_id = (Choose ID from language where language.handle = 'english')  

I think it matches the translation text to all the strings where a suitable translation is present in English. Trying to get?