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.action AS e2_action, e2.alias_redirects AS e2_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1, ezurlalias_ml e2 WHERE e0.parent = 0 AND (e0.lang_mask & 3 > 0) AND e0.text_md5 = MD5( 'forums' ) AND e1.parent = e0.link AND (e1.lang_mask & 3 > 0) AND e1.text_md5 = MD5( 'developer' ) AND e2.parent = e1.link AND (e2.lang_mask & 3 > 0) AND e2.text_md5 = MD5( 'problems-with-headings' ) LIMIT 0, 1SELECT 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.action AS e2_action, e2.alias_redirects AS e2_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1, ezurlalias_ml e2 WHERE e0.parent = 0 AND (e0.lang_mask & 3 > 0) AND e0.text_md5 = MD5( 'forums' ) AND e1.parent = e0.link AND (e1.lang_mask & 3 > 0) AND e1.text_md5 = MD5( 'developer' ) AND e2.parent = e1.link AND (e2.lang_mask & 3 > 0) AND e2.text_md5 = MD5( 'problems-with-headings' ) 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 = 68427 AND ezcontentclass.version = 0 AND ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 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 & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222', 'eznode:68427' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 222, 68427 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 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=68522SELECT 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=68522 AND s.id=l.contentobject_state_id AND g.id=s.group_idSELECT 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 = 222 AND ezcontentclass.version = 0 AND ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 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='19' AND version='0' ORDER BY version ASC LIMIT 0, 2SELECT 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, 63, 222 ) 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) ORDER BY path_stringSELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63' ) AND is_original = 1 AND is_alias=0SELECT 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, 63 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 222 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT name, content_translation FROM ezcontentobject_name WHERE contentobject_id = '68522' AND content_version = '2' AND ( content_translation = 'eng-GB' OR language_id = '2' )SELECT name, content_translation FROM ezcontentobject_name WHERE contentobject_id = '68522' AND content_version = '2' AND ( content_translation = 'eng-GB' OR language_id = '2' )SELECT count( DISTINCT ezcontentobject_tree.node_id ) as count 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 ezcontentobject_tree.parent_node_id = 68427 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0SELECT 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 = 222 AND ezcontentclass.version = 0 AND ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) )SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.path_string like '/1/2/63/222/%' and ( ezcontentobject_tree.modified_subnode < '1757288117' ) AND ezcontentobject_tree.node_id != 222 AND ezcontentobject.contentclass_id IN ( 20 ) 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0 ORDER BY modified_subnode DESC, ezcontentobject_tree.node_id DESC LIMIT 0, 1SELECT 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 = '2' AND ezcontentobject_attribute.contentobject_id = '68524' AND ezcontentobject_attribute.language_code = 'eng-GB' ) ) ORDER BY ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASCSELECT 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 = 222 AND ezcontentclass.version = 0 AND ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) )SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.path_string like '/1/2/63/222/%' and ( ezcontentobject_tree.modified_subnode > '1757288117' ) AND ezcontentobject_tree.node_id != 222 AND ezcontentobject.contentclass_id IN ( 20 ) 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0 ORDER BY modified_subnode ASC, ezcontentobject_tree.node_id ASC LIMIT 0, 1SELECT 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 = '2' AND ezcontentobject_attribute.contentobject_id = '68518' AND ezcontentobject_attribute.language_code = 'eng-GB' ) ) ORDER BY ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASCSELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222', 'eznode:68429' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 222, 68429 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 222 AND ezcontentclass.version = 0 AND ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 222 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222', 'eznode:68423' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 222, 68423 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT ezcontentobject.*, ezcontentclass.serialized_name_list as serialized_name_list, ezcontentclass.identifier as contentclass_identifier, ezcontentclass.is_container as is_container FROM ezcontentobject, ezcontentclass WHERE ezcontentobject.id='8259' AND ezcontentclass.id = ezcontentobject.contentclass_id AND ezcontentclass.version=0SELECT 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 = '8259' AND ezcontentobject_version.version = '2' AND ezcontentobject_attribute.contentobject_id = '8259' AND ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.language_code = 'eng-GB' ORDER BY ezcontentclass_attribute.placement ASC, ezcontentobject_attribute.language_code ASCSELECT name, content_translation FROM ezcontentobject_name WHERE contentobject_id = '8259' AND content_version = '2' AND ( content_translation = 'eng-GB' OR language_id = '3' )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='180' AND version='0'SELECT DISTINCT ezuser.contentobject_id, ezuser.login, ezuser.email, ezuser.password_hash, ezuser.password_hash_type FROM ezcontentobject_version, ezuser where ezcontentobject_version.contentobject_id='68522' AND ezcontentobject_version.creator_id=ezuser.contentobject_idSELECT node_id FROM ezcontentobject_tree WHERE contentobject_id=68522 AND main_node_id = node_idSELECT 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 = 68427 AND ezcontentclass.version = 0 AND ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 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 = '68522' AND ezcontentobject_version.version = '2' AND ezcontentobject_attribute.contentobject_id = '68522' AND ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.language_code = 'eng-GB' ORDER BY ezcontentclass_attribute.placement ASC, ezcontentobject_attribute.language_code ASCSELECT 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='250' AND version='0'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 = 68427 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0 ORDER BY ezcontentobject.published ASC LIMIT 0, 19SELECT 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 = '2' AND ezcontentobject_attribute.contentobject_id = '68523' AND ezcontentobject_attribute.language_code = 'eng-GB' ) ) ORDER BY ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASCSELECT 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='7252' AND ezcontentclass.id = ezcontentobject.contentclass_id AND ezcontentclass.version=0SELECT 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 = '7252' AND ezcontentobject_version.version = '17' AND ezcontentobject_attribute.contentobject_id = '7252' AND ezcontentobject_attribute.version = '17' AND ezcontentobject_attribute.language_code = 'eng-GB' ORDER BY ezcontentclass_attribute.placement ASC, ezcontentobject_attribute.language_code ASCSELECT name, content_translation FROM ezcontentobject_name WHERE contentobject_id = '7252' AND content_version = '17' AND ( content_translation = 'eng-GB' OR language_id = '3' )SELECT DISTINCT ezuser.contentobject_id, ezuser.login, ezuser.email, ezuser.password_hash, ezuser.password_hash_type FROM ezcontentobject_version, ezuser where ezcontentobject_version.contentobject_id='68523' AND ezcontentobject_version.creator_id=ezuser.contentobject_idSELECT 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='68523' AND ezcontentclass.id = ezcontentobject.contentclass_id AND ezcontentclass.version=0SELECT 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='249' AND version='0'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222', 'eznode:68427' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 222, 68427 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222', 'eznode:68427' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 222, 68427 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 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=68522 AND s.id=l.contentobject_state_id AND g.id=s.group_idSELECT id, session_id, productcollection_id, order_id FROM ezbasket WHERE session_id=''SELECT id, productcollection_id, contentobject_id, item_count, price, is_vat_inc, vat_value, discount, name FROM ezproductcollection_item WHERE productcollection_id='0' ORDER BY contentobject_id DESCSELECT id, section_id, owner_id, contentclass_id, name, published, modified, current_version, status, remote_id, language_mask, initial_language_id FROM ezcontentobject WHERE contentclass_id='15' ORDER BY id ASC LIMIT 0, 1SELECT 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 = 68427 AND ezcontentclass.version = 0 AND ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) )SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 222 AND ezcontentclass.version = 0 AND ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) )SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 68427 AND ezcontentclass.version = 0 AND ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) )SELECT count( DISTINCT ezcontentobject_tree.node_id ) as count 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 ezcontentobject_tree.path_string like '/1/2/63/222/68427/%' and ezcontentclass.version=0 AND ezcontentobject_tree.node_id != 68427 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0SELECT 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 = 68427 AND ezcontentclass.version = 0 AND ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) )SELECT count( DISTINCT ezcontentobject_tree.node_id ) as count 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 ezcontentobject_tree.path_string like '/1/2/63/222/68427/%' and ezcontentclass.version=0 AND ezcontentobject_tree.node_id != 68427 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222', 'eznode:68427' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 222, 68427 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 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 = '54' AND ezcontentobject_version.version = '5' AND ezcontentobject_attribute.contentobject_id = '54' AND ezcontentobject_attribute.version = '5' AND ezcontentobject_attribute.language_code = 'eng-GB' ORDER BY ezcontentclass_attribute.placement ASC, ezcontentobject_attribute.language_code ASCSELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category FROM ezcontentclass_attribute WHERE id='174' AND version='0'SELECT ezcontentobject.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 & 3 > 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) )SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 2 and ezcontentobject.contentclass_id IN ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0 ORDER BY ezcontentobject_tree.priority DESCSELECT 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 = '55' AND ezcontentobject_attribute.contentobject_id = '217' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '118923' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '192' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '5' AND ezcontentobject_attribute.contentobject_id = '88' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '156' AND ezcontentobject_attribute.contentobject_id = '97561' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '7' AND ezcontentobject_attribute.contentobject_id = '63' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '8' AND ezcontentobject_attribute.contentobject_id = '114854' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '6980' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '118478' AND ezcontentobject_attribute.language_code = 'eng-GB' ) ) ORDER BY ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASCSELECT 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 = 110423 and ezcontentobject.contentclass_id IN ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0 ORDER BY ezcontentobject_tree.priority DESC LIMIT 0, 14SELECT 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 = '22' AND ezcontentobject_attribute.contentobject_id = '113536' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '27' AND ezcontentobject_attribute.contentobject_id = '113537' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '4' AND ezcontentobject_attribute.contentobject_id = '113538' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '4' AND ezcontentobject_attribute.contentobject_id = '113539' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '9' AND ezcontentobject_attribute.contentobject_id = '113540' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '5' AND ezcontentobject_attribute.contentobject_id = '113543' AND ezcontentobject_attribute.language_code = 'eng-GB' ) ) ORDER BY ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASCSELECT count( DISTINCT ezcontentobject_tree.node_id ) as count 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 ezcontentobject_tree.parent_node_id = 110423 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:110423' ) AND is_original = 1 AND is_alias=0SELECT 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, 110423 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:110423', 'eznode:110425' ) AND is_original = 1 AND is_alias=0SELECT 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, 110423, 110425 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:110423', 'eznode:110426' ) AND is_original = 1 AND is_alias=0SELECT 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, 110423, 110426 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:110423', 'eznode:110427' ) AND is_original = 1 AND is_alias=0SELECT 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, 110423, 110427 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:110423', 'eznode:110428' ) AND is_original = 1 AND is_alias=0SELECT 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, 110423, 110428 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:110423', 'eznode:110429' ) AND is_original = 1 AND is_alias=0SELECT 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, 110423, 110429 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:110423', 'eznode:110431' ) AND is_original = 1 AND is_alias=0SELECT 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, 110423, 110431 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 114049 and ezcontentobject.contentclass_id IN ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0 ORDER BY ezcontentobject_tree.priority DESC LIMIT 0, 14SELECT 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 = '2' AND ezcontentobject_attribute.contentobject_id = '119003' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '192409' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '191595' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '191598' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.contentobject_id = '191597' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.contentobject_id = '176867' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.contentobject_id = '176865' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '4' AND ezcontentobject_attribute.contentobject_id = '119002' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '192453' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '192413' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '192414' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '89833' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '192374' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '192454' AND ezcontentobject_attribute.language_code = 'eng-GB' ) ) ORDER BY ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASCSELECT count( DISTINCT ezcontentobject_tree.node_id ) as count 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 ezcontentobject_tree.parent_node_id = 114049 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0SELECT url, is_valid FROM ezurl WHERE id='7185'SELECT url, is_valid FROM ezurl WHERE id='7195'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114080' ) AND is_original = 1 AND is_alias=0SELECT 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, 114049, 114080 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='7251'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114208' ) AND is_original = 1 AND is_alias=0SELECT 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, 114049, 114208 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='7196'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114179' ) AND is_original = 1 AND is_alias=0SELECT 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, 114049, 114179 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='7197'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114181' ) AND is_original = 1 AND is_alias=0SELECT 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, 114049, 114181 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='7198'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114180' ) AND is_original = 1 AND is_alias=0SELECT 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, 114049, 114180 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='7190'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114150' ) AND is_original = 1 AND is_alias=0SELECT 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, 114049, 114150 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='7199'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114149' ) AND is_original = 1 AND is_alias=0SELECT 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, 114049, 114149 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='7200'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114079' ) AND is_original = 1 AND is_alias=0SELECT 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, 114049, 114079 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='7308'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114221' ) AND is_original = 1 AND is_alias=0SELECT 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, 114049, 114221 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='7255'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114209' ) AND is_original = 1 AND is_alias=0SELECT 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, 114049, 114209 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='7256'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114210' ) AND is_original = 1 AND is_alias=0SELECT 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, 114049, 114210 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:89419' ) AND is_original = 1 AND is_alias=0SELECT 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, 114049, 89419 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114196' ) AND is_original = 1 AND is_alias=0SELECT 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, 114049, 114196 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='7310'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114222' ) AND is_original = 1 AND is_alias=0SELECT 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, 114049, 114222 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 66 and ezcontentobject.contentclass_id IN ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0 ORDER BY ezcontentobject_tree.priority DESC LIMIT 0, 14SELECT 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 = '2' AND ezcontentobject_attribute.contentobject_id = '118409' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.contentobject_id = '113154' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.contentobject_id = '88498' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.contentobject_id = '118938' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '114821' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '103420' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '86806' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '88622' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '110335' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '98118' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '98121' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '103201' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '103206' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '103211' AND ezcontentobject_attribute.language_code = 'eng-GB' ) ) ORDER BY ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASCSELECT count( DISTINCT ezcontentobject_tree.node_id ) as count 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 ezcontentobject_tree.parent_node_id = 66 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66' ) AND is_original = 1 AND is_alias=0SELECT 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, 66 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:113930' ) AND is_original = 1 AND is_alias=0SELECT 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, 66, 113930 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:110086' ) AND is_original = 1 AND is_alias=0SELECT 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, 66, 110086 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:88232' ) AND is_original = 1 AND is_alias=0SELECT 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, 66, 88232 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:114052' ) AND is_original = 1 AND is_alias=0SELECT 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, 66, 114052 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:111486' ) AND is_original = 1 AND is_alias=0SELECT 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, 66, 111486 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:101828' ) AND is_original = 1 AND is_alias=0SELECT 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, 66, 101828 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:86692' ) AND is_original = 1 AND is_alias=0SELECT 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, 66, 86692 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:88330' ) AND is_original = 1 AND is_alias=0SELECT 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, 66, 88330 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:107637' ) AND is_original = 1 AND is_alias=0SELECT 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, 66, 107637 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:96848' ) AND is_original = 1 AND is_alias=0SELECT 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, 66, 96848 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:96850' ) AND is_original = 1 AND is_alias=0SELECT 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, 66, 96850 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:101628' ) AND is_original = 1 AND is_alias=0SELECT 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, 66, 101628 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:101632' ) AND is_original = 1 AND is_alias=0SELECT 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, 66, 101632 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:101636' ) AND is_original = 1 AND is_alias=0SELECT 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, 66, 101636 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 63 and ezcontentobject.contentclass_id IN ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0 ORDER BY ezcontentobject_tree.priority DESC LIMIT 0, 14SELECT 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 = '3' AND ezcontentobject_attribute.contentobject_id = '247' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '245' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '243' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '66' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '242' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '4' AND ezcontentobject_attribute.contentobject_id = '68' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '91826' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.contentobject_id = '118549' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '118968' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '246' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.contentobject_id = '93288' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.contentobject_id = '86790' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '190046' AND ezcontentobject_attribute.language_code = 'eng-GB' ) ) ORDER BY ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASCSELECT count( DISTINCT ezcontentobject_tree.node_id ) as count 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 ezcontentobject_tree.parent_node_id = 63 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63' ) AND is_original = 1 AND is_alias=0SELECT 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, 63 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:226' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 226 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:224' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 224 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 222 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:67' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 67 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:221' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 221 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:68' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 68 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:91174' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 91174 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:113988' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 113988 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:114072' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 114072 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:225' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 225 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:92511' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 92511 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:86676' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 86676 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:114168' ) AND is_original = 1 AND is_alias=0SELECT 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, 63, 114168 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 64 and ezcontentobject.contentclass_id IN ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0 ORDER BY ezcontentobject_tree.priority DESC LIMIT 0, 14SELECT 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 = '21' AND ezcontentobject_attribute.contentobject_id = '94995' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '4' AND ezcontentobject_attribute.contentobject_id = '226' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.contentobject_id = '118956' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.contentobject_id = '118955' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '104227' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '118893' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '118952' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.contentobject_id = '118954' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '4' AND ezcontentobject_attribute.contentobject_id = '170717' AND ezcontentobject_attribute.language_code = 'eng-GB' ) ) ORDER BY ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASCSELECT count( DISTINCT ezcontentobject_tree.node_id ) as count 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 ezcontentobject_tree.parent_node_id = 64 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64' ) AND is_original = 1 AND is_alias=0SELECT 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, 64 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:94016' ) AND is_original = 1 AND is_alias=0SELECT 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, 64, 94016 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:205' ) AND is_original = 1 AND is_alias=0SELECT 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, 64, 205 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='7202'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:114069' ) AND is_original = 1 AND is_alias=0SELECT 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, 64, 114069 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='7195'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:114068' ) AND is_original = 1 AND is_alias=0SELECT 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, 64, 114068 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:102515' ) AND is_original = 1 AND is_alias=0SELECT 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, 64, 102515 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:114044' ) AND is_original = 1 AND is_alias=0SELECT 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, 64, 114044 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:114065' ) AND is_original = 1 AND is_alias=0SELECT 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, 64, 114065 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='7200'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:114067' ) AND is_original = 1 AND is_alias=0SELECT 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, 64, 114067 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:114121' ) AND is_original = 1 AND is_alias=0SELECT 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, 64, 114121 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 111516 and ezcontentobject.contentclass_id IN ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0 ORDER BY ezcontentobject_tree.priority DESC LIMIT 0, 14SELECT count( DISTINCT ezcontentobject_tree.node_id ) as count 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 ezcontentobject_tree.parent_node_id = 111516 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:111516' ) AND is_original = 1 AND is_alias=0SELECT 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, 111516 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 6913 and ezcontentobject.contentclass_id IN ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0 ORDER BY ezcontentobject_tree.priority DESC LIMIT 0, 14SELECT 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 = '2' AND ezcontentobject_attribute.contentobject_id = '6982' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '21' AND ezcontentobject_attribute.contentobject_id = '118947' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '6981' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '192324' AND ezcontentobject_attribute.language_code = 'eng-GB' ) ) ORDER BY ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASCSELECT count( DISTINCT ezcontentobject_tree.node_id ) as count 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 ezcontentobject_tree.parent_node_id = 6913 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:6913' ) AND is_original = 1 AND is_alias=0SELECT 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, 6913 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:6913', 'eznode:6915' ) AND is_original = 1 AND is_alias=0SELECT 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, 6913, 6915 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:6913', 'eznode:114060' ) AND is_original = 1 AND is_alias=0SELECT 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, 6913, 114060 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:6913', 'eznode:6914' ) AND is_original = 1 AND is_alias=0SELECT 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, 6913, 6914 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:6913', 'eznode:114191' ) AND is_original = 1 AND is_alias=0SELECT 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, 6913, 114191 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON ( ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version ) WHERE ezcontentobject_tree.parent_node_id = 113961 and ezcontentobject.contentclass_id IN ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0 ORDER BY ezcontentobject_tree.priority DESC LIMIT 0, 14SELECT 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 = '118415' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '190602' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '118392' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '118996' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.contentobject_id = '118496' AND ezcontentobject_attribute.language_code = 'eng-GB' ) ) ORDER BY ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASCSELECT count( DISTINCT ezcontentobject_tree.node_id ) as count 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 ezcontentobject_tree.parent_node_id = 113961 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 ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:113961' ) AND is_original = 1 AND is_alias=0SELECT 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, 113961 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='7106'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:113961', 'eznode:114176' ) AND is_original = 1 AND is_alias=0SELECT 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, 113961, 114176 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='6642'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:113961', 'eznode:113913' ) AND is_original = 1 AND is_alias=0SELECT 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, 113961, 113913 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='6842'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:113961', 'eznode:114075' ) AND is_original = 1 AND is_alias=0SELECT 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, 113961, 114075 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) )SELECT url, is_valid FROM ezurl WHERE id='6672'SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:113961', 'eznode:113970' ) AND is_original = 1 AND is_alias=0SELECT 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, 113961, 113970 ) 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 ) ) & 2 ) ) < ( con.language_id & 1 ) + ( ( con.language_id & 2 ) ) ) Problems with headings / Developer / Forums - Share Exponential! The Exponential Community

Forums / Developer / Problems with headings

"Please Note:
  • At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
  • This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

Problems with headings

« 
Previous topic
|
Developer
|
Next topic
 »
Author Message

K259

Tuesday 17 August 2004 12:27:41 am

One of our users tries to update some headings in eZ, but it seems like the system change what he has chosen. He wants to have H1,H2,H2,H1,H3,H2, but first with H3 the system accepts it.

What's the deal with headings in eZ?

Ole Morten Halvorsen

Tuesday 17 August 2004 12:56:00 am

See the reply from Paul B. in this thread: http://www.ez.no/community/forum/general/ez_editor_header_bug

It's the same "problem".

Ole M.

Senior Software Engineer - Vision with Technology

http://www.visionwt.com
http://www.omh.cc
http://www.twitter.com/omh

eZ Certified Developer
http://ez.no/certification/verify/358441
http://ez.no/certification/verify/272578