Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement