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( 'setup-design' ) AND e2.parent = e1.link AND (e2.lang_mask & 3 > 0) AND e2.text_md5 = MD5( 'news' ) 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( 'setup-design' ) AND e2.parent = e1.link AND (e2.lang_mask & 3 > 0) AND e2.text_md5 = MD5( 'news' ) 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 = 45693 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:221', 'eznode:45693' ) 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, 45693 ) 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=45786SELECT 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=45786 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 = 221 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, 221 ) 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: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 name, content_translation FROM ezcontentobject_name WHERE contentobject_id = '45786' AND content_version = '2' AND ( content_translation = 'eng-GB' OR language_id = '2' )SELECT name, content_translation FROM ezcontentobject_name WHERE contentobject_id = '45786' 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 = 45693 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 = 221 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/221/%' and ( ezcontentobject_tree.modified_subnode < '1757171305' ) AND ezcontentobject_tree.node_id != 221 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 = '45794' 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 = 221 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/221/%' and ( ezcontentobject_tree.modified_subnode > '1757171305' ) AND ezcontentobject_tree.node_id != 221 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 = '45804' 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:221', 'eznode:45701' ) 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, 45701 ) 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 = 221 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: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:221', 'eznode:45711' ) 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, 45711 ) 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='11150' 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 = '11150' AND ezcontentobject_version.version = '2' AND ezcontentobject_attribute.contentobject_id = '11150' 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 = '11150' 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='45786' AND ezcontentobject_version.creator_id=ezuser.contentobject_idSELECT node_id FROM ezcontentobject_tree WHERE contentobject_id=45786 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 = 45693 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 = '45786' AND ezcontentobject_version.version = '2' AND ezcontentobject_attribute.contentobject_id = '45786' 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 = 45693 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 = '3' AND ezcontentobject_attribute.contentobject_id = '45787' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '45788' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '45789' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '45790' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '45791' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '45792' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.contentobject_id = '45793' 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='10581' 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 = '10581' AND ezcontentobject_version.version = '3' AND ezcontentobject_attribute.contentobject_id = '10581' AND ezcontentobject_attribute.version = '3' 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 = '10581' AND content_version = '3' 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='45787' 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='45787' 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 name, content_translation FROM ezcontentobject_name WHERE contentobject_id = '11150' AND content_version = '2' 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='45788' 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='45788' AND ezcontentclass.id = ezcontentobject.contentclass_id AND ezcontentclass.version=0SELECT name, content_translation FROM ezcontentobject_name WHERE contentobject_id = '10581' AND content_version = '3' 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='45789' 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='45789' AND ezcontentclass.id = ezcontentobject.contentclass_id AND ezcontentclass.version=0SELECT 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='8973' 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 = '8973' AND ezcontentobject_version.version = '5' AND ezcontentobject_attribute.contentobject_id = '8973' AND ezcontentobject_attribute.version = '5' 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 = '8973' AND content_version = '5' 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='45790' 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='45790' AND ezcontentclass.id = ezcontentobject.contentclass_id AND ezcontentclass.version=0SELECT name, content_translation FROM ezcontentobject_name WHERE contentobject_id = '11150' AND content_version = '2' 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='45791' 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='45791' AND ezcontentclass.id = ezcontentobject.contentclass_id AND ezcontentclass.version=0SELECT name, content_translation FROM ezcontentobject_name WHERE contentobject_id = '11150' AND content_version = '2' 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='45792' 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='45792' AND ezcontentclass.id = ezcontentobject.contentclass_id AND ezcontentclass.version=0SELECT name, content_translation FROM ezcontentobject_name WHERE contentobject_id = '10581' AND content_version = '3' 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='45793' 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='45793' AND ezcontentclass.id = ezcontentobject.contentclass_id AND ezcontentclass.version=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:221', 'eznode:45693' ) 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, 45693 ) 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', 'eznode:45693' ) 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, 45693 ) 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=45786 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 = 45693 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 = 221 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 = 45693 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/221/45693/%' and ezcontentclass.version=0 AND ezcontentobject_tree.node_id != 45693 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 = 45693 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/221/45693/%' and ezcontentclass.version=0 AND ezcontentobject_tree.node_id != 45693 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:221', 'eznode:45693' ) 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, 45693 ) 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 ) ) ) News / Setup & design / Forums - Share Exponential! The Exponential Community
"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".

News

Author Message

Kenneth Grande

Tuesday 26 June 2007 3:37:33 pm

Hi,

