Script start

SELECT e0.id AS e0_id, e0.link AS e0_link, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.is_alias AS e0_is_alias, e0.alias_redirects AS e0_alias_redirects, e1.id AS e1_id, e1.link AS e1_link, e1.text AS e1_text, e1.text_md5 AS e1_text_md5, e1.is_alias AS e1_is_alias, e1.alias_redirects AS e1_alias_redirects, e2.id AS e2_id, e2.link AS e2_link, e2.text AS e2_text, e2.text_md5 AS e2_text_md5, e2.is_alias AS e2_is_alias, e2.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 & 5 > 0) AND e0.text_md5 =  MD5( 'user' )  AND e1.parent = e0.link AND (e1.lang_mask & 5 > 0) AND e1.text_md5 =  MD5( 'register' )  AND e2.parent = e1.link AND (e2.lang_mask & 5 > 0) AND e2.text_md5 =  MD5( '2' ) 
LIMIT 0, 1

Module start 'user'

BEGIN WORK

SELECT count(*) as count FROM ezcontentobject_tree WHERE node_id = 12

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='4' AND version='0' ORDER BY version ASC
LIMIT 0, 2

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 12 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

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  contentclass_id='4' AND version='0' ORDER BY placement ASC

INSERT INTO ezcontentobject (section_id, owner_id, contentclass_id, name, published, modified, current_version, status, remote_id, language_mask, initial_language_id) VALUES(2, 14, 4, 'New ', 0, 0, 1, 0, 'a616a0e0eeba4311778b97d0e6a3e4a4', 5, 4)

SELECT id, group_id, identifier, language_mask, default_language_id, priority
                    FROM   ezcobj_state WHERE  priority='0' ORDER BY group_id ASC, priority ASC

INSERT INTO ezcobj_state_link (contentobject_state_id, contentobject_id)
                         VALUES(1, 1563)

SELECT COUNT(*) AS count FROM ezcontentobject_name WHERE contentobject_id = '1563'
                                 AND content_version = '1' AND content_translation ='eng-GB'

INSERT INTO ezcontentobject_name( contentobject_id,
                                                           name,
                                                           content_version,
                                                           content_translation,
                                                           real_translation,
                                                           language_id )
                                VALUES( '1563',
                                        'New ',
                                        '1',
                                        'eng-GB',
                                        'eng-GB',
                                        '4' )

INSERT INTO ezcontentobject_version (contentobject_id, creator_id, version, status, created, modified, workflow_event_pos, user_id, language_mask, initial_language_id) VALUES(1563, 14, 1, 5, 1792898410, 1792898410, 0, 0, 4, 4)

