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( 'general' ) AND e2.parent = e1.link AND (e2.lang_mask & 3 > 0) AND e2.text_md5 = MD5( 'call-for-papers-exponential-conference-due-jan-16' ) 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( 'general' ) AND e2.parent = e1.link AND (e2.lang_mask & 3 > 0) AND e2.text_md5 = MD5( 'call-for-papers-exponential-conference-due-jan-16' ) 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 = 56892 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:226', 'eznode:56892' ) 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, 56892 ) 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=56986SELECT 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=56986 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 = 226 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, 226 ) 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: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 name, content_translation FROM ezcontentobject_name WHERE contentobject_id = '56986' AND content_version = '2' AND ( content_translation = 'eng-GB' OR language_id = '2' )SELECT name, content_translation FROM ezcontentobject_name WHERE contentobject_id = '56986' 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 = 56892 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 = 226 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/226/%' and ( ezcontentobject_tree.modified_subnode < '1757281453' ) AND ezcontentobject_tree.node_id != 226 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 = '56990' 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 = 226 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/226/%' and ( ezcontentobject_tree.modified_subnode > '1757281453' ) AND ezcontentobject_tree.node_id != 226 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 = '56975' 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:226', 'eznode:56896' ) 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, 56896 ) 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 = 226 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: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:226', 'eznode:56881' ) 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, 56881 ) 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='9088' 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 = '9088' AND ezcontentobject_version.version = '2' AND ezcontentobject_attribute.contentobject_id = '9088' 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 = '9088' 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='56986' AND ezcontentobject_version.creator_id=ezuser.contentobject_idSELECT node_id FROM ezcontentobject_tree WHERE contentobject_id=56986 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 = 56892 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 = '56986' AND ezcontentobject_version.version = '2' AND ezcontentobject_attribute.contentobject_id = '56986' 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 = 56892 and ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 ) + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) ) < ( ezcontentobject_name.language_id & 1 ) + ( ( ezcontentobject_name.language_id & 2 ) ) ) AND ezcontentobject_tree.is_invisible = 0 AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) AND ezcontentobject.language_mask & 3 > 0 ORDER BY ezcontentobject.published ASC LIMIT 0, 19SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM ezcontentobject_attribute, ezcontentclass_attribute WHERE ezcontentclass_attribute.version = '0' AND ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND ( ( ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.contentobject_id = '56987' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.contentobject_id = '56988' AND ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '2' AND ezcontentobject_attribute.contentobject_id = '56989' 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='7007' 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 = '7007' AND ezcontentobject_version.version = '10' AND ezcontentobject_attribute.contentobject_id = '7007' AND ezcontentobject_attribute.version = '10' 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 = '7007' AND content_version = '10' 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='56987' 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='56987' 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 = '9088' 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='56988' 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='56988' 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='7388' 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 = '7388' AND ezcontentobject_version.version = '21' AND ezcontentobject_attribute.contentobject_id = '7388' AND ezcontentobject_attribute.version = '21' 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 = '7388' AND content_version = '21' 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='56989' 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='56989' 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:226', 'eznode:56892' ) 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, 56892 ) 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', 'eznode:56892' ) 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, 56892 ) 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=56986 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 = 56892 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 = 226 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 = 56892 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/226/56892/%' and ezcontentclass.version=0 AND ezcontentobject_tree.node_id != 56892 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 = 56892 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/226/56892/%' and ezcontentclass.version=0 AND ezcontentobject_tree.node_id != 56892 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:226', 'eznode:56892' ) 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, 56892 ) 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 ) ) ) Call for Papers: Exponential Conference (due Jan 16) / General / Forums - Share Exponential! The Exponential Community

Forums / General / Call for Papers: Exponential Conference (due Jan 16)

"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".

Call for Papers: Exponential Conference (due Jan 16)

« 
Previous topic
|
General
|
Next topic
 »
Author Message

Sandro Groganz

Wednesday 11 January 2006 10:02:25 am

Hi,

for those of you interested in doing eZ-related presentations:

The Exponential Conference Call for Papers will close soon, namely Jan 16th.

So, hurry up and check out this page for more information: http://ez.no/company/events/ez_publish_conference_2006/call_for_papers

Hope to see you there!
Sandro

Sandro Groganz
Chief Knowledge Officer

Paul Borgermans

Wednesday 11 January 2006 2:12:27 pm

Expect one or maybe two proposals from us (K&P) on friday: a case study and maybe a tutorial for (advanced) ezp developers if there is interest for this.

--paul

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans

Sandro Groganz

Wednesday 11 January 2006 11:17:52 pm

Sounds good!

Sandro Groganz
Chief Knowledge Officer

Tony Wood

Tuesday 17 January 2006 4:19:40 am

Expect one or two from VisionWT. We are a bit stacked with work at the moment so will be the end of this week.

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future