gistfile1.txt

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.inherits_parent_acl AS content_inherits_parent_acl, 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, document.content_id AS document_content_id, 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, 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 
FROM amnesia_multilingual.content_translation, content JOIN document ON content.id = document.content_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, 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_3 ON anon_3.amnesia_multilingual_document_translation_content_id = content.id AND anon_3.index = %(index_1)s 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, 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 ON anon_1.amnesia_multilingual_document_translation_content_id = content.id AND anon_1.index = %(index_2)s 
WHERE amnesia_multilingual.content_translation.title LIKE %(title_1)s ORDER BY amnesia_multilingual.content_translation.title