SELECT
   anon_1.amnesia_multilingual_document_translation_language_id AS anon_1_amnesia_multilingual_document_translation_language_1,
   anon_1.amnesia_multilingual_content_translation_language_id AS anon_1_amnesia_multilingual_content_translation_language__2,
   anon_1.amnesia_multilingual_document_translation_content_id AS anon_1_amnesia_multilingual_document_translation_content__3,
   anon_1.amnesia_multilingual_content_translation_content_id AS anon_1_amnesia_multilingual_content_translation_content_i_4,
   anon_1.amnesia_multilingual_content_translation_title AS anon_1_amnesia_multilingual_content_translation_title,
   anon_1.amnesia_multilingual_content_translation_description AS anon_1_amnesia_multilingual_content_translation_descripti_5,
   anon_1.amnesia_multilingual_content_translation_fts AS anon_1_amnesia_multilingual_content_translation_fts,
   (
      SELECT
         content.content_type_id
      FROM
         content
      WHERE
         anon_1.amnesia_multilingual_content_translation_content_id = content.id
   )
   AS anon_2,
   anon_1.amnesia_multilingual_document_translation_body AS anon_1_amnesia_multilingual_document_translation_body,
   language_1.id AS language_1_id,
   language_1.name AS language_1_name
FROM
   (
      SELECT
         amnesia_multilingual.content_translation.language_id AS amnesia_multilingual_content_translation_language_id,
         amnesia_multilingual.content_translation.content_id AS amnesia_multilingual_content_translation_content_id,
         amnesia_multilingual.content_translation.title AS amnesia_multilingual_content_translation_title,
         amnesia_multilingual.content_translation.description AS amnesia_multilingual_content_translation_description,
         amnesia_multilingual.content_translation.fts AS amnesia_multilingual_content_translation_fts,
         amnesia_multilingual.document_translation.language_id AS amnesia_multilingual_document_translation_language_id,
         amnesia_multilingual.document_translation.content_id AS amnesia_multilingual_document_translation_content_id,
         amnesia_multilingual.document_translation.body AS amnesia_multilingual_document_translation_body,
         row_number() OVER (PARTITION BY amnesia_multilingual.document_translation.content_id
      ORDER BY
         amnesia_multilingual.document_translation.language_id = % (param_1)s DESC, amnesia_multilingual.document_translation.language_id = % (param_2)s DESC) AS index
      FROM
         amnesia_multilingual.content_translation
         JOIN
            amnesia_multilingual.document_translation
            ON amnesia_multilingual.content_translation.language_id = amnesia_multilingual.document_translation.language_id
            AND amnesia_multilingual.content_translation.content_id = amnesia_multilingual.document_translation.content_id
      WHERE
         amnesia_multilingual.document_translation.language_id IN
         (
             % (param_1)s,
            % (param_2)s
         )
   )
   AS anon_1
   JOIN
      language AS language_1
      ON language_1.id = anon_1.amnesia_multilingual_content_translation_language_id
WHERE
   anon_1.amnesia_multilingual_document_translation_content_id = % (param_3)s
   AND anon_1.index = % (index_1)s