INSERT INTO ezcontentobject_attribute (contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(1563, 1, 'eng-GB', 4, 24, 0, 0, '', 'ezstring', '', NULL, 0.000000)

INSERT INTO ezcontentobject_attribute (contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(1563, 1, 'eng-GB', 4, 25, 0, 0, '', 'ezstring', '', NULL, 0.000000)

SELECT contentobject_id, login, email, password_hash, password_hash_type
                    FROM   ezuser WHERE  contentobject_id='1563'

SELECT contentobject_id, login, email, password_hash, password_hash_type
                    FROM   ezuser WHERE  contentobject_id='1563'

SELECT user_id
                    FROM   ezuser_setting WHERE  user_id='1563'

INSERT INTO ezuser_setting (user_id, is_enabled, max_login) VALUES(1563, 1, 0)

SELECT contentobject_id
                    FROM   ezuser WHERE  contentobject_id='1563'

INSERT INTO ezuser (contentobject_id, login, email, password_hash, password_hash_type) VALUES(1563, '', '', '', 1)

INSERT INTO ezcontentobject_attribute (contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(1563, 1, 'eng-GB', 4, 26, 0, 0, '', 'ezuser', '', NULL, 0.000000)

INSERT INTO ezcontentobject_attribute (contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(1563, 1, 'eng-GB', 4, 259, 0, 0, '', 'ezstring', '', NULL, 0.000000)

INSERT INTO ezcontentobject_attribute (contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(1563, 1, 'eng-GB', 4, 260, 0, 0, '', 'eztext', '', NULL, 0.000000)

INSERT INTO ezcontentobject_attribute (contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(1563, 1, 'eng-GB', 4, 261, 0, 0, '', 'ezcountry', '', NULL, 0.000000)

INSERT INTO ezcontentobject_attribute (contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(1563, 1, 'eng-GB', 4, 262, 0, 0, '', 'ezstring', '', NULL, 0.000000)

INSERT INTO ezcontentobject_attribute (contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(1563, 1, 'eng-GB', 4, 263, 0, 0, '', 'ezboolean', '', 0, 0.000000)

INSERT INTO ezcontentobject_attribute (contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(1563, 1, 'eng-GB', 4, 264, 0, 0, '', 'ezboolean', '', 0, 0.000000)

INSERT INTO ezcontentobject_attribute (contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(1563, 1, 'eng-GB', 4, 275, 0, 0, '', 'ezstring', '', NULL, 0.000000)

INSERT INTO eznode_assignment (remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order, is_main, from_node_id, parent_remote_id, is_hidden, priority, op_code) VALUES('0', 1563, 1, 12, 2, 0, 1, 0, 'e790cb299835a30f9d71bc9961d80115', 0, 0, 3)

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='1563' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.version=0

SELECT id, contentobject_id, creator_id, version, status, created, modified,       workflow_event_pos, user_id, language_mask, initial_language_id
                    FROM   ezcontentobject_version WHERE  version='1' AND contentobject_id='1563' ORDER BY version ASC

SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as classattribute_identifier,
                        ezcontentclass_attribute.can_translate, ezcontentclass_attribute.serialized_name_list as attribute_serialized_name_list
                  FROM  ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1563' AND
                    ezcontentobject_version.contentobject_id = '1563' AND
                    ezcontentobject_version.version = '1' AND ezcontentobject_attribute.language_code = 'eng-GB' ORDER by
                    ezcontentclass_attribute.placement ASC

SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,       is_main, from_node_id, parent_remote_id, is_hidden, priority, op_code
                    FROM   eznode_assignment WHERE  contentobject_id='1563' AND contentobject_version='1'

SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.name, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) WHERE contentobject_id = 1563 ORDER BY path_string

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '1563'
                       AND content_version = '1'
                       AND ( content_translation = 'eng-GB' OR language_id = '5' )

SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,       is_main, from_node_id, parent_remote_id, is_hidden, priority, op_code
                    FROM   eznode_assignment WHERE  contentobject_id='1563' AND contentobject_version='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 = 12 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

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='3' AND version='0' ORDER BY version ASC
LIMIT 0, 2

eZTemplate: Loading template "user/register.tpl" with resource "design"

eZTemplate: Loading template "content/datatype/edit/ezstring.tpl" with resource "design"

eZTemplate: Loading template "content/datatype/edit/ezstring.tpl" with resource "design"

eZTemplate: Loading template "content/datatype/edit/ezuser.tpl" with resource "design"

SELECT contentobject_id, login, email, password_hash, password_hash_type
                    FROM   ezuser WHERE  contentobject_id='1563'

SELECT * FROM ezuser WHERE contentobject_id='1563' AND LENGTH( login ) > 0

SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
                    ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ezcontentobject_version.contentobject_id = '1563' AND
                    ezcontentobject_version.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1563' AND                    ezcontentobject_attribute.version = '1' AND                    
 ( ezcontentobject_attribute.language_id & ezcontentobject_version.language_mask > 0 AND
     ( (   ezcontentobject_version.language_mask - ( ezcontentobject_version.language_mask & ezcontentobject_attribute.language_id ) ) & 1 )
   + ( ( ( ezcontentobject_version.language_mask - ( ezcontentobject_version.language_mask & ezcontentobject_attribute.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_attribute.language_id & 1 )
   + ( ( ezcontentobject_attribute.language_id & 4 ) >> 1 )
 ) 
 
                  
                  ORDER BY
                    ezcontentclass_attribute.placement ASC,
                    ezcontentobject_attribute.language_code ASC

SELECT
                    parent_node_id, contentobject_id
                  FROM
                    ezcontentobject_tree
                  WHERE contentobject_id IN ( 1563 ) AND node_id = main_node_id

SELECT * FROM ezuser WHERE contentobject_id='1563' AND LENGTH( login ) > 0

SELECT * FROM ezuser WHERE contentobject_id='1563' AND LENGTH( login ) > 0

eZTemplate: Loading template "content/datatype/edit/ezstring.tpl" with resource "design"

eZTemplate: Loading template "content/datatype/edit/eztext.tpl" with resource "design"

eZTemplate: Loading template "content/datatype/edit/ezcountry.tpl" with resource "design"

eZTemplate: Loading template "content/datatype/edit/ezstring.tpl" with resource "design"

eZTemplate: Loading template "content/datatype/edit/ezboolean.tpl" with resource "design"

eZTemplate: Loading template "content/datatype/edit/ezboolean.tpl" with resource "design"

eZTemplate: Loading template "content/datatype/edit/ezstring.tpl" with resource "design"

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 & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

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 = '1' AND
                    ezcontentobject_version.version = '13' AND
                    ezcontentobject_attribute.contentobject_id = '1' AND                    ezcontentobject_attribute.version = '13' AND                    ezcontentobject_attribute.language_code = 'nor-NO' 
                  
                  ORDER BY
                    ezcontentclass_attribute.placement ASC,
                    ezcontentobject_attribute.language_code ASC

SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND     ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 12 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 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, 5 ) and  ezcontentclass.version = 0 AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 ) 
 ORDER BY path_string

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:5' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 5 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:5', 'eznode:12' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 5, 12 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '1563'
                       AND content_version = '1'
                       AND ( content_translation = 'eng-GB' OR language_id = '5' )

SELECT node_id
                  FROM ezcontentobject_tree
                  WHERE contentobject_id=1563 AND
                  main_node_id = node_id

SELECT id, name, navigation_part_identifier, locale, identifier
                    FROM   ezsection WHERE  id='2'

COMMIT

Module end 'user'

eZTemplate: Loading template "pagelayout.tpl" with resource "design"

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='10' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.version=0

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=25 LIMIT 1

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=30 LIMIT 1

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=23 LIMIT 1

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=70 LIMIT 1

SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )   , ezcontentobject_attribute oa  WHERE ezcontentobject_tree.parent_node_id = 2 and ezcontentobject.contentclass_id IN ( 1, 2, 27, 25, 30, 23, 51, 20, 70 ) AND oa.contentobject_id=ezcontentobject.id AND oa.version=ezcontentobject.current_version AND oa.contentclassattribute_id IN (45, 73, 36, 257, 17, 28, 165, 127, 255) AND 
 ( oa.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & oa.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & oa.language_id ) ) & 4 ) >> 1 )
   <
     ( oa.language_id & 1 )
   + ( ( oa.language_id & 4 ) >> 1 )
 ) 
 AND (oa.contentclassattribute_id IN (45, 73, 36, 257) OR (oa.contentclassattribute_id=17 && data_int=1) OR (oa.contentclassattribute_id=28 && data_int=1) OR (oa.contentclassattribute_id=165 && data_int=1) OR (oa.contentclassattribute_id=127 && data_int=1) OR (oa.contentclassattribute_id=255 && data_int=1)) AND                               ( ezcontentobject_tree.priority >= '1000'  ) AND     
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1)) OR (( ( ezcontentobject_tree.path_string like '/1/43/52/%' ) )))   AND 
 ezcontentobject.language_mask & 5 > 0 
  ORDER BY ezcontentobject_tree.priority ASC

SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND     ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=25 LIMIT 1

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=30 LIMIT 1

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=23 LIMIT 1

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=70 LIMIT 1

SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )   , ezcontentobject_attribute oa  WHERE ezcontentobject_tree.parent_node_id = 2 and ezcontentobject.contentclass_id IN ( 1, 2, 27, 25, 30, 23, 51, 20, 70 ) AND oa.contentobject_id=ezcontentobject.id AND oa.version=ezcontentobject.current_version AND oa.contentclassattribute_id IN (45, 73, 36, 257, 17, 28, 165, 127, 255) AND 
 ( oa.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & oa.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & oa.language_id ) ) & 4 ) >> 1 )
   <
     ( oa.language_id & 1 )
   + ( ( oa.language_id & 4 ) >> 1 )
 ) 
 AND (oa.contentclassattribute_id IN (45, 73, 36, 257) OR (oa.contentclassattribute_id=17 && data_int=1) OR (oa.contentclassattribute_id=28 && data_int=1) OR (oa.contentclassattribute_id=165 && data_int=1) OR (oa.contentclassattribute_id=127 && data_int=1) OR (oa.contentclassattribute_id=255 && data_int=1)) AND                               ( ezcontentobject_tree.priority < '1000'  ) AND     
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1)) OR (( ( ezcontentobject_tree.path_string like '/1/43/52/%' ) )))   AND 
 ezcontentobject.language_mask & 5 > 0 
  ORDER BY ezcontentobject_tree.priority ASC

SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
                    ezcontentobject_attribute, ezcontentclass_attribute
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ( ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '795' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '772' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '4' AND
                    ezcontentobject_attribute.contentobject_id = '710' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

SELECT id, name, navigation_part_identifier, locale, identifier
                    FROM   ezsection WHERE  id='1'

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=795

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=795 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:675' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 675 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND     ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND     ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND     ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:675' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 675 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

eZTemplate: Loading template "parts/topmenu_rec.tpl" with resource "design"

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 = 675 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=25 LIMIT 1

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=30 LIMIT 1

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=23 LIMIT 1

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=70 LIMIT 1

SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )   , ezcontentobject_attribute oa  WHERE ezcontentobject_tree.parent_node_id = 675 and ezcontentobject.contentclass_id IN ( 1, 2, 27, 25, 30, 23, 51, 20, 70 ) AND oa.contentobject_id=ezcontentobject.id AND oa.version=ezcontentobject.current_version AND oa.contentclassattribute_id IN (45, 73, 36, 257, 17, 28, 165, 127, 255) AND 
 ( oa.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & oa.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & oa.language_id ) ) & 4 ) >> 1 )
   <
     ( oa.language_id & 1 )
   + ( ( oa.language_id & 4 ) >> 1 )
 ) 
 AND (oa.contentclassattribute_id IN (45, 73, 36, 257) OR (oa.contentclassattribute_id=17 && data_int=1) OR (oa.contentclassattribute_id=28 && data_int=1) OR (oa.contentclassattribute_id=165 && data_int=1) OR (oa.contentclassattribute_id=127 && data_int=1) OR (oa.contentclassattribute_id=255 && data_int=1)) AND                               ( ezcontentobject_tree.priority < '1000'  ) AND     
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1)) OR (( ( ezcontentobject_tree.path_string like '/1/43/52/%' ) )))   AND 
 ezcontentobject.language_mask & 5 > 0 
  ORDER BY ezcontentobject_name.name ASC

SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
                    ezcontentobject_attribute, ezcontentclass_attribute
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ( ( ezcontentobject_attribute.version = '7' AND
                    ezcontentobject_attribute.contentobject_id = '748' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '7' AND
                    ezcontentobject_attribute.contentobject_id = '749' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '5' AND
                    ezcontentobject_attribute.contentobject_id = '734' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '6' AND
                    ezcontentobject_attribute.contentobject_id = '747' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

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=748

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=748 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:675', 'eznode:706' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 675, 706 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 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 = 675 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 675 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 675 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:675', 'eznode:706' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 675, 706 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

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=749

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=749 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:675', 'eznode:707' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 675, 707 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 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 = 675 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 675 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 675 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:675', 'eznode:707' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 675, 707 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

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=734

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=734 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:675', 'eznode:694' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 675, 694 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 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 = 675 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 675 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 675 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:675', 'eznode:694' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 675, 694 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

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=747

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=747 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:675', 'eznode:705' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 675, 705 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 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 = 675 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 675 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 675 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:675', 'eznode:705' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 675, 705 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

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=772

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=772 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:730' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 730 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND     ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND     ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND     ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:730' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 730 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

eZTemplate: Loading template "parts/topmenu_rec.tpl" with resource "design"

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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=25 LIMIT 1

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=30 LIMIT 1

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=23 LIMIT 1

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=70 LIMIT 1

SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )   , ezcontentobject_attribute oa  WHERE ezcontentobject_tree.parent_node_id = 730 and ezcontentobject.contentclass_id IN ( 1, 2, 27, 25, 30, 23, 51, 20, 70 ) AND oa.contentobject_id=ezcontentobject.id AND oa.version=ezcontentobject.current_version AND oa.contentclassattribute_id IN (45, 73, 36, 257, 17, 28, 165, 127, 255) AND 
 ( oa.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & oa.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & oa.language_id ) ) & 4 ) >> 1 )
   <
     ( oa.language_id & 1 )
   + ( ( oa.language_id & 4 ) >> 1 )
 ) 
 AND (oa.contentclassattribute_id IN (45, 73, 36, 257) OR (oa.contentclassattribute_id=17 && data_int=1) OR (oa.contentclassattribute_id=28 && data_int=1) OR (oa.contentclassattribute_id=165 && data_int=1) OR (oa.contentclassattribute_id=127 && data_int=1) OR (oa.contentclassattribute_id=255 && data_int=1)) AND                               ( ezcontentobject_tree.priority < '1000'  ) AND     
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1)) OR (( ( ezcontentobject_tree.path_string like '/1/43/52/%' ) )))   AND 
 ezcontentobject.language_mask & 5 > 0 
  ORDER BY ezcontentobject_tree.priority ASC

SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
                    ezcontentobject_attribute, ezcontentclass_attribute
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ( ( ezcontentobject_attribute.version = '55' AND
                    ezcontentobject_attribute.contentobject_id = '767' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '9' AND
                    ezcontentobject_attribute.contentobject_id = '803' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '1239' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '8' AND
                    ezcontentobject_attribute.contentobject_id = '773' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '19' AND
                    ezcontentobject_attribute.contentobject_id = '782' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '8' AND
                    ezcontentobject_attribute.contentobject_id = '774' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1238' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

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=767

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=767 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:730', 'eznode:725' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 730, 725 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:730', 'eznode:725' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 730, 725 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

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=803

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=803 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:730', 'eznode:752' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 730, 752 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:730', 'eznode:752' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 730, 752 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

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=1239

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=1239 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:730', 'eznode:960' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 730, 960 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:730', 'eznode:960' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 730, 960 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

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=773

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=773 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:730', 'eznode:731' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 730, 731 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:730', 'eznode:731' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 730, 731 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

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=782

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=782 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:730', 'eznode:740' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 730, 740 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:730', 'eznode:740' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 730, 740 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

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=774

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=774 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:730', 'eznode:732' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 730, 732 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:730', 'eznode:732' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 730, 732 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

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=1238

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=1238 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:730', 'eznode:959' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 730, 959 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 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 = 730 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT url, is_valid FROM ezurl WHERE id='40'

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=710

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=710 AND
                      s.id=l.contentobject_state_id AND
                      g.id=s.group_id

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:674' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 674 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND     ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND     ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container, ezcontentobject_name.name, ezcontentobject_name.real_translation FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id) INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND     ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version ) WHERE node_id = 2 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 5 > 0 ) AND action in ( 'eznode:2', 'eznode:674' ) AND is_original = 1 AND is_alias=0

SELECT co.*, con.name as name, con.real_translation, cot.node_id
             FROM ezcontentobject co
             JOIN ezcontentobject_tree cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
             JOIN ezcontentobject_name con ON co.id = con.contentobject_id AND co.current_version = con.content_version
             WHERE cot.node_id IN ( 2, 674 ) AND 
 ( con.language_id & co.language_mask > 0 AND
     ( (   co.language_mask - ( co.language_mask & con.language_id ) ) & 1 )
   + ( ( ( co.language_mask - ( co.language_mask & con.language_id ) ) & 4 ) >> 1 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 4 ) >> 1 )
 )

eZTemplate: Loading template "parts/topmenu_rec.tpl" with resource "design"

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 = 674 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 5 > 0 
  AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 )

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=25 LIMIT 1

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=30 LIMIT 1

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=23 LIMIT 1

SELECT id FROM ezcontentclass_attribute WHERE contentclass_id=70 LIMIT 1

SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )   , ezcontentobject_attribute oa  WHERE ezcontentobject_tree.parent_node_id = 674 and ezcontentobject.contentclass_id IN ( 1, 2, 27, 25, 30, 23, 51, 20, 70 ) AND oa.contentobject_id=ezcontentobject.id AND oa.version=ezcontentobject.current_version AND oa.contentclassattribute_id IN (45, 73, 36, 257, 17, 28, 165, 127, 255) AND 
 ( oa.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & oa.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & oa.language_id ) ) & 4 ) >> 1 )
   <
     ( oa.language_id & 1 )
   + ( ( oa.language_id & 4 ) >> 1 )
 ) 
 AND (oa.contentclassattribute_id IN (45, 73, 36, 257) OR (oa.contentclassattribute_id=17 && data_int=1) OR (oa.contentclassattribute_id=28 && data_int=1) OR (oa.contentclassattribute_id=165 && data_int=1) OR (oa.contentclassattribute_id=127 && data_int=1) OR (oa.contentclassattribute_id=255 && data_int=1)) AND                               ( ezcontentobject_tree.priority < '1000'  ) AND     
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1)) OR (( ( ezcontentobject_tree.path_string like '/1/43/52/%' ) )))   AND 
 ezcontentobject.language_mask & 5 > 0 
  ORDER BY ezcontentobject_name.name ASC

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  ( 61 ) AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1)) OR (( ( ezcontentobject_tree.path_string like '/1/43/52/%' ) )))   AND 
 ezcontentobject.language_mask & 5 > 0

Script end

eZTemplate: Loading template "setup/debug_toolbar.tpl" with resource "design"