StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I'll try to write your query without subselects(subjoins): The indented join are at the same level of dbms p.o.v, but for us are dependent on previous tables.</p> <pre><code>select ing.* , tx_name.text , tx_description.text , tx_reference.text , tx_um.text from Article ing left join Translation t_name on ing.fk_name = t_name.id left join TranslationText tx_name on (t_name.id = tx_name.fk_translation and tx_name.fk_language = 28) left join Translation t_description on ing.fk_description = t_description.id left join TranslationText tx_description on (t_description.id = tx_description.fk_translation and tx_description.fk_language = 28) left join Translation translation_reference on ing.fk_reference = translation_reference.id left join TranslationText tx_reference on (translation_reference.id = tx_reference.fk_translation and tx_reference.fk_language = 28) left join Translation translation_um on ing.fk_um = translation_um.id left join TranslationText tx_um on (translation_um.id = tx_um.fk_translation and tx_um.fk_language = 28); </code></pre> <p>Also, I think your model is overnormalized. For me, this is better:</p> <pre><code>Article: (id, another_columns) TranslationText: (fk_article_id, fk_language,name_text, description_text, reference_text, um_text) Language (id, name) </code></pre> <p>As I see now, this is the model indicate in the most voted answer for the question indicated in your <a href="https://stackoverflow.com/questions/316780/schema-for-a-multilanguage-database">link</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload