|
Script start |
SELECT e0.id AS e0_id, e0.link AS e0_link, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.is_alias AS e0_is_alias, e0.alias_redirects AS e0_alias_redirects, e1.id AS e1_id, e1.link AS e1_link, e1.text AS e1_text, e1.text_md5 AS e1_text_md5, e1.is_alias AS e1_is_alias, e1.action AS e1_action, e1.alias_redirects AS e1_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1 WHERE e0.parent = 0 AND (e0.lang_mask & 15 > 0) AND e0.text_md5 = MD5( 'persone' ) AND e1.parent = e0.link AND (e1.lang_mask & 15 > 0) AND e1.text_md5 = MD5( 'malocharles' )
LIMIT 0, 1 |
Module start 'content' |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 5504 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT id, name, navigation_part_identifier, locale, identifier
FROM ezsection WHERE id='1' |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:267', 'eznode:5504' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 267, 5504 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=8646 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=8646 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 267 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT id, version, serialized_name_list, serialized_description_list, identifier, contentobject_name, url_alias_name, creator_id, modifier_id, created, remote_id, modified, is_container, always_available, language_mask, initial_language_id, sort_field, sort_order
FROM ezcontentclass WHERE id='1' AND version='0' ORDER BY version ASC
LIMIT 0, 2 |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id IN ( 1, 2, 267 ) and ezcontentclass.version = 0 AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
)
ORDER BY path_string |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:267' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 267 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '8646'
AND content_version = '1'
AND ( content_translation = 'fre-FR' OR language_id = '2' ) |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '8646'
AND content_version = '1'
AND ( content_translation = 'fre-FR' OR language_id = '2' ) |
eZTemplate: Loading template "node/view/full.tpl" with resource "design" |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:267', 'eznode:5504' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 267, 5504 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='1513' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 267 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:267' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 267 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '1513'
AND content_version = '7'
AND ( content_translation = 'ita-IT' OR language_id = '2' ) |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 267 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '1513'
AND content_version = '7'
AND ( content_translation = 'ita-IT' OR language_id = '2' ) |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 267 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '1513'
AND content_version = '7'
AND ( content_translation = 'ita-IT' OR language_id = '2' ) |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 267 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 267 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:267' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 267 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_version.contentobject_id = '8646' AND
ezcontentobject_version.version = '1' AND
ezcontentobject_attribute.contentobject_id = '8646' AND ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.language_code = 'fre-FR'
ORDER BY
ezcontentclass_attribute.placement ASC,
ezcontentobject_attribute.language_code ASC |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE id='374' AND version='0' |
eZTemplate: Loading template "content/datatype/view/ezxmltext.tpl" with resource "design" |
eZTemplate: Loading template "content/datatype/view/ezxmltags/paragraph.tpl" with resource "design" |
BEGIN WORK |
SELECT to_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE from_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT from_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE to_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT COUNT(DISTINCT main_node_id) as total FROM ezcontentobject as object, ezcontentobject_tree as tree WHERE tree.contentobject_id IN (10410,10411,10412) AND object.contentclass_id=58 AND object.id=tree.contentobject_id AND tree.contentobject_version=object.current_version AND tree.is_hidden=0 AND tree.is_invisible=0 AND tree.contentobject_is_published=1 |
COMMIT |
BEGIN WORK |
SELECT to_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE from_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT from_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE to_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT COUNT(DISTINCT main_node_id) as total FROM ezcontentobject as object, ezcontentobject_tree as tree WHERE tree.contentobject_id IN (10410,10411,10412) AND object.contentclass_id=60 AND object.id=tree.contentobject_id AND tree.contentobject_version=object.current_version AND tree.is_hidden=0 AND tree.is_invisible=0 AND tree.contentobject_is_published=1 |
COMMIT |
BEGIN WORK |
SELECT to_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE from_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT from_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE to_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT COUNT(DISTINCT main_node_id) as total FROM ezcontentobject as object, ezcontentobject_tree as tree WHERE tree.contentobject_id IN (10410,10411,10412) AND object.contentclass_id=55 AND object.id=tree.contentobject_id AND tree.contentobject_version=object.current_version AND tree.is_hidden=0 AND tree.is_invisible=0 AND tree.contentobject_is_published=1 |
COMMIT |
BEGIN WORK |
SELECT to_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE from_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT from_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE to_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT COUNT(DISTINCT main_node_id) as total FROM ezcontentobject as object, ezcontentobject_tree as tree WHERE tree.contentobject_id IN (10410,10411,10412) AND object.contentclass_id=77 AND object.id=tree.contentobject_id AND tree.contentobject_version=object.current_version AND tree.is_hidden=0 AND tree.is_invisible=0 AND tree.contentobject_is_published=1 |
COMMIT |
BEGIN WORK |
SELECT to_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE from_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT from_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE to_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT COUNT(DISTINCT main_node_id) as total FROM ezcontentobject as object, ezcontentobject_tree as tree WHERE tree.contentobject_id IN (10410,10411,10412) AND object.contentclass_id=62 AND object.id=tree.contentobject_id AND tree.contentobject_version=object.current_version AND tree.is_hidden=0 AND tree.is_invisible=0 AND tree.contentobject_is_published=1 |
COMMIT |
BEGIN WORK |
SELECT to_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE from_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT from_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE to_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT COUNT(DISTINCT main_node_id) as total FROM ezcontentobject as object, ezcontentobject_tree as tree WHERE tree.contentobject_id IN (10410,10411,10412) AND object.contentclass_id=54 AND object.id=tree.contentobject_id AND tree.contentobject_version=object.current_version AND tree.is_hidden=0 AND tree.is_invisible=0 AND tree.contentobject_is_published=1 |
COMMIT |
SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='323' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '323'
AND content_version = '4'
AND ( content_translation = 'ita-IT' OR language_id = '2' ) |
BEGIN WORK |
SELECT to_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE from_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT from_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE to_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT COUNT(DISTINCT main_node_id) as total FROM ezcontentobject as object, ezcontentobject_tree as tree WHERE tree.contentobject_id IN (10410,10411,10412) AND object.contentclass_id=59 AND object.id=tree.contentobject_id AND tree.contentobject_version=object.current_version AND tree.is_hidden=0 AND tree.is_invisible=0 AND tree.contentobject_is_published=1 |
COMMIT |
BEGIN WORK |
SELECT to_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE from_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT from_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE to_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT COUNT(DISTINCT main_node_id) as total FROM ezcontentobject as object, ezcontentobject_tree as tree WHERE tree.contentobject_id IN (10410,10411,10412) AND object.contentclass_id=70 AND object.id=tree.contentobject_id AND tree.contentobject_version=object.current_version AND tree.is_hidden=0 AND tree.is_invisible=0 AND tree.contentobject_is_published=1 |
COMMIT |
BEGIN WORK |
SELECT to_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE from_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT from_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE to_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT COUNT(DISTINCT main_node_id) as total FROM ezcontentobject as object, ezcontentobject_tree as tree WHERE tree.contentobject_id IN (10410,10411,10412) AND object.contentclass_id=53 AND object.id=tree.contentobject_id AND tree.contentobject_version=object.current_version AND tree.is_hidden=0 AND tree.is_invisible=0 AND tree.contentobject_is_published=1 |
COMMIT |
BEGIN WORK |
SELECT to_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE from_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT from_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE to_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT COUNT(DISTINCT main_node_id) as total FROM ezcontentobject as object, ezcontentobject_tree as tree WHERE tree.contentobject_id IN (10410,10411,10412) AND object.contentclass_id=78 AND object.id=tree.contentobject_id AND tree.contentobject_version=object.current_version AND tree.is_hidden=0 AND tree.is_invisible=0 AND tree.contentobject_is_published=1 |
COMMIT |
BEGIN WORK |
SELECT to_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE from_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT from_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE to_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT COUNT(DISTINCT main_node_id) as total FROM ezcontentobject as object, ezcontentobject_tree as tree WHERE tree.contentobject_id IN (10410,10411,10412) AND object.contentclass_id=56 AND object.id=tree.contentobject_id AND tree.contentobject_version=object.current_version AND tree.is_hidden=0 AND tree.is_invisible=0 AND tree.contentobject_is_published=1 |
COMMIT |
BEGIN WORK |
SELECT to_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE from_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT from_contentobject_id as id FROM ezcontentobject_link, ezcontentobject_tree WHERE to_contentobject_id=8646 AND ezcontentobject_tree.contentobject_id = ezcontentobject_link.from_contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_link.from_contentobject_version |
SELECT COUNT(DISTINCT main_node_id) as total FROM ezcontentobject as object, ezcontentobject_tree as tree WHERE tree.contentobject_id IN (10410,10411,10412) AND object.contentclass_id=80 AND object.id=tree.contentobject_id AND tree.contentobject_version=object.current_version AND tree.is_hidden=0 AND tree.is_invisible=0 AND tree.contentobject_is_published=1 |
COMMIT |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 267 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 267 and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3))) AND ezcontentobject_name.name LIKE 'M%' AND
ezcontentobject.language_mask & 15 > 0
ORDER BY ezcontentobject_name.name ASC
LIMIT 16, 1 |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
( ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '8645' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) )
ORDER BY
ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:267', 'eznode:5503' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 267, 5503 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 267 and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3))) AND ezcontentobject_name.name LIKE 'M%' AND
ezcontentobject.language_mask & 15 > 0
ORDER BY ezcontentobject_name.name ASC
LIMIT 18, 1 |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
( ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '8647' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) )
ORDER BY
ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:267', 'eznode:5505' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 267, 5505 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:267', 'eznode:5504' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 267, 5504 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=8646 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
Module end 'content' |
Missing translation for message in context: 'kernel/navigationpart' with comment: 'Navigation part'. The untranslated message is: 'eZFind' |
eZTemplate: Loading template "pagelayout.tpl" with resource "design" |
SELECT id, section_id, owner_id, contentclass_id, name, published, modified, current_version, status, remote_id, language_mask, initial_language_id
FROM ezcontentobject WHERE contentclass_id='15' ORDER BY id ASC
LIMIT 0, 1 |
SELECT * FROM ezurlalias_ml WHERE (cast(lang_mask & 2 AS SIGNED ) > 0) AND action = 'eznode:5504' AND is_original = 1 AND is_alias = 0 |
SELECT parent, lang_mask, text FROM ezurlalias_ml WHERE id=286 AND (ezurlalias_ml.lang_mask & 15 > 0) |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_version.contentobject_id = '54' AND
ezcontentobject_version.version = '5' AND
ezcontentobject_attribute.contentobject_id = '54' AND ezcontentobject_attribute.version = '5' AND ezcontentobject_attribute.language_code = 'ita-IT'
ORDER BY
ezcontentclass_attribute.placement ASC,
ezcontentobject_attribute.language_code ASC |
Could not find: javascript/menu.js |
Could not find: javascript/jquery.finaltilesgallery.js |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE id='174' AND version='0' |
SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='1134' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='1135' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '1134'
AND content_version = '4'
AND ( content_translation = 'ita-IT' OR language_id = '2' ) |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '1135'
AND content_version = '3'
AND ( content_translation = 'ita-IT' OR language_id = '2' ) |
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) INNER JOIN ezcontentobject_attribute a1 ON (a1.contentobject_id = ezcontentobject.id) WHERE ezcontentobject_tree.parent_node_id = 2 and
a1.contentobject_id = ezcontentobject.id AND
a1.contentclassattribute_id = 483 AND
a1.version = ezcontentobject_name.content_version AND
( a1.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a1.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a1.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a1.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a1.language_id ) ) & 8 ) )
<
( a1.language_id & 1 )
+ ( ( a1.language_id & 4 ) >> 1 )
+ ( ( a1.language_id & 2 ) << 1 )
+ ( ( a1.language_id & 8 ) )
)
AND ( a1.sort_key_string = '1' ) AND ezcontentobject.contentclass_id IN ( 1 ) AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 15 > 0
ORDER BY ezcontentobject_tree.priority DESC |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
( ( ezcontentobject_attribute.version = '6' AND
ezcontentobject_attribute.contentobject_id = '110' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) )
ORDER BY
ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_version.contentobject_id = '57' AND
ezcontentobject_version.version = '103' AND
ezcontentobject_attribute.contentobject_id = '57' AND ezcontentobject_attribute.version = '103' AND ezcontentobject_attribute.language_code = 'ita-IT'
ORDER BY
ezcontentclass_attribute.placement ASC,
ezcontentobject_attribute.language_code ASC |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:112' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 112 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 5504 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) INNER JOIN ezcontentobject_attribute a1 ON (a1.contentobject_id = ezcontentobject.id) WHERE ezcontentobject_tree.parent_node_id = 2 and
a1.contentobject_id = ezcontentobject.id AND
a1.contentclassattribute_id = 483 AND
a1.version = ezcontentobject_name.content_version AND
( a1.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a1.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a1.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a1.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a1.language_id ) ) & 8 ) )
<
( a1.language_id & 1 )
+ ( ( a1.language_id & 4 ) >> 1 )
+ ( ( a1.language_id & 2 ) << 1 )
+ ( ( a1.language_id & 8 ) )
)
AND ( a1.sort_key_string = '2' ) AND ezcontentobject.contentclass_id IN ( 1 ) AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 15 > 0
ORDER BY ezcontentobject_tree.priority ASC |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
( ( ezcontentobject_attribute.version = '20' AND
ezcontentobject_attribute.contentobject_id = '284' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '15' AND
ezcontentobject_attribute.contentobject_id = '285' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '13' AND
ezcontentobject_attribute.contentobject_id = '286' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '8' AND
ezcontentobject_attribute.contentobject_id = '949' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '8' AND
ezcontentobject_attribute.contentobject_id = '1541' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '14' AND
ezcontentobject_attribute.contentobject_id = '287' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) )
ORDER BY
ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC |
SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='131' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
Object not found (131) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:267' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 267 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 267 and ezcontentobject.contentclass_id NOT IN ( 48 ) AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 15 > 0
ORDER BY ezcontentobject_tree.priority ASC |
SELECT
parent_node_id, contentobject_id
FROM
ezcontentobject_tree
WHERE contentobject_id IN ( 8646 ) AND node_id = main_node_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 267 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT
parent_node_id, contentobject_id
FROM
ezcontentobject_tree
WHERE contentobject_id IN ( 284 ) AND node_id = main_node_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='121' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
Object not found (121) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:268' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 268 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 268 and ezcontentobject.contentclass_id NOT IN ( 48 ) AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 15 > 0
ORDER BY ezcontentobject_tree.priority ASC |
SELECT
parent_node_id, contentobject_id
FROM
ezcontentobject_tree
WHERE contentobject_id IN ( 8646 ) AND node_id = main_node_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 267 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT
parent_node_id, contentobject_id
FROM
ezcontentobject_tree
WHERE contentobject_id IN ( 284 ) AND node_id = main_node_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='151' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
Object not found (151) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:269' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 269 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 269 and ezcontentobject.contentclass_id NOT IN ( 48 ) AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 15 > 0
ORDER BY ezcontentobject_tree.priority ASC |
SELECT
parent_node_id, contentobject_id
FROM
ezcontentobject_tree
WHERE contentobject_id IN ( 8646 ) AND node_id = main_node_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 267 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT
parent_node_id, contentobject_id
FROM
ezcontentobject_tree
WHERE contentobject_id IN ( 284 ) AND node_id = main_node_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:911' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 911 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 911 and ezcontentobject.contentclass_id NOT IN ( 48 ) AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 15 > 0
ORDER BY ezcontentobject_tree.priority ASC |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
( ( ezcontentobject_attribute.version = '7' AND
ezcontentobject_attribute.contentobject_id = '1110' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '20' AND
ezcontentobject_attribute.contentobject_id = '1635' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '8' AND
ezcontentobject_attribute.contentobject_id = '1111' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) )
ORDER BY
ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC |
SELECT
parent_node_id, contentobject_id
FROM
ezcontentobject_tree
WHERE contentobject_id IN ( 8646 ) AND node_id = main_node_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 267 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT
parent_node_id, contentobject_id
FROM
ezcontentobject_tree
WHERE contentobject_id IN ( 284 ) AND node_id = main_node_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:911', 'eznode:1071' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 911, 1071 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:911', 'eznode:1245' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 911, 1245 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:911', 'eznode:1072' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 911, 1072 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:1155' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 1155 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 1155 and ezcontentobject.contentclass_id NOT IN ( 48 ) AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 15 > 0
ORDER BY ezcontentobject_tree.priority ASC |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
( ( ezcontentobject_attribute.version = '18' AND
ezcontentobject_attribute.contentobject_id = '12144' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '4' AND
ezcontentobject_attribute.contentobject_id = '12412' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '4' AND
ezcontentobject_attribute.contentobject_id = '12413' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '4' AND
ezcontentobject_attribute.contentobject_id = '12414' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '5' AND
ezcontentobject_attribute.contentobject_id = '12976' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '5' AND
ezcontentobject_attribute.contentobject_id = '12108' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) )
ORDER BY
ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC |
SELECT
parent_node_id, contentobject_id
FROM
ezcontentobject_tree
WHERE contentobject_id IN ( 8646 ) AND node_id = main_node_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 267 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT
parent_node_id, contentobject_id
FROM
ezcontentobject_tree
WHERE contentobject_id IN ( 284 ) AND node_id = main_node_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:1155', 'eznode:8376' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 1155, 8376 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:1155', 'eznode:8624' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 1155, 8624 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:1155', 'eznode:8625' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 1155, 8625 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:1155', 'eznode:8626' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 1155, 8626 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:1155', 'eznode:9014' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 1155, 9014 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:1155', 'eznode:8342' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 1155, 8342 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:270' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 270 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 270 and ezcontentobject.contentclass_id NOT IN ( 48 ) AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 15 > 0
ORDER BY ezcontentobject_tree.priority ASC |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
( ( ezcontentobject_attribute.version = '9' AND
ezcontentobject_attribute.contentobject_id = '1129' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '8' AND
ezcontentobject_attribute.contentobject_id = '1132' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '12' AND
ezcontentobject_attribute.contentobject_id = '1131' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '16' AND
ezcontentobject_attribute.contentobject_id = '1133' AND
ezcontentobject_attribute.language_code = 'ita-IT' ) OR ( ezcontentobject_attribute.version = '4' AND
ezcontentobject_attribute.contentobject_id = '401' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '7689' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) )
ORDER BY
ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC |
SELECT
parent_node_id, contentobject_id
FROM
ezcontentobject_tree
WHERE contentobject_id IN ( 8646 ) AND node_id = main_node_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 267 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT
parent_node_id, contentobject_id
FROM
ezcontentobject_tree
WHERE contentobject_id IN ( 284 ) AND node_id = main_node_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:270', 'eznode:1088' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 270, 1088 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:270', 'eznode:1091' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 270, 1091 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:270', 'eznode:1090' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 270, 1090 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:270', 'eznode:1092' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 270, 1092 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:270', 'eznode:383' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 270, 383 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:270', 'eznode:4892' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 270, 4892 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 377 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 377 and ezcontentobject.contentclass_id IN ( 1 ) AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 15 > 0
ORDER BY ezcontentobject_tree.priority ASC |
SELECT
parent_node_id, contentobject_id
FROM
ezcontentobject_tree
WHERE contentobject_id IN ( 8646 ) AND node_id = main_node_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 267 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT
parent_node_id, contentobject_id
FROM
ezcontentobject_tree
WHERE contentobject_id IN ( 284 ) AND node_id = main_node_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='1649' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '1649'
AND content_version = '1'
AND ( content_translation = 'fre-FR' OR language_id = '2' ) |
SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='2808' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '2808'
AND content_version = '3'
AND ( content_translation = 'ita-IT' OR language_id = '2' ) |
SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='1651' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT node_id
FROM ezcontentobject_tree
WHERE contentobject_id=1651 AND
main_node_id = node_id |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 1261 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 15 > 0
AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 15 > 0 ) AND action in ( 'eznode:2', 'eznode:1261' ) AND is_original = 1 AND is_alias=0 |
SELECT co.*, con.name as name, con.real_translation, cot.node_id
FROM ezcontentobject co
JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
WHERE cot.node_id IN ( 2, 1261 ) AND
( con.language_id & co.language_mask > 0 AND
( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 2 ) << 1 )
+ ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 8 ) )
<
( con.language_id & 1 )
+ ( ( con.language_id & 4 ) >> 1 )
+ ( ( con.language_id & 2 ) << 1 )
+ ( ( con.language_id & 8 ) )
) |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '1651'
AND content_version = '33'
AND ( content_translation = 'ita-IT' OR language_id = '2' ) |
eZTemplate: Loading template "parts/path.tpl" with resource "design" |
SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='406' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '406'
AND content_version = '3'
AND ( content_translation = 'ita-IT' OR language_id = '2' ) |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '406'
AND content_version = '3'
AND ( content_translation = 'ita-IT' OR language_id = '2' ) |
eZTemplate: Loading template "parts/extra_info.tpl" with resource "design" |
SELECT *
FROM ezcontentobject_tree
WHERE node_id = 1 |
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.path_string like '/1/%' and ezcontentobject_tree.node_id != 1 AND ezcontentobject.contentclass_id IN ( 32 ) AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 15 > 0
LIMIT 0, 1 |
SELECT url, is_valid FROM ezurl WHERE id='66' |
SELECT url, is_valid FROM ezurl WHERE id='65' |
Script end |
eZTemplate: Loading template "setup/debug_toolbar.tpl" with resource "design" |