I have set up an installation on a demo server, and i am doing some testing. I am currently trying to set up a news layout like they use one www.trav24.no but i am having a hard time figuring things out. Could anyone point me in the right direction on how to accomplish the news setup they are using, with the "read more" link and all.

paul bolger

Tuesday 26 June 2007 4:19:40 pm

Hi Kenneth
You'll have to be a bit more specific about what sort of installation you are using. If you have the website interface installed, or the 'news site' package, you just need to take a look at how the example content is being created.

If you want to do this from scratch take a look at http://ez.no/content/download/48190/124975/file/building.pdf for some ideas on how this could be arranged.

Paul Bolger

Kenneth Grande

Wednesday 27 June 2007 1:22:36 am

I'm running Exponential v.3.9.2

Should i make a frontpage or a folder and publish articles, and make a new template so that the content is displayed the way i want (with two columns and a read more link)? I haven't worked with ez before so im trying to figure out where to start

I could not find the "news site" package you mentioned, but if there is such a thing i would really like to have a look at it. Could you send a link?

paul bolger

Wednesday 27 June 2007 11:18:45 pm

The 'news site' package was from the pre-website interface Exponential. If you have the Frontpage content class available it sounds like you are running the website interface. I think your best bet would be to try and override one of the templates in there (they are all in extensions folder) unless you can get one of the existing ones to do what you want. I'm pretty sure that one of those 'embedded templates', or whatever they call them, has very similar functionality to what you are looking for.

If you do go down the template override road, a couple of tips:

Work out what template you are looking at by using the Template debug and Inline template debug checkboxes in the admin interface. When you are trying to establish whether it is actually working I'd advise replacing the content of the template with "my template" in red h1 or something until you are sure the override is actually operational - a template can work the same as an SSI. Once you do get the override operating properly you'll find a heap of good examples here:

http://ez.no/doc/ez_publish/technical_manual/3_9/reference/modules/content/fetch_functions/list

Limiting the amount of text displayed can be done by using the 'shorten' operator. Here's an example of a template which does something along the lines of what you want. The '435' is the parent node - the node number of the folder the objects are in. The 'strip tags' stuff is because the field is XML and we don't want it chopping html tags in half when it gets to the 80 character limit. We also don't want it trying to include embedded images, which may look a bit ugly!

{*?template charset=utf-8?*}
{def $highlights=fetch( 'content', 'list',
hash( 'parent_node_id', '435',
'sort_by', array( 'priority', true() ),
'limit', '3'
 ))}

{foreach $highlights as $highlight}
<div class="bighighlight">

<div style="width:{$highlight.object.data_map.image.content.data_map.image.content[bighighlights].width}px">
{attribute_view_gui attribute=$highlight.object.data_map.image image_class=bighighlights}
</div>

<h2>{attribute_view_gui attribute=$highlight.data_map.title| shorten(12)}</h2>

{if $highlight.data_map.intro.has_content}
<p>{strip_tags( $highlight.data_map.intro.value.output.output_text ) | wash | shorten(80, '...', right)}
</p>
{/if}

<a href="{$highlight.object.main_node.url_alias}" title="more about {$highlight.data_map.title.content}">more &#187;</a>

Paul Bolger

Łukasz Serwatka

Thursday 28 June 2007 1:11:24 am

Hi,

Bard wrote an article where explains how to build a custom template for a news portal. You may find it useful.

http://ez.no/community/articles/building_a_custom_template_for_a_news_portal

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Kenneth Grande

Thursday 28 June 2007 1:18:08 am

Thank you Paul, that really helped

I got the template override working now, the template debug and template inline debug was a hot tip :)

Kenneth Grande

Thursday 28 June 2007 6:46:18 am

Things are really moving forward :)

Is it possible to apply a template directly to one specific object? I see if i make an override for i.e pagelayout.tpl every page is modified. But i would like to make templates and apply them to specific nodes. I modified the pagelayout to display news, but now i get news on every page on the site. If i could assign a template directly to an object i would not have this problem.

Or perhaps it would be possible to set criterias in the pagelayout template so that it will only display news if it is applied to a certain node, and not when displaying others.

paul bolger

Thursday 28 June 2007 6:55:38 pm

Try something like this, where the node number is the node you want to override. You can also use parent_node, to affect a folder, class_identifier and section.

[frontpagelayout]
Source=pagelayout.tpl
MatchFile=frontpagelayout.tpl
Subdir=templates
Match[node]=373

Paul Bolger