SELECT
   content.id AS content_id,
   content.added AS content_added,
   content.updated AS content_updated,
   content.effective AS content_effective,
   content.expiration AS content_expiration,
   content.exclude_nav AS content_exclude_nav,
   content.weight AS content_weight,
   content.is_fts AS content_is_fts,
   content.props AS content_props,
   content.content_type_id AS content_content_type_id,
   content.owner_id AS content_owner_id,
   content.state_id AS content_state_id,
   content.container_id AS content_container_id,
   content.inherits_parent_acl AS content_inherits_parent_acl,
   account_1.id AS account_1_id,
   account_1.login AS account_1_login,
   account_1.password AS account_1_password,
   account_1.first_name AS account_1_first_name,
   account_1.last_name AS account_1_last_name,
   account_1.email AS account_1_email,
   account_1.created AS account_1_created,
   account_1.enabled AS account_1_enabled,
   account_1.lost_token AS account_1_lost_token,
   state_1.id AS state_1_id,
   state_1.name AS state_1_name,
   state_1.description AS state_1_description,
   content_type_1.id AS content_type_1_id,
   content_type_1.name AS content_type_1_name,
   content_type_1.icons AS content_type_1_icons,
   content_type_1.description AS content_type_1_description,
   language_1.id AS language_1_id,
   language_1.name AS language_1_name,
   anon_1.amnesia_multilingual_content_translation_language_id AS anon_1_amnesia_multilingual_content_translation_language__1,
   anon_1.amnesia_multilingual_content_translation_content_id AS anon_1_amnesia_multilingual_content_translation_content_i_2,
   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_3,
   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
FROM
   content
   JOIN
      account AS account_1
      ON account_1.id = content.owner_id
   JOIN
      state AS state_1
      ON state_1.id = content.state_id
   JOIN
      content_type AS content_type_1
      ON content_type_1.id = content.content_type_id
   JOIN
      (
         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,
            ROW_NUMBER() OVER (PARTITION BY amnesia_multilingual.content_translation.content_id
         ORDER BY
            amnesia_multilingual.content_translation.language_id = % (param_1)s DESC, amnesia_multilingual.content_translation.language_id = % (param_2)s DESC) AS INDEX
         FROM
            amnesia_multilingual.content_translation
         WHERE
            amnesia_multilingual.content_translation.language_id IN
            (
                % (param_1)s,
               % (param_2)s
            )
      )
      AS anon_1
      ON anon_1.amnesia_multilingual_content_translation_content_id = content.id
      AND anon_1.INDEX = % (index_1)s
   JOIN
      language AS language_1
      ON language_1.id = anon_1.amnesia_multilingual_content_translation_language_id
WHERE
   content.id = % (param_3)s