|
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.alias_redirects AS e1_alias_redirects, e2.id AS e2_id, e2.link AS e2_link, e2.text AS e2_text, e2.text_md5 AS e2_text_md5, e2.is_alias AS e2_is_alias, e2.alias_redirects AS e2_alias_redirects, e3.id AS e3_id, e3.link AS e3_link, e3.text AS e3_text, e3.text_md5 AS e3_text_md5, e3.is_alias AS e3_is_alias, e3.action AS e3_action, e3.alias_redirects AS e3_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1, ezurlalias_ml e2, ezurlalias_ml e3 WHERE e0.parent = 0 AND (e0.lang_mask & 9 > 0) AND e0.text_md5 = MD5( 'issues' ) AND e1.parent = e0.link AND (e1.lang_mask & 9 > 0) AND e1.text_md5 = MD5( '2018' ) AND e2.parent = e1.link AND (e2.lang_mask & 9 > 0) AND e2.text_md5 = MD5( '217' ) AND e3.parent = e2.link AND (e3.lang_mask & 9 > 0) AND e3.text_md5 = MD5( 'fosspicks' )
LIMIT 0, 1 |
Module start 'content' |
Starting shopSSOhandler |
SELECT id, remote_id, type, auth_data, updated
FROM auto_login_account WHERE auth_data='216.73.216.215' |
SELECT id, remote_id, type, auth_data, updated
FROM auto_login_account WHERE auth_data='216.73.216.*' |
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 = 81532 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 15157 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
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 & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379', 'eznode:81532' ) 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, 13375, 78178, 81379, 81532 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
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=92804 |
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=92804 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 = 81379 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
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='133' 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, 13375, 78178, 81379 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
ORDER BY path_string |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375' ) 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, 13375 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178' ) 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, 13375, 78178 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379' ) 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, 13375, 78178, 81379 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '92804'
AND content_version = '1'
AND ( content_translation = 'eng-US' OR language_id = '9' ) |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '92804'
AND content_version = '1'
AND ( content_translation = 'eng-US' OR language_id = '9' ) |
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 = 81379 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
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 = '92804' AND
ezcontentobject_version.version = '1' AND
ezcontentobject_attribute.contentobject_id = '92804' AND ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.language_code = 'eng-US'
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='498' AND version='0' |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379', 'eznode:81532' ) 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, 13375, 78178, 81379, 81532 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
Operator 'ez_url' is not registered |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379', 'eznode:81532' ) 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, 13375, 78178, 81379, 81532 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 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 = 81532 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 81379 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379' ) 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, 13375, 78178, 81379 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 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 = 81379 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 81379 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 78178 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
Variable 'author_nodes' is already defined. |
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 = 5 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 a0 ON (a0.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentobject_attribute a1 ON (a1.contentobject_id = ezcontentobject.id) WHERE ezcontentobject_tree.path_string like '/1/5/%' and
a0.contentobject_id = ezcontentobject.id AND
a0.contentclassattribute_id = 1144 AND
a0.version = ezcontentobject_name.content_version AND
( a0.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 8 ) >> 2 )
<
( a0.language_id & 1 )
+ ( ( a0.language_id & 8 ) >> 2 )
)
AND
a1.contentobject_id = ezcontentobject.id AND
a1.contentclassattribute_id = 1145 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 ) ) & 8 ) >> 2 )
<
( a1.language_id & 1 )
+ ( ( a1.language_id & 8 ) >> 2 )
)
AND ( a0.sort_key_string = 'Graham' AND a1.sort_key_string = 'Morrison' ) AND ezcontentobject_tree.node_id != 5 AND ezcontentobject.contentclass_id IN ( 130 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
AND ezcontentobject_tree.is_invisible = 0 AND
ezcontentobject.language_mask & 9 > 0
LIMIT 0, 1 |
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 = 5 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 a0 ON (a0.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentobject_attribute a1 ON (a1.contentobject_id = ezcontentobject.id) WHERE ezcontentobject_tree.path_string like '/1/5/%' and
a0.contentobject_id = ezcontentobject.id AND
a0.contentclassattribute_id = 8 AND
a0.version = ezcontentobject_name.content_version AND
( a0.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 8 ) >> 2 )
<
( a0.language_id & 1 )
+ ( ( a0.language_id & 8 ) >> 2 )
)
AND
a1.contentobject_id = ezcontentobject.id AND
a1.contentclassattribute_id = 9 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 ) ) & 8 ) >> 2 )
<
( a1.language_id & 1 )
+ ( ( a1.language_id & 8 ) >> 2 )
)
AND ( a0.sort_key_string = 'Graham' AND a1.sort_key_string = 'Morrison' ) AND ezcontentobject_tree.node_id != 5 AND ezcontentobject.contentclass_id IN ( 4 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
AND ezcontentobject_tree.is_invisible = 0 AND
ezcontentobject.language_mask & 9 > 0
LIMIT 0, 1 |
Variable 'AuthorData' is already defined. |
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='501' AND version='0' |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE (ezurlalias_ml.lang_mask & 9 > 0) AND action='eznode:81532' AND is_original = 1 AND is_alias = 0 |
SELECT id, parent, lang_mask, text FROM ezurlalias_ml WHERE (ezurlalias_ml.lang_mask & 9 > 0) AND id=57325 AND is_original = 1 AND is_alias = 0 |
SELECT id, parent, lang_mask, text FROM ezurlalias_ml WHERE (ezurlalias_ml.lang_mask & 9 > 0) AND id=53877 AND is_original = 1 AND is_alias = 0 |
SELECT id, parent, lang_mask, text FROM ezurlalias_ml WHERE (ezurlalias_ml.lang_mask & 9 > 0) AND id=34940 AND is_original = 1 AND is_alias = 0 |
Attribute 'id' does not exist |
Attribute 'contentclass_attribute_identifier' does not exist |
SELECT * FROM ezurl WHERE id IN ( 45497 ) |
SELECT ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentobject.*, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentclass,
ezcontentobject,
ezcontentobject_name
WHERE
ezcontentclass.id=ezcontentobject.contentclass_id AND ezcontentobject.id IN ( 92805 ) AND
ezcontentobject.id = ezcontentobject_name.contentobject_id AND
ezcontentobject.current_version = ezcontentobject_name.content_version 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.name, 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 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) WHERE contentobject_id = 92805 ORDER BY path_string |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.name, 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 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) WHERE contentobject_id = 92805 ORDER BY path_string |
SELECT node_id
FROM ezcontentobject_tree
WHERE contentobject_id=92805 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 = 15157 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
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=92805 |
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=92805 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
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 = '92805' AND
ezcontentobject_version.version = '1' AND
ezcontentobject_attribute.contentobject_id = '92805' AND ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.language_code = 'eng-US'
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='118' AND version='0' |
SELECT id, contentobject_attribute_id, filepath
FROM ezimagefile WHERE filepath='var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US/figaa804595d790b7e129127d639f175d8d.png_reference.png' |
SELECT id, contentobject_attribute_id, filepath
FROM ezimagefile WHERE filepath='var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US/figaa804595d790b7e129127d639f175d8d.png_large.png' |
SELECT id, contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float
FROM ezcontentobject_attribute WHERE id='737383' AND version='1' |
SELECT id, contentobject_id, version, language_code
FROM ezcontentobject_attribute WHERE id='737383' AND contentobject_id='92805' AND version='1' AND language_code='eng-US' |
UPDATE ezcontentobject_attribute SET language_id=9, contentclassattribute_id=118,
attribute_original_id=737383, sort_key_int=0, sort_key_string='', data_type_string='ezimage',
data_text='<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<ezimage serial_number=\"1\" is_valid=\"1\" filename=\"figaa804595d790b7e129127d639f175d8d.png.png\" suffix=\"png\" basename=\"figaa804595d790b7e129127d639f175d8d.png\" dirpath=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US\" url=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US/figaa804595d790b7e129127d639f175d8d.png.png\" original_filename=\"figaa804595d790b7e129127d639f175d8d_max.png\" mime_type=\"image/png\" width=\"1487\" height=\"1154\" alternative_text=\"\" alias_key=\"1293033771\" timestamp=\"1540991644\"><original attribute_id=\"737383\" attribute_version=\"1\" attribute_language=\"eng-US\"/><alias name=\"reference\" filename=\"figaa804595d790b7e129127d639f175d8d.png_reference.png\" suffix=\"png\" dirpath=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US\" url=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US/figaa804595d790b7e129127d639f175d8d.png_reference.png\" mime_type=\"image/png\" width=\"600\" height=\"466\" alias_key=\"2605465115\" timestamp=\"1758808452\" is_valid=\"1\"/><alias name=\"large\" filename=\"figaa804595d790b7e129127d639f175d8d.png_large.png\" suffix=\"png\" dirpath=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US\" url=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US/figaa804595d790b7e129127d639f175d8d.png_large.png\" mime_type=\"image/png\" width=\"346\" height=\"269\" alias_key=\"3341972475\" timestamp=\"1758808452\" is_valid=\"1\"/><alias name=\"opengraph_h\" filename=\"figaa804595d790b7e129127d639f175d8d.png_opengraph_h.png\" suffix=\"png\" dirpath=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US\" url=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US/figaa804595d790b7e129127d639f175d8d.png_opengraph_h.png\" mime_type=\"image/png\" width=\"258\" height=\"200\" alias_key=\"1005200116\" timestamp=\"1757167558\" is_valid=\"1\"/><alias name=\"small\" filename=\"figaa804595d790b7e129127d639f175d8d.png_small.png\" suffix=\"png\" dirpath=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US\" url=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US/figaa804595d790b7e129127d639f175d8d.png_small.png\" mime_type=\"image/png\" width=\"100\" height=\"78\" alias_key=\"2343348577\" timestamp=\"1757155763\" is_valid=\"1\"/><alias name=\"teaser_top\" filename=\"figaa804595d790b7e129127d639f175d8d.png_teaser_top.png\" suffix=\"png\" dirpath=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US\" url=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US/figaa804595d790b7e129127d639f175d8d.png_teaser_top.png\" mime_type=\"image/png\" width=\"300\" height=\"162\" alias_key=\"2074093600\" timestamp=\"1543428310\" is_valid=\"1\"/></ezimage>\n', data_int=NULL, data_float=0.000000 WHERE id='737383' AND contentobject_id='92805' AND version='1' AND language_code='eng-US' |
Attribute 'id' does not exist |
Attribute 'contentclass_attribute_identifier' does not exist |
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 = 81379 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 78178 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 13375 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
!!!No such variable 'Links' in group 'issuebox_13375' for lnm_upselling.ini |
Variable 'links' is already defined. |
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='1105' AND version='0' |
SELECT DISTINCT ezdiscountrule.id,
ezdiscountrule.name
FROM ezdiscountrule,
ezuser_discountrule
WHERE ezuser_discountrule.contentobject_id IN ( 42, 4, 15027 ) AND
ezuser_discountrule.discountrule_id = ezdiscountrule.id |
SELECT id, name, percentage
FROM ezvattype WHERE id='1' |
SELECT id, name, percentage
FROM ezvattype WHERE id='1' |
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='92730' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT value FROM ezsite_data WHERE name='ezfind_site_id' |
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 identifier='lmi_news' AND version='0' ORDER BY version ASC
LIMIT 0, 2 |
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 identifier='lmi_article' AND version='0' ORDER BY version ASC
LIMIT 0, 2 |
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 identifier='blog_post' AND version='0' ORDER BY version ASC
LIMIT 0, 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='106677' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.name, 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 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) WHERE contentobject_id = 106677 ORDER BY path_string |
SELECT node_id
FROM ezcontentobject_tree
WHERE contentobject_id=106677 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 = 15157 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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='91041' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.name, 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 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) WHERE contentobject_id = 91041 ORDER BY path_string |
SELECT node_id
FROM ezcontentobject_tree
WHERE contentobject_id=91041 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 = 15157 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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='106750' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.name, 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 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) WHERE contentobject_id = 106750 ORDER BY path_string |
SELECT node_id
FROM ezcontentobject_tree
WHERE contentobject_id=106750 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 = 15157 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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='96113' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.name, 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 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) WHERE contentobject_id = 96113 ORDER BY path_string |
SELECT node_id
FROM ezcontentobject_tree
WHERE contentobject_id=96113 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 = 15157 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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='97208' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.name, 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 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) WHERE contentobject_id = 97208 ORDER BY path_string |
SELECT node_id
FROM ezcontentobject_tree
WHERE contentobject_id=97208 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 = 15157 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 IN ( 95645, 79744, 95718, 84864, 85968 ) AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.name, 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 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) WHERE contentobject_id = 106677 ORDER BY path_string |
SELECT node_id
FROM ezcontentobject_tree
WHERE contentobject_id=106677 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 = 15157 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 95645 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:93948', 'eznode:95561', 'eznode:95645' ) 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, 13375, 93948, 95561, 95645 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.name, 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 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) WHERE contentobject_id = 91041 ORDER BY path_string |
SELECT node_id
FROM ezcontentobject_tree
WHERE contentobject_id=91041 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 = 15157 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 79744 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:79636', 'eznode:79744' ) 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, 13375, 78178, 79636, 79744 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.name, 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 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) WHERE contentobject_id = 106750 ORDER BY path_string |
SELECT node_id
FROM ezcontentobject_tree
WHERE contentobject_id=106750 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 = 15157 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 95718 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:93948', 'eznode:95561', 'eznode:95718' ) 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, 13375, 93948, 95561, 95718 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.name, 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 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) WHERE contentobject_id = 96113 ORDER BY path_string |
SELECT node_id
FROM ezcontentobject_tree
WHERE contentobject_id=96113 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 = 15157 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 84864 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:81639', 'eznode:84766', 'eznode:84864' ) 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, 13375, 81639, 84766, 84864 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.name, 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 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) WHERE contentobject_id = 97208 ORDER BY path_string |
SELECT node_id
FROM ezcontentobject_tree
WHERE contentobject_id=97208 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 = 15157 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 85968 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:85026', 'eznode:85786', 'eznode:85968' ) 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, 13375, 85026, 85786, 85968 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
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 = '106677' AND
ezcontentobject_version.version = '2' AND
ezcontentobject_attribute.contentobject_id = '106677' AND ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.language_code = 'eng-US'
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 & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:93948', 'eznode:95561', 'eznode:95645' ) 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, 13375, 93948, 95561, 95645 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:93948', 'eznode:95561', 'eznode:95645' ) 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, 13375, 93948, 95561, 95645 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:93948', 'eznode:95561', 'eznode:95645' ) 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, 13375, 93948, 95561, 95645 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:93948', 'eznode:95561', 'eznode:95645' ) 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, 13375, 93948, 95561, 95645 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
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 = '91041' AND
ezcontentobject_version.version = '2' AND
ezcontentobject_attribute.contentobject_id = '91041' AND ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.language_code = 'eng-US'
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 & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:79636', 'eznode:79744' ) 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, 13375, 78178, 79636, 79744 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:79636', 'eznode:79744' ) 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, 13375, 78178, 79636, 79744 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:79636', 'eznode:79744' ) 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, 13375, 78178, 79636, 79744 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:79636', 'eznode:79744' ) 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, 13375, 78178, 79636, 79744 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
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 = '106750' AND
ezcontentobject_version.version = '2' AND
ezcontentobject_attribute.contentobject_id = '106750' AND ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.language_code = 'eng-US'
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 & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:93948', 'eznode:95561', 'eznode:95718' ) 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, 13375, 93948, 95561, 95718 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:93948', 'eznode:95561', 'eznode:95718' ) 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, 13375, 93948, 95561, 95718 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:93948', 'eznode:95561', 'eznode:95718' ) 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, 13375, 93948, 95561, 95718 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:93948', 'eznode:95561', 'eznode:95718' ) 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, 13375, 93948, 95561, 95718 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
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 = '96113' AND
ezcontentobject_version.version = '2' AND
ezcontentobject_attribute.contentobject_id = '96113' AND ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.language_code = 'eng-US'
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 & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:81639', 'eznode:84766', 'eznode:84864' ) 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, 13375, 81639, 84766, 84864 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:81639', 'eznode:84766', 'eznode:84864' ) 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, 13375, 81639, 84766, 84864 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:81639', 'eznode:84766', 'eznode:84864' ) 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, 13375, 81639, 84766, 84864 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:81639', 'eznode:84766', 'eznode:84864' ) 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, 13375, 81639, 84766, 84864 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
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 = '97208' AND
ezcontentobject_version.version = '1' AND
ezcontentobject_attribute.contentobject_id = '97208' AND ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.language_code = 'eng-US'
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 & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:85026', 'eznode:85786', 'eznode:85968' ) 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, 13375, 85026, 85786, 85968 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:85026', 'eznode:85786', 'eznode:85968' ) 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, 13375, 85026, 85786, 85968 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:85026', 'eznode:85786', 'eznode:85968' ) 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, 13375, 85026, 85786, 85968 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:85026', 'eznode:85786', 'eznode:85968' ) 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, 13375, 85026, 85786, 85968 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT node_id
FROM ezcontentobject_tree
WHERE contentobject_id=92804 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 = 81532 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379', 'eznode:81532' ) 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, 13375, 78178, 81379, 81532 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379', 'eznode:81532' ) 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, 13375, 78178, 81379, 81532 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
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=92804 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: 'eZTags' |
Missing translation for message in context: 'kernel/navigationpart' with comment: 'Navigation part'. The untranslated message is: 'eZFind' |
Missing translation for message in context: 'kernel/navigationpart' with comment: 'Navigation part'. The untranslated message is: 'LNM' |
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 = 81532 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
Operator 'tag_cleaner' is not registered |
Variable 'author_nodes' is already defined. |
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 = 5 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 a0 ON (a0.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentobject_attribute a1 ON (a1.contentobject_id = ezcontentobject.id) WHERE ezcontentobject_tree.path_string like '/1/5/%' and
a0.contentobject_id = ezcontentobject.id AND
a0.contentclassattribute_id = 1144 AND
a0.version = ezcontentobject_name.content_version AND
( a0.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 8 ) >> 2 )
<
( a0.language_id & 1 )
+ ( ( a0.language_id & 8 ) >> 2 )
)
AND
a1.contentobject_id = ezcontentobject.id AND
a1.contentclassattribute_id = 1145 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 ) ) & 8 ) >> 2 )
<
( a1.language_id & 1 )
+ ( ( a1.language_id & 8 ) >> 2 )
)
AND ( a0.sort_key_string = 'Graham' AND a1.sort_key_string = 'Morrison' ) AND ezcontentobject_tree.node_id != 5 AND ezcontentobject.contentclass_id IN ( 130 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
AND ezcontentobject_tree.is_invisible = 0 AND
ezcontentobject.language_mask & 9 > 0
LIMIT 0, 1 |
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 = 5 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 a0 ON (a0.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentobject_attribute a1 ON (a1.contentobject_id = ezcontentobject.id) WHERE ezcontentobject_tree.path_string like '/1/5/%' and
a0.contentobject_id = ezcontentobject.id AND
a0.contentclassattribute_id = 8 AND
a0.version = ezcontentobject_name.content_version AND
( a0.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 8 ) >> 2 )
<
( a0.language_id & 1 )
+ ( ( a0.language_id & 8 ) >> 2 )
)
AND
a1.contentobject_id = ezcontentobject.id AND
a1.contentclassattribute_id = 9 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 ) ) & 8 ) >> 2 )
<
( a1.language_id & 1 )
+ ( ( a1.language_id & 8 ) >> 2 )
)
AND ( a0.sort_key_string = 'Graham' AND a1.sort_key_string = 'Morrison' ) AND ezcontentobject_tree.node_id != 5 AND ezcontentobject.contentclass_id IN ( 4 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
AND ezcontentobject_tree.is_invisible = 0 AND
ezcontentobject.language_mask & 9 > 0
LIMIT 0, 1 |
Variable 'AuthorData' is already defined. |
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='15027' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=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 = '15027' AND
ezcontentobject_version.version = '5' AND
ezcontentobject_attribute.contentobject_id = '15027' AND ezcontentobject_attribute.version = '5' AND
( ezcontentobject_attribute.language_id & ezcontentobject_version.language_mask > 0 AND
( ( ezcontentobject_version.language_mask - ( ezcontentobject_version.language_mask & ezcontentobject_attribute.language_id ) ) & 1 )
+ ( ( ( ezcontentobject_version.language_mask - ( ezcontentobject_version.language_mask & ezcontentobject_attribute.language_id ) ) & 8 ) >> 2 )
<
( ezcontentobject_attribute.language_id & 1 )
+ ( ( ezcontentobject_attribute.language_id & 8 ) >> 2 )
)
ORDER BY
ezcontentclass_attribute.placement ASC,
ezcontentobject_attribute.language_code ASC |
SELECT node_id
FROM ezcontentobject_tree
WHERE contentobject_id=92804 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 = 81532 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379', 'eznode:81532' ) 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, 13375, 78178, 81379, 81532 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
Variable 'canonical' is already defined. |
SELECT node_id
FROM ezcontentobject_tree
WHERE contentobject_id=92804 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 = 81532 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379', 'eznode:81532' ) 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, 13375, 78178, 81379, 81532 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT
ezcontentclass.serialized_name_list AS class_serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container,
ezcontentobject.*, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentclass,
ezcontentobject,
ezcontentobject_link,
ezcontentobject_name
WHERE
ezcontentclass.id=ezcontentobject.contentclass_id AND
ezcontentclass.version=0 AND
ezcontentobject.status=1 AND
( relation_type & 7 ) <> 0
AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
ezcontentobject_link.from_contentobject_id='92804' AND
ezcontentobject_link.from_contentobject_version='1'
AND
ezcontentobject.id = ezcontentobject_name.contentobject_id AND
ezcontentobject.current_version = ezcontentobject_name.content_version 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT
ezcontentclass.serialized_name_list AS class_serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container,
ezcontentobject.*, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentclass,
ezcontentobject,
ezcontentobject_link,
ezcontentobject_name
WHERE
ezcontentclass.id=ezcontentobject.contentclass_id AND
ezcontentclass.version=0 AND
ezcontentobject.status=1 AND
( relation_type & 7 ) <> 0
AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
ezcontentobject_link.from_contentobject_id='92804' AND
ezcontentobject_link.from_contentobject_version='1'
AND
ezcontentobject.id = ezcontentobject_name.contentobject_id AND
ezcontentobject.current_version = ezcontentobject_name.content_version 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT
ezcontentclass.serialized_name_list AS class_serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container,
ezcontentobject.*, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentclass,
ezcontentobject,
ezcontentobject_link,
ezcontentobject_name
WHERE
ezcontentclass.id=ezcontentobject.contentclass_id AND
ezcontentclass.version=0 AND
ezcontentobject.status=1 AND
( relation_type & 7 ) <> 0
AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
ezcontentobject_link.from_contentobject_id='92804' AND
ezcontentobject_link.from_contentobject_version='1'
AND
ezcontentobject.id = ezcontentobject_name.contentobject_id AND
ezcontentobject.current_version = ezcontentobject_name.content_version 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT id, contentobject_attribute_id, filepath
FROM ezimagefile WHERE filepath='var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US/figaa804595d790b7e129127d639f175d8d.png_opengraph_h.png' |
SELECT id, contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float
FROM ezcontentobject_attribute WHERE id='737383' AND version='1' |
SELECT id, contentobject_id, version, language_code
FROM ezcontentobject_attribute WHERE id='737383' AND contentobject_id='92805' AND version='1' AND language_code='eng-US' |
UPDATE ezcontentobject_attribute SET language_id=9, contentclassattribute_id=118,
attribute_original_id=737383, sort_key_int=0, sort_key_string='', data_type_string='ezimage',
data_text='<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<ezimage serial_number=\"1\" is_valid=\"1\" filename=\"figaa804595d790b7e129127d639f175d8d.png.png\" suffix=\"png\" basename=\"figaa804595d790b7e129127d639f175d8d.png\" dirpath=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US\" url=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US/figaa804595d790b7e129127d639f175d8d.png.png\" original_filename=\"figaa804595d790b7e129127d639f175d8d_max.png\" mime_type=\"image/png\" width=\"1487\" height=\"1154\" alternative_text=\"\" alias_key=\"1293033771\" timestamp=\"1540991644\"><original attribute_id=\"737383\" attribute_version=\"1\" attribute_language=\"eng-US\"/><alias name=\"reference\" filename=\"figaa804595d790b7e129127d639f175d8d.png_reference.png\" suffix=\"png\" dirpath=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US\" url=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US/figaa804595d790b7e129127d639f175d8d.png_reference.png\" mime_type=\"image/png\" width=\"600\" height=\"466\" alias_key=\"2605465115\" timestamp=\"1758808452\" is_valid=\"1\"/><alias name=\"large\" filename=\"figaa804595d790b7e129127d639f175d8d.png_large.png\" suffix=\"png\" dirpath=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US\" url=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US/figaa804595d790b7e129127d639f175d8d.png_large.png\" mime_type=\"image/png\" width=\"346\" height=\"269\" alias_key=\"3341972475\" timestamp=\"1758808452\" is_valid=\"1\"/><alias name=\"opengraph_h\" filename=\"figaa804595d790b7e129127d639f175d8d.png_opengraph_h.png\" suffix=\"png\" dirpath=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US\" url=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US/figaa804595d790b7e129127d639f175d8d.png_opengraph_h.png\" mime_type=\"image/png\" width=\"258\" height=\"200\" alias_key=\"1005200116\" timestamp=\"1758808453\" is_valid=\"1\"/><alias name=\"small\" filename=\"figaa804595d790b7e129127d639f175d8d.png_small.png\" suffix=\"png\" dirpath=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US\" url=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US/figaa804595d790b7e129127d639f175d8d.png_small.png\" mime_type=\"image/png\" width=\"100\" height=\"78\" alias_key=\"2343348577\" timestamp=\"1757155763\" is_valid=\"1\"/><alias name=\"teaser_top\" filename=\"figaa804595d790b7e129127d639f175d8d.png_teaser_top.png\" suffix=\"png\" dirpath=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US\" url=\"var/linux_magazin/storage/images/issues/2018/217/fosspicks/figaa804595d790b7e129127d639f175d8d.png/737383-1-eng-US/figaa804595d790b7e129127d639f175d8d.png_teaser_top.png\" mime_type=\"image/png\" width=\"300\" height=\"162\" alias_key=\"2074093600\" timestamp=\"1543428310\" is_valid=\"1\"/></ezimage>\n', data_int=NULL, data_float=0.000000 WHERE id='737383' AND contentobject_id='92805' AND version='1' AND language_code='eng-US' |
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='1134' AND version='0' |
SELECT eztags.id, eztags.keyword, eztags.parent_id FROM eztags_attribute_link, eztags
WHERE eztags_attribute_link.keyword_id = eztags.id AND
eztags_attribute_link.objectattribute_id = 737378 AND
eztags_attribute_link.objectattribute_version = 1 |
Could not find: stylesheets/websitetoolbar.css |
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 & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 ) WHERE ezcontentobject_tree.path_string like '/1/2/%' and ezcontentobject_tree.node_id != 2 AND ezcontentobject.contentclass_id IN ( 134 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 8) AND ( ( ezcontentobject_tree.path_string like '/1/2/15157/%' ) OR ( ezcontentobject_tree.node_id in (15157) ) )) OR (ezcontentobject.section_id in (1, 8)) OR (ezcontentobject.contentclass_id in (101, 107, 113, 12, 129, 35, 5, 88, 89, 90, 91) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 9 > 0
LIMIT 0, 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 = '46' AND
ezcontentobject_attribute.contentobject_id = '70294' AND
ezcontentobject_attribute.language_code = 'eng-US' ) )
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 = 81532 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379', 'eznode:81532' ) 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, 13375, 78178, 81379, 81532 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379', 'eznode:81532' ) 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, 13375, 78178, 81379, 81532 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379', 'eznode:81532' ) 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, 13375, 78178, 81379, 81532 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379', 'eznode:81532' ) 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, 13375, 78178, 81379, 81532 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379', 'eznode:81532' ) 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, 13375, 78178, 81379, 81532 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379', 'eznode:81532' ) 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, 13375, 78178, 81379, 81532 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379', 'eznode:81532' ) 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, 13375, 78178, 81379, 81532 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:13375', 'eznode:78178', 'eznode:81379', 'eznode:81532' ) 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, 13375, 78178, 81379, 81532 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Variable 'pagedata' is already defined. |
Variable 'pagedesign' is already defined. |
Variable 'pagedata' is already defined. |
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 = 81532 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 81532 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 ) WHERE ezcontentobject_tree.path_string like '/1/2/13375/78178/81379/81532/%' and ezcontentobject_tree.node_id != 81532 AND ezcontentobject.contentclass_id IN ( 134 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
AND ezcontentobject_tree.is_invisible = 0 AND
ezcontentobject.language_mask & 9 > 0
LIMIT 0, 1 |
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 = 81379 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 81379 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 ) WHERE ezcontentobject_tree.path_string like '/1/2/13375/78178/81379/%' and ezcontentobject_tree.node_id != 81379 AND ezcontentobject.contentclass_id IN ( 134 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
AND ezcontentobject_tree.is_invisible = 0 AND
ezcontentobject.language_mask & 9 > 0
LIMIT 0, 1 |
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 = 78178 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 78178 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 ) WHERE ezcontentobject_tree.path_string like '/1/2/13375/78178/%' and ezcontentobject_tree.node_id != 78178 AND ezcontentobject.contentclass_id IN ( 134 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
AND ezcontentobject_tree.is_invisible = 0 AND
ezcontentobject.language_mask & 9 > 0
LIMIT 0, 1 |
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 = 13375 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 13375 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 ) WHERE ezcontentobject_tree.path_string like '/1/2/13375/%' and ezcontentobject_tree.node_id != 13375 AND ezcontentobject.contentclass_id IN ( 134 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
AND ezcontentobject_tree.is_invisible = 0 AND
ezcontentobject.language_mask & 9 > 0
LIMIT 0, 1 |
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 & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 = 2 AND ezcontentclass.version = 0 AND
ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 ) WHERE ezcontentobject_tree.path_string like '/1/2/%' and ezcontentobject_tree.node_id != 2 AND ezcontentobject.contentclass_id IN ( 134 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
AND ezcontentobject_tree.is_invisible = 0 AND
ezcontentobject.language_mask & 9 > 0
LIMIT 0, 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 = '46' AND
ezcontentobject_attribute.contentobject_id = '70294' AND
ezcontentobject_attribute.language_code = 'eng-US' ) )
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='70294' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
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='1180' AND version='0' |
SELECT ezm_pool.node_id
FROM ezm_pool, ezcontentobject_tree, ezcontentobject
WHERE ezm_pool.block_id='3528d298bdffc768f9691a12ae6b2ceb'
AND ezm_pool.ts_visible>0
AND ezm_pool.ts_hidden=0
AND ezcontentobject_tree.node_id = ezm_pool.node_id
AND ezcontentobject.id = ezm_pool.object_id
AND
ezcontentobject.language_mask & 9 > 0
AND ezcontentobject_tree.is_invisible = 0
ORDER BY ezm_pool.priority DESC |
SELECT ezm_pool.node_id
FROM ezm_pool, ezcontentobject_tree, ezcontentobject
WHERE ezm_pool.block_id='99190756d58d1be27735ba2f43b936cc'
AND ezm_pool.ts_visible>0
AND ezm_pool.ts_hidden=0
AND ezcontentobject_tree.node_id = ezm_pool.node_id
AND ezcontentobject.id = ezm_pool.object_id
AND
ezcontentobject.language_mask & 9 > 0
AND ezcontentobject_tree.is_invisible = 0
ORDER BY ezm_pool.priority DESC |
SELECT ezm_pool.node_id
FROM ezm_pool, ezcontentobject_tree, ezcontentobject
WHERE ezm_pool.block_id='e4e6b01957bffbf25bba1b6c76d2e68b'
AND ezm_pool.ts_visible>0
AND ezm_pool.ts_hidden=0
AND ezcontentobject_tree.node_id = ezm_pool.node_id
AND ezcontentobject.id = ezm_pool.object_id
AND
ezcontentobject.language_mask & 9 > 0
AND ezcontentobject_tree.is_invisible = 0
ORDER BY ezm_pool.priority DESC |
SELECT ezm_pool.node_id
FROM ezm_pool, ezcontentobject_tree, ezcontentobject
WHERE ezm_pool.block_id='4fcac402925ad119a5562ef207f64723'
AND ezm_pool.ts_visible>0
AND ezm_pool.ts_hidden=0
AND ezcontentobject_tree.node_id = ezm_pool.node_id
AND ezcontentobject.id = ezm_pool.object_id
AND
ezcontentobject.language_mask & 9 > 0
AND ezcontentobject_tree.is_invisible = 0
ORDER BY ezm_pool.priority DESC |
SELECT ezm_pool.node_id
FROM ezm_pool, ezcontentobject_tree, ezcontentobject
WHERE ezm_pool.block_id='eb89ac3586d2dc449d3820833e8e18ed'
AND ezm_pool.ts_visible>0
AND ezm_pool.ts_hidden=0
AND ezcontentobject_tree.node_id = ezm_pool.node_id
AND ezcontentobject.id = ezm_pool.object_id
AND
ezcontentobject.language_mask & 9 > 0
AND ezcontentobject_tree.is_invisible = 0
ORDER BY ezm_pool.priority DESC |
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 version='0' AND identifier IN ( 'news', 'lmi_news', 'article', 'lmi_online_article', 'lmi_article' ) ORDER BY id 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 & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 ) WHERE ezcontentobject_tree.path_string like '/1/2/%' and ezcontentobject_tree.node_id != 2 AND ezcontentobject.contentclass_id IN ( 55, 31 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 8) AND ( ( ezcontentobject_tree.path_string like '/1/2/15157/%' ) OR ( ezcontentobject_tree.node_id in (15157) ) )) OR (ezcontentobject.section_id in (1, 8)) OR (ezcontentobject.contentclass_id in (101, 107, 113, 12, 129, 35, 5, 88, 89, 90, 91) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 9 > 0
ORDER BY ezcontentobject.published DESC
LIMIT 0, 10 |
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 = '112260' AND
ezcontentobject_attribute.language_code = 'eng-US' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '112255' AND
ezcontentobject_attribute.language_code = 'eng-US' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '112250' AND
ezcontentobject_attribute.language_code = 'eng-US' ) OR ( ezcontentobject_attribute.version = '2' AND
ezcontentobject_attribute.contentobject_id = '112249' AND
ezcontentobject_attribute.language_code = 'eng-US' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '112244' AND
ezcontentobject_attribute.language_code = 'eng-US' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '112240' AND
ezcontentobject_attribute.language_code = 'eng-US' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '112236' AND
ezcontentobject_attribute.language_code = 'eng-US' ) OR ( ezcontentobject_attribute.version = '2' AND
ezcontentobject_attribute.contentobject_id = '112226' AND
ezcontentobject_attribute.language_code = 'eng-US' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '112075' AND
ezcontentobject_attribute.language_code = 'eng-US' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '112073' AND
ezcontentobject_attribute.language_code = 'eng-US' ) )
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 & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:14134', 'eznode:14176', 'eznode:101287' ) 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, 14134, 14176, 101287 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
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='548' AND version='0' |
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='1132' AND version='0' |
SELECT eztags.id, eztags.keyword, eztags.parent_id FROM eztags_attribute_link, eztags
WHERE eztags_attribute_link.keyword_id = eztags.id AND
eztags_attribute_link.objectattribute_id = 861864 AND
eztags_attribute_link.objectattribute_version = 1 |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id IN ( '39', '339', '654' ) ORDER BY keyword ASC |
Variable 'items' is already defined. |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='339' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='39' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='339' |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
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='550' AND version='0' |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:14134', 'eznode:14176', 'eznode:101282' ) 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, 14134, 14176, 101282 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT eztags.id, eztags.keyword, eztags.parent_id FROM eztags_attribute_link, eztags
WHERE eztags_attribute_link.keyword_id = eztags.id AND
eztags_attribute_link.objectattribute_id = 861786 AND
eztags_attribute_link.objectattribute_version = 1 |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id IN ( '44', '381', '562' ) ORDER BY keyword ASC |
Variable 'items' is already defined. |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='39' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='339' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='155' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='142' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='155' |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:14134', 'eznode:14176', 'eznode:101278' ) 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, 14134, 14176, 101278 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT eztags.id, eztags.keyword, eztags.parent_id FROM eztags_attribute_link, eztags
WHERE eztags_attribute_link.keyword_id = eztags.id AND
eztags_attribute_link.objectattribute_id = 861722 AND
eztags_attribute_link.objectattribute_version = 1 |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id IN ( '39', '58', '152' ) ORDER BY keyword ASC |
Variable 'items' is already defined. |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='32' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='339' |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:14134', 'eznode:14176', 'eznode:101277' ) 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, 14134, 14176, 101277 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT eztags.id, eztags.keyword, eztags.parent_id FROM eztags_attribute_link, eztags
WHERE eztags_attribute_link.keyword_id = eztags.id AND
eztags_attribute_link.objectattribute_id = 861706 AND
eztags_attribute_link.objectattribute_version = 2 |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id IN ( '39', '155', '674' ) ORDER BY keyword ASC |
Variable 'items' is already defined. |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='155' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='339' |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:14134', 'eznode:14176', 'eznode:101272' ) 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, 14134, 14176, 101272 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT eztags.id, eztags.keyword, eztags.parent_id FROM eztags_attribute_link, eztags
WHERE eztags_attribute_link.keyword_id = eztags.id AND
eztags_attribute_link.objectattribute_id = 861670 AND
eztags_attribute_link.objectattribute_version = 1 |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id IN ( '339', '642', '687' ) ORDER BY keyword ASC |
Variable 'items' is already defined. |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='39' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='339' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='340' |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:14134', 'eznode:14176', 'eznode:101269' ) 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, 14134, 14176, 101269 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT eztags.id, eztags.keyword, eztags.parent_id FROM eztags_attribute_link, eztags
WHERE eztags_attribute_link.keyword_id = eztags.id AND
eztags_attribute_link.objectattribute_id = 861641 AND
eztags_attribute_link.objectattribute_version = 1 |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id IN ( '39', '443' ) ORDER BY keyword ASC |
Variable 'items' is already defined. |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='155' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='339' |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:14134', 'eznode:14176', 'eznode:101264' ) 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, 14134, 14176, 101264 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT eztags.id, eztags.keyword, eztags.parent_id FROM eztags_attribute_link, eztags
WHERE eztags_attribute_link.keyword_id = eztags.id AND
eztags_attribute_link.objectattribute_id = 861596 AND
eztags_attribute_link.objectattribute_version = 1 |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id IN ( '39', '686' ) ORDER BY keyword ASC |
Variable 'items' is already defined. |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='39' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='339' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='339' |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:14134', 'eznode:14176', 'eznode:101254' ) 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, 14134, 14176, 101254 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT eztags.id, eztags.keyword, eztags.parent_id FROM eztags_attribute_link, eztags
WHERE eztags_attribute_link.keyword_id = eztags.id AND
eztags_attribute_link.objectattribute_id = 861529 AND
eztags_attribute_link.objectattribute_version = 2 |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id IN ( '154', '641' ) ORDER BY keyword ASC |
Variable 'items' is already defined. |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='39' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='339' |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:14134', 'eznode:14176', 'eznode:101103' ) 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, 14134, 14176, 101103 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT eztags.id, eztags.keyword, eztags.parent_id FROM eztags_attribute_link, eztags
WHERE eztags_attribute_link.keyword_id = eztags.id AND
eztags_attribute_link.objectattribute_id = 860617 AND
eztags_attribute_link.objectattribute_version = 1 |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id IN ( '39', '154', '551' ) ORDER BY keyword ASC |
Variable 'items' is already defined. |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='339' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='154' |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:14134', 'eznode:14176', 'eznode:101101' ) 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, 14134, 14176, 101101 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 2 )
) |
SELECT eztags.id, eztags.keyword, eztags.parent_id FROM eztags_attribute_link, eztags
WHERE eztags_attribute_link.keyword_id = eztags.id AND
eztags_attribute_link.objectattribute_id = 860596 AND
eztags_attribute_link.objectattribute_version = 1 |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id IN ( '39', '339', '642' ) ORDER BY keyword ASC |
Variable 'items' is already defined. |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='339' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='340' |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
Operator 'tag_cleaner' is not registered |
SELECT ezm_pool.node_id
FROM ezm_pool, ezcontentobject_tree, ezcontentobject
WHERE ezm_pool.block_id='5b10c1b4b0bd3d69a76fc3d35b5e955d'
AND ezm_pool.ts_visible>0
AND ezm_pool.ts_hidden=0
AND ezcontentobject_tree.node_id = ezm_pool.node_id
AND ezcontentobject.id = ezm_pool.object_id
AND
ezcontentobject.language_mask & 9 > 0
AND ezcontentobject_tree.is_invisible = 0
ORDER BY ezm_pool.priority DESC |
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 & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
SELECT eztags.id, eztags.keyword, count(eztags.keyword) AS keyword_count
FROM eztags_attribute_link
LEFT JOIN ezcontentobject_attribute
ON eztags_attribute_link.objectattribute_id = ezcontentobject_attribute.id
AND eztags_attribute_link.objectattribute_version = ezcontentobject_attribute.version
LEFT JOIN ezcontentobject
ON ezcontentobject_attribute.contentobject_id = ezcontentobject.id
LEFT JOIN ezcontentobject_tree
ON ezcontentobject_attribute.contentobject_id = ezcontentobject_tree.contentobject_id
LEFT JOIN eztags
ON eztags.id = eztags_attribute_link.keyword_id
WHERE ezcontentobject.status = 1
AND ezcontentobject_attribute.version = ezcontentobject.current_version
AND ezcontentobject_tree.main_node_id = ezcontentobject_tree.node_id
AND ezcontentobject_tree.path_string like '/1/2/%'
AND ezcontentobject_tree.node_id != 2
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 8) AND ( ( ezcontentobject_tree.path_string like '/1/2/15157/%' ) OR ( ezcontentobject_tree.node_id in (15157) ) )) OR (ezcontentobject.section_id in (1, 8)) OR (ezcontentobject.contentclass_id in (101, 107, 113, 12, 129, 35, 5, 88, 89, 90, 91) AND ezcontentobject.section_id in (3)))
AND
ezcontentobject.language_mask & 9 > 0
AND
ezcontentobject_attribute.language_id & 9 > 0
GROUP BY eztags.id, eztags.keyword
ORDER BY keyword_count DESC
LIMIT 0, 15 |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='39' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='152' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='133' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='32' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='337' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='12' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='50' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='29' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='340' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='154' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='98' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='80' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='83' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='442' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='107' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='337' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='152' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='29' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='133' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='39' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='339' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='107' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='152' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='80' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='32' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='154' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='340' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='12' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='339' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='50' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='83' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='339' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='98' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='340' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='442' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='31' |
SELECT id, parent_id, main_tag_id, keyword, depth, path_string, modified, remote_id
FROM eztags WHERE id='29' |
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 identifier='feedback_form' AND version='0' ORDER BY version ASC
LIMIT 0, 2 |
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='82' ORDER BY id 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 & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 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 ) WHERE ezcontentobject_tree.parent_node_id = 2 and ( ezcontentobject_tree.priority > '1' AND ezcontentobject_tree.node_id IN (60,2) ) AND ezcontentobject.contentclass_id IN ( 1, 82, 1, 82 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 8) AND ( ( ezcontentobject_tree.path_string like '/1/2/15157/%' ) OR ( ezcontentobject_tree.node_id in (15157) ) )) OR (ezcontentobject.section_id in (1, 8)) OR (ezcontentobject.contentclass_id in (101, 107, 113, 12, 129, 35, 5, 88, 89, 90, 91) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 9 > 0
ORDER BY ezcontentobject_name.name DESC |
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 & 9 > 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
) |
Class filter returned false |
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 = 2 and ezcontentobject.contentclass_id IN ( 131 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 8) AND ( ( ezcontentobject_tree.path_string like '/1/2/15157/%' ) OR ( ezcontentobject_tree.node_id in (15157) ) )) OR (ezcontentobject.section_id in (1, 8)) OR (ezcontentobject.contentclass_id in (101, 107, 113, 12, 129, 35, 5, 88, 89, 90, 91) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 9 > 0 |
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 = '70297' AND
ezcontentobject_attribute.language_code = 'eng-US' ) )
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 & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:58895' ) 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, 58895 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 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 ) WHERE ezcontentobject_tree.parent_node_id = 58895 and ezcontentobject.contentclass_id IN ( 131 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 8) AND ( ( ezcontentobject_tree.path_string like '/1/2/15157/%' ) OR ( ezcontentobject_tree.node_id in (15157) ) )) OR (ezcontentobject.section_id in (1, 8)) OR (ezcontentobject.contentclass_id in (101, 107, 113, 12, 129, 35, 5, 88, 89, 90, 91) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 9 > 0 |
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 = '5' AND
ezcontentobject_attribute.contentobject_id = '70426' AND
ezcontentobject_attribute.language_code = 'eng-US' ) )
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 & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:58895', 'eznode:59021' ) 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, 58895, 59021 ) 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 ) ) & 8 ) >> 2 )
<
( con.language_id & 1 )
+ ( ( con.language_id & 8 ) >> 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 ) WHERE ezcontentobject_tree.parent_node_id = 59021 and ezcontentobject.contentclass_id IN ( 131 ) 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 ) ) & 8 ) >> 2 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
)
AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 8) AND ( ( ezcontentobject_tree.path_string like '/1/2/15157/%' ) OR ( ezcontentobject_tree.node_id in (15157) ) )) OR (ezcontentobject.section_id in (1, 8)) OR (ezcontentobject.contentclass_id in (101, 107, 113, 12, 129, 35, 5, 88, 89, 90, 91) AND ezcontentobject.section_id in (3))) AND
ezcontentobject.language_mask & 9 > 0 |
Script end |