eZ debug

Script start

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/ezwebin_site/cache/expiry.php')

RESULT:
array (
  'name' => 'var/ezwebin_site/cache/expiry.php',
  'name_trunk' => 'var/ezwebin_site/cache/expiry.php',
  'name_hash' => '5e18ccd58f44eeee23cf8ea4aef11c63',
  'datatype' => 'misc',
  'scope' => 'expirycache',
  'size' => '775',
  'mtime' => '1296689762',
  'expired' => '0',
  'status' => '0',
)

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/ezwebin_site/cache/expiry.php')

RESULT:
array (
  'name' => 'var/ezwebin_site/cache/expiry.php',
  'name_trunk' => 'var/ezwebin_site/cache/expiry.php',
  'name_hash' => '5e18ccd58f44eeee23cf8ea4aef11c63',
  'datatype' => 'misc',
  'scope' => 'expirycache',
  'size' => '775',
  'mtime' => '1296689762',
  'expired' => '0',
  'status' => '0',
)

SELECT data, user_id, expiration_time FROM ezsession WHERE session_key='pt2v9g1j9scvtubvrd3epspv33'

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/ezwebin_site/cache/user-info/1/0/3/2/80/user-data-103280.cache.php')

RESULT:
array (
  'name' => 'var/ezwebin_site/cache/user-info/1/0/3/2/80/user-data-103280.cache.php',
  'name_trunk' => 'var/ezwebin_site/cache/user-info/1/0/3/2/80/user-data-103280.cache.php',
  'name_hash' => 'd3eb7f2da5726ef3205011a1c1ace26a',
  'datatype' => 'php',
  'scope' => 'user-info-cache',
  'size' => '7424',
  'mtime' => '1296683957',
  'expired' => '0',
  'status' => '0',
)

SQL for _selectOneAssoc:
SELECT name, mtime FROM ezdfsfile WHERE name_hash=MD5('var/ezwebin_site/cache/ezcontentlanguage_cache.php')

RESULT:
array (
  0 => 'var/ezwebin_site/cache/ezcontentlanguage_cache.php',
  1 => '1296612007',
)

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/ezwebin_site/cache/ezcontentlanguage_cache.php')

RESULT:
array (
  'name' => 'var/ezwebin_site/cache/ezcontentlanguage_cache.php',
  'name_trunk' => 'var/ezwebin_site/cache/ezcontentlanguage_cache.php',
  'name_hash' => '49673cdf5f81493508b81903e2ff155c',
  'datatype' => 'php',
  'scope' => 'content',
  'size' => '346',
  'mtime' => '1296612007',
  'expired' => '0',
  'status' => '0',
)

SELECT e0.id AS e0_id, e0.link AS e0_link, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.is_alias AS e0_is_alias, e0.alias_redirects AS e0_alias_redirects, e1.id AS e1_id, e1.link AS e1_link, e1.text AS e1_text, e1.text_md5 AS e1_text_md5, e1.is_alias AS e1_is_alias, e1.alias_redirects AS e1_alias_redirects, e2.id AS e2_id, e2.link AS e2_link, e2.text AS e2_text, e2.text_md5 AS e2_text_md5, e2.is_alias AS e2_is_alias, e2.alias_redirects AS e2_alias_redirects, e3.id AS e3_id, e3.link AS e3_link, e3.text AS e3_text, e3.text_md5 AS e3_text_md5, e3.is_alias AS e3_is_alias, e3.alias_redirects AS e3_alias_redirects, e4.id AS e4_id, e4.link AS e4_link, e4.text AS e4_text, e4.text_md5 AS e4_text_md5, e4.is_alias AS e4_is_alias, e4.action AS e4_action, e4.alias_redirects AS e4_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1, ezurlalias_ml e2, ezurlalias_ml e3, ezurlalias_ml e4 WHERE e0.parent = 0 AND (e0.lang_mask & 7 > 0) AND e0.text_md5 =  MD5( 'content' )  AND e1.parent = e0.link AND (e1.lang_mask & 7 > 0) AND e1.text_md5 =  MD5( 'edit' )  AND e2.parent = e1.link AND (e2.lang_mask & 7 > 0) AND e2.text_md5 =  MD5( '103470' )  AND e3.parent = e2.link AND (e3.lang_mask & 7 > 0) AND e3.text_md5 =  MD5( '3' )  AND e4.parent = e3.link AND (e4.lang_mask & 7 > 0) AND e4.text_md5 =  MD5( 'eng-us' ) 
LIMIT 0, 1

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/ezwebin_site/cache/wildcard/wildcard_9972f86e6bfa55c926ee1761aa2a0a0a_index.php')

RESULT:
array (
  'name' => 'var/ezwebin_site/cache/wildcard/wildcard_9972f86e6bfa55c926ee1761aa2a0a0a_index.php',
  'name_trunk' => 'var/ezwebin_site/cache/wildcard/wildcard_9972f86e6bfa55c926ee1761aa2a0a0a_index.php',
  'name_hash' => 'db8c7b4e3afeadd37c44e6a353736441',
  'datatype' => 'php',
  'scope' => 'wildcard-cache-index',
  'size' => '27',
  'mtime' => '1296683946',
  'expired' => '0',
  'status' => '0',
)

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/ezwebin_site/cache/statelimitations_97d2d6c9eaabc7f69e5aec0a60efd636.php')

RESULT:
array (
  'name' => 'var/ezwebin_site/cache/statelimitations_97d2d6c9eaabc7f69e5aec0a60efd636.php',
  'name_trunk' => 'var/ezwebin_site/cache/statelimitations_97d2d6c9eaabc7f69e5aec0a60efd636.php',
  'name_hash' => 'c6c7275f3bb540307324653ce77f38ef',
  'datatype' => 'php',
  'scope' => 'statelimitations',
  'size' => '39',
  'mtime' => '1296683947',
  'expired' => '0',
  'status' => '0',
)

Module start 'content'

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

SELECT path_string
                    FROM   ezcontentobject_tree WHERE  contentobject_id='103470'

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

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='3' AND contentobject_id='103470' ORDER BY version ASC

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='3' AND contentobject_id='103470' 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 = '3' AND
                    ezcontentobject_attribute.contentobject_id = '103470' AND
                    ezcontentobject_version.contentobject_id = '103470' AND
                    ezcontentobject_version.version = '3' AND ezcontentobject_attribute.language_code = 'eng-US' ORDER by
                    ezcontentclass_attribute.placement ASC

Missing translation for message in context: 'kernel/classes/datatypes' with comment: 'Datatype name'. The untranslated message is: 'Text line'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689764, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes/datatypes' with comment: 'Datatype name'. The untranslated message is: 'Checkbox'

SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,       is_main, from_node_id, parent_remote_id, op_code
                    FROM   eznode_assignment WHERE  contentobject_id='103470' AND contentobject_version='3'

SELECT ezcontentobject.*,
             ezcontentobject_tree.*,
             ezcontentclass.serialized_name_list as class_serialized_name_list,
             ezcontentclass.identifier as class_identifier,
             ezcontentclass.is_container as is_container
          FROM   ezcontentobject_tree,
             ezcontentobject,
             ezcontentclass
          WHERE  contentobject_id=103470 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement,       is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2,       data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1,       data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
                    FROM   ezcontentclass_attribute WHERE  id='4' AND version='0'

SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement,       is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2,       data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1,       data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
                    FROM   ezcontentclass_attribute WHERE  id='155' AND version='0'

SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement,       is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2,       data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1,       data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
                    FROM   ezcontentclass_attribute WHERE  id='158' AND version='0'

SELECT 
                        ezcontentclass.serialized_name_list AS class_serialized_name_list,
                        ezcontentclass.identifier as contentclass_identifier,
                        ezcontentclass.is_container as is_container,
                        ezcontentobject.* , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                     FROM
                        ezcontentclass,
                        ezcontentobject,
                        ezcontentobject_link
                        , ezcontentobject_name 
                        
                     WHERE
                        ezcontentclass.id=ezcontentobject.contentclass_id AND
                        ezcontentclass.version=0 AND
                        ezcontentobject.status=1 AND
                        
                        ezcontentobject_link.op_code='0'
                         AND ( relation_type & 2 ) <> 0 
                         AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='103470' AND
                                                                      ezcontentobject_link.from_contentobject_version='3' 
                        
                         AND ezcontentobject.id = ezcontentobject_name.contentobject_id AND
                                 ezcontentobject.current_version = ezcontentobject_name.content_version AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 )

SELECT 
                        ezcontentclass.serialized_name_list AS class_serialized_name_list,
                        ezcontentclass.identifier as contentclass_identifier,
                        ezcontentclass.is_container as is_container,
                        ezcontentobject.* , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                     FROM
                        ezcontentclass,
                        ezcontentobject,
                        ezcontentobject_link
                        , ezcontentobject_name 
                        
                     WHERE
                        ezcontentclass.id=ezcontentobject.contentclass_id AND
                        ezcontentclass.version=0 AND
                        ezcontentobject.status=1 AND
                        
                        ezcontentobject_link.op_code='0'
                         AND ( relation_type & 4 ) <> 0 
                         AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='103470' AND
                                                                      ezcontentobject_link.from_contentobject_version='3' 
                        
                         AND ezcontentobject.id = ezcontentobject_name.contentobject_id AND
                                 ezcontentobject.current_version = ezcontentobject_name.content_version AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 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 = '103470' AND
                    ezcontentobject_version.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '103470' AND                    ezcontentobject_attribute.version = '2' AND                    ezcontentobject_attribute.language_code = 'eng-US' 
                  
                  ORDER BY
                    ezcontentclass_attribute.placement ASC,
                    ezcontentobject_attribute.language_code ASC

BEGIN WORK

SELECT id
                    FROM   ezcontentobject_version WHERE  id='128375'

UPDATE ezcontentobject_version SET contentobject_id=103470, creator_id=103280, version=3, status=0,
    created=1296689754, modified=1296689764, workflow_event_pos=0, user_id=0,
    language_mask=3, initial_language_id=2 WHERE  id='128375'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute WHERE  id='479479' AND contentobject_id='103470' AND version='3' AND language_code='eng-US'

UPDATE ezcontentobject_attribute SET language_id=2, contentclassattribute_id=4,
    attribute_original_id=0, sort_key_int=0, sort_key_string='test bjoern',
    data_type_string='ezstring', data_text='Test Bjoern', data_int=NULL, data_float=0.000000 WHERE  id='479479' AND contentobject_id='103470' AND version='3' AND language_code='eng-US'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute WHERE  id='479480' AND contentobject_id='103470' AND version='3' AND language_code='eng-US'

UPDATE ezcontentobject_attribute SET language_id=2, contentclassattribute_id=155,
    attribute_original_id=0, sort_key_int=0, sort_key_string='', data_type_string='ezstring',
    data_text='', data_int=NULL, data_float=0.000000 WHERE  id='479480' AND contentobject_id='103470' AND version='3' AND language_code='eng-US'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute WHERE  id='479481' AND contentobject_id='103470' AND version='3' AND language_code='eng-US'

UPDATE ezcontentobject_attribute SET language_id=2, contentclassattribute_id=158,
    attribute_original_id=479481, sort_key_int=1, sort_key_string='', data_type_string='ezboolean',
    data_text='', data_int=1, data_float=0.000000 WHERE  id='479481' AND contentobject_id='103470' AND version='3' AND language_code='eng-US'

COMMIT

BEGIN WORK

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 = 103470 AND
                ezcontentobject_version.version = 3 AND
                ezcontentobject_attribute.contentobject_id = 103470

                AND ezcontentobject_attribute.language_code IN ( 'eng-US' )

                AND ezcontentobject_attribute.version = '3'

                AND
                identifier IN ( 'short_name', 'name' )

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/ezwebin_site/cache/classattributeidentifiers_97d2d6c9eaabc7f69e5aec0a60efd636.php')

RESULT:
array (
  'name' => 'var/ezwebin_site/cache/classattributeidentifiers_97d2d6c9eaabc7f69e5aec0a60efd636.php',
  'name_trunk' => 'var/ezwebin_site/cache/classattributeidentifiers_97d2d6c9eaabc7f69e5aec0a60efd636.php',
  'name_hash' => 'dfd0adea8843bc766fc936171001c98e',
  'datatype' => 'php',
  'scope' => 'classattridentifiers',
  'size' => '12311',
  'mtime' => '1296683947',
  'expired' => '0',
  'status' => '0',
)

SELECT COUNT(*) AS count FROM ezcontentobject_name WHERE contentobject_id = '103470'
                                 AND content_version = '3' AND content_translation ='eng-US'

INSERT INTO ezcontentobject_name( contentobject_id,
                                                           name,
                                                           content_version,
                                                           content_translation,
                                                           real_translation,
                                                           language_id )
                                VALUES( '103470',
                                        'Test Bjoern',
                                        '3',
                                        'eng-US',
                                        'eng-US',
                                        '2' )

COMMIT

SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,       is_main, from_node_id, parent_remote_id, op_code
                    FROM   eznode_assignment WHERE  contentobject_id='103470' AND contentobject_version='3'

BEGIN WORK

SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 43 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 7 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 )

COMMIT

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='103470' 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  contentobject_id='103470' AND status IN ( '1', '3' )  AND initial_language_id='2' ORDER BY version ASC

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '103470'
                       AND content_version = '2'
                       AND ( content_translation = 'eng-US' OR language_id = '2' )

BEGIN WORK

SELECT id, main, memento_key, main_key, memento_data
                    FROM   ezoperation_memento WHERE  memento_key='9a4bf852ff935aadc6e4a758eb5629ee' AND main='1'

SELECT id, main, memento_key, main_key, memento_data
                    FROM   ezoperation_memento WHERE  memento_key='9a4bf852ff935aadc6e4a758eb5629ee' AND main='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='3' AND contentobject_id='103470' ORDER BY version ASC

SELECT id
                    FROM   ezcontentobject_version WHERE  id='128375'

UPDATE ezcontentobject_version SET contentobject_id=103470, creator_id=103280, version=3, status=2,
    created=1296689754, modified=1296689764, workflow_event_pos=0, user_id=0,
    language_mask=3, initial_language_id=2 WHERE  id='128375'

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='103470' 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='3' AND contentobject_id='103470' ORDER BY version ASC

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

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='2' AND contentobject_id='103470' ORDER BY version ASC

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

SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 84057 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 7 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 )

SELECT id, module_name, function_name, connect_type, workflow_id, name
                    FROM   eztrigger WHERE  name='pre_publish' AND module_name='content' AND function_name='publish'

SELECT id, version, is_enabled, workflow_type_string, name, creator_id, modifier_id,       created, modified
                    FROM   ezworkflow WHERE  id='12' AND version='0'

SELECT id, process_key, workflow_id, user_id, content_id, content_version, session_key,       node_id, event_id, event_position, event_state, last_event_id, last_event_position, last_event_status,       event_status, created, modified, activation_date, status, parameters, memento_key
                    FROM   ezworkflow_process WHERE  process_key='ad9e5986af7c99853fe2ab1108d4e0e8' ORDER BY user_id ASC

INSERT INTO ezworkflow_process (process_key, workflow_id, user_id, content_id, content_version, session_key, node_id, event_id, event_position, event_state, last_event_id, last_event_position, last_event_status, event_status, created, modified, activation_date, status, parameters, memento_key) VALUES('ad9e5986af7c99853fe2ab1108d4e0e8', 12, 103280, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 1296689764, 1296689764, 0, 0, 'a:7:{s:9:\"object_id\";s:6:\"103470\";s:7:\"version\";s:1:\"3\";s:11:\"workflow_id\";s:2:\"12\";s:12:\"trigger_name\";s:11:\"pre_publish\";s:11:\"module_name\";s:7:\"content\";s:15:\"module_function\";s:7:\"publish\";s:7:\"user_id\";s:6:\"103280\";}', '')

SELECT id, version, is_enabled, workflow_type_string, name, creator_id, modifier_id,       created, modified
                    FROM   ezworkflow WHERE  id='12' AND version='0'

SELECT id, version, workflow_id, workflow_type_string, description, data_int1, data_int2,       data_int3, data_int4, data_text1, data_text2, data_text3, data_text4, data_text5,       placement
                    FROM   ezworkflow_event WHERE  id='0' AND version='0'

SELECT id, placement
                    FROM   ezworkflow_event WHERE  workflow_id='12' AND version='0' ORDER BY placement ASC
LIMIT 0, 1

SELECT id, version, workflow_id, workflow_type_string, description, data_int1, data_int2,       data_int3, data_int4, data_text1, data_text2, data_text3, data_text4, data_text5,       placement
                    FROM   ezworkflow_event WHERE  id='11' AND version='0'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689764, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/workflow/event'. The untranslated message is: 'Multiplexer'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689764, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/workflow/event'. The untranslated message is: 'Event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689764, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'No state yet'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Accepted event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Rejected event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event deferred to cron job'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event deferred to cron job, event will be rerun'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event runs a sub event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Canceled whole workflow'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Workflow was reset for reuse'

SELECT id, placement
                    FROM   ezworkflow_event WHERE  workflow_id='12' AND version='0' ORDER BY placement ASC
LIMIT 1, 1

SELECT id, version, workflow_id, workflow_type_string, description, data_int1, data_int2,       data_int3, data_int4, data_text1, data_text2, data_text3, data_text4, data_text5,       placement
                    FROM   ezworkflow_event WHERE  id='13' AND version='0'

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

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'No state yet'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Accepted event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Rejected event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event deferred to cron job'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event deferred to cron job, event will be rerun'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event runs a sub event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Canceled whole workflow'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Workflow was reset for reuse'

SELECT id, placement
                    FROM   ezworkflow_event WHERE  workflow_id='12' AND version='0' ORDER BY placement ASC
LIMIT 2, 1

SELECT id, version, workflow_id, workflow_type_string, description, data_int1, data_int2,       data_int3, data_int4, data_text1, data_text2, data_text3, data_text4, data_text5,       placement
                    FROM   ezworkflow_event WHERE  id='15' AND version='0'

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

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'No state yet'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Accepted event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Rejected event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event deferred to cron job'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event deferred to cron job, event will be rerun'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event runs a sub event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Canceled whole workflow'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689765, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Workflow was reset for reuse'

SELECT id, placement
                    FROM   ezworkflow_event WHERE  workflow_id='12' AND version='0' ORDER BY placement ASC
LIMIT 3, 1

SELECT id
                    FROM   ezworkflow_process WHERE  id='303063'

UPDATE ezworkflow_process SET process_key='ad9e5986af7c99853fe2ab1108d4e0e8', workflow_id=12,
    user_id=103280, content_id=0, content_version=0, session_key='0', node_id=0,
    event_id=0, event_position=0, event_state=0, last_event_id=15,
    last_event_position=3, last_event_status=0, event_status=1, created=1296689764,
    modified=1296689765, activation_date=0, status=2,
    parameters='a:7:{s:9:\"object_id\";s:6:\"103470\";s:7:\"version\";s:1:\"3\";s:11:\"workflow_id\";s:2:\"12\";s:12:\"trigger_name\";s:11:\"pre_publish\";s:11:\"module_name\";s:7:\"content\";s:15:\"module_function\";s:7:\"publish\";s:7:\"user_id\";s:6:\"103280\";}', memento_key='' WHERE  id='303063'

DELETE FROM ezworkflow_process  WHERE  id='303063'

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='2' AND contentobject_id='103470' ORDER BY version ASC

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='103470' AND version='2'
                  
                  ORDER BY language_code

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='103470' AND version='3'
                  
                  ORDER BY language_code

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='103470' AND version='3'
                  
                  ORDER BY language_code

SELECT id
                    FROM   ezcontentobject_version WHERE  id='128375'

UPDATE ezcontentobject_version SET contentobject_id=103470, creator_id=103280, version=3, status=2,
    created=1296689754, modified=1296689764, workflow_event_pos=0, user_id=0,
    language_mask=3, initial_language_id=2 WHERE  id='128375'

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='103470' 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='2' AND contentobject_id='103470' ORDER BY version ASC

SELECT id
                    FROM   ezcontentobject_version WHERE  id='128323'

UPDATE ezcontentobject_version SET contentobject_id=103470, creator_id=103280, version=2, status=3,
    created=1296684803, modified=1296684807, workflow_event_pos=0, user_id=0,
    language_mask=3, initial_language_id=2 WHERE  id='128323'

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='103470' 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='3' AND contentobject_id='103470' ORDER BY version ASC

SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,       is_main, from_node_id, parent_remote_id, op_code
                    FROM   eznode_assignment WHERE  contentobject_id='103470' AND contentobject_version='3'

SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,       is_main, from_node_id, parent_remote_id, op_code
                    FROM   eznode_assignment WHERE  contentobject_id='103470' AND contentobject_version='3' AND parent_node='43'

SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 43 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 7 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 )

SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                WHERE parent_node_id = 43 AND
                      contentobject_id = 103470 AND
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id

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

SELECT id
                    FROM   ezcontentobject_version WHERE  id='128375'

UPDATE ezcontentobject_version SET contentobject_id=103470, creator_id=103280, version=3, status=1,
    created=1296689754, modified=1296689764, workflow_event_pos=0, user_id=0,
    language_mask=3, initial_language_id=2 WHERE  id='128375'

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='103470' 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='3' AND contentobject_id='103470' ORDER BY version ASC

SELECT to_contentobject_id, relation_type FROM ezcontentobject_link
                                                WHERE contentclassattribute_id='0'
                                                  AND from_contentobject_id='103470'
                                                  AND from_contentobject_version='2'
                                                  AND op_code='0'

SELECT to_contentobject_id, op_code, relation_type FROM ezcontentobject_link
                                                     WHERE contentclassattribute_id='0'
                                                       AND from_contentobject_id='103470'
                                                       AND from_contentobject_version='3'
                                                       AND op_code!='0'
                                                     ORDER BY id ASC

DELETE FROM ezcontentobject_link
                     WHERE contentclassattribute_id='0'
                       AND from_contentobject_id='103470'
                       AND from_contentobject_version='3'

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='103470' AND version='3'
                  
                  ORDER BY language_code

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 = 103470 AND
                ezcontentobject_version.version = 3 AND
                ezcontentobject_attribute.contentobject_id = 103470

                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_version.language_mask - ( ezcontentobject_version.language_mask & ezcontentobject_attribute.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_attribute.language_id & 1 )
   + ( ( ezcontentobject_attribute.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_attribute.language_id & 2 ) << 1 )
 ) 


                AND ezcontentobject_attribute.version = '3'

                AND
                identifier IN ( 'short_name', 'name' )

SELECT COUNT(*) AS count FROM ezcontentobject_name WHERE contentobject_id = '103470'
                                 AND content_version = '3' AND content_translation ='eng-US'

UPDATE ezcontentobject_name SET name='Test Bjoern'
                         WHERE
                         contentobject_id = '103470'  AND
                         content_version = '3' AND
                         content_translation ='eng-US'

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='103470' AND version='3'
                  
                  ORDER BY language_code

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 = 103470 AND
                ezcontentobject_version.version = 3 AND
                ezcontentobject_attribute.contentobject_id = 103470

                AND ezcontentobject_attribute.language_code IN ( 'eng-US' )

                AND ezcontentobject_attribute.version = '3'

                AND
                identifier IN ( 'short_name', 'name' )

SELECT COUNT(*) AS count FROM ezcontentobject_name WHERE contentobject_id = '103470'
                                 AND content_version = '3' AND content_translation ='eng-US'

UPDATE ezcontentobject_name SET name='Test Bjoern'
                         WHERE
                         contentobject_id = '103470'  AND
                         content_version = '3' AND
                         content_translation ='eng-US'

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='3' AND contentobject_id='103470' ORDER BY version ASC

SELECT ezcontentobject.*,
             ezcontentobject_tree.*,
             ezcontentclass.serialized_name_list as class_serialized_name_list,
             ezcontentclass.identifier as class_identifier,
             ezcontentclass.is_container as is_container
          FROM   ezcontentobject_tree,
             ezcontentobject,
             ezcontentclass
          WHERE  contentobject_id=103470 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

UPDATE ezcontentobject_tree SET modified_subnode=1296689765 WHERE node_id IN ( 1, 43, 84057 )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '103470'
                       AND content_version = '3'
                       AND ( content_translation = 'eng-US' OR language_id = '2' )

SELECT id
                    FROM   ezcontentobject WHERE  id='103470'

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '103470'
                       AND content_version = '3'
                       AND ( content_translation = 'eng-US' OR language_id = '2' )

UPDATE ezcontentobject SET section_id=3, owner_id=103280, contentclass_id=1,
    name='Test Bjoern', published=1296684327, modified=1296689765, current_version=3,
    status=1, remote_id='85d8eca6884573ebe47f6da7792b6ec9', language_mask=3,
    initial_language_id=2 WHERE  id='103470'

UPDATE ezcontentobject_name SET language_id=language_id & ~1 WHERE contentobject_id = '103470' AND content_version = '3'

UPDATE ezcontentobject_name
                    SET language_id='3'
                    WHERE language_id='2' AND contentobject_id = '103470' AND content_version = '3'

UPDATE ezcontentobject_attribute SET language_id=language_id & ~1 WHERE contentobject_id = '103470' AND version = '3'

UPDATE ezcontentobject_attribute
                    SET language_id='3'
                WHERE language_id='2' AND contentobject_id = '103470' AND version = '3'

SELECT node_id, parent_node_id, main_node_id, contentobject_id, contentobject_version, contentobject_is_published, depth,       sort_field, sort_order, priority, modified_subnode, path_string, path_identification_string, remote_id,       is_hidden, is_invisible
                    FROM   ezcontentobject_tree WHERE  contentobject_id='103470'

UPDATE ezurlalias_ml SET lang_mask = cast( lang_mask | 1 AS SIGNED )  WHERE action in ('eznode:84057')  AND cast(lang_mask & 2 AS SIGNED )  > 0

UPDATE ezurlalias_ml SET lang_mask = cast(lang_mask & -2 AS SIGNED )  WHERE action in ('eznode:84057')  AND cast(lang_mask & 2 AS SIGNED )  = 0

SELECT id
                    FROM   ezcontentobject_version WHERE  id='128375'

UPDATE ezcontentobject_version SET contentobject_id=103470, creator_id=103280, version=3, status=1,
    created=1296689754, modified=1296689764, workflow_event_pos=0, user_id=0,
    language_mask=3, initial_language_id=2 WHERE  id='128375'

SELECT ezcontentobject.*,
             ezcontentobject_tree.*,
             ezcontentclass.serialized_name_list as class_serialized_name_list,
             ezcontentclass.identifier as class_identifier,
             ezcontentclass.is_container as is_container
          FROM   ezcontentobject_tree,
             ezcontentobject,
             ezcontentclass
          WHERE  contentobject_id=103470 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

UPDATE ezcontentobject_tree SET modified_subnode=1296689784 WHERE node_id IN ( 1, 43, 84057 )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '103470'
                       AND content_version = '3'
                       AND ( content_translation = 'eng-US' OR language_id = '2' )

SELECT id
                    FROM   ezcontentobject WHERE  id='103470'

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '103470'
                       AND content_version = '3'
                       AND ( content_translation = 'eng-US' OR language_id = '2' )

UPDATE ezcontentobject SET section_id=3, owner_id=103280, contentclass_id=1,
    name='Test Bjoern', published=1296684327, modified=1296689765, current_version=3,
    status=1, remote_id='85d8eca6884573ebe47f6da7792b6ec9', language_mask=3,
    initial_language_id=2 WHERE  id='103470'

UPDATE ezcontentobject_tree SET contentobject_version='3' WHERE contentobject_id='103470'

SELECT ezcontentobject.*,
             ezcontentobject_tree.*,
             ezcontentclass.serialized_name_list as class_serialized_name_list,
             ezcontentclass.identifier as class_identifier,
             ezcontentclass.is_container as is_container
          FROM   ezcontentobject_tree,
             ezcontentobject,
             ezcontentclass
          WHERE  contentobject_id=103470 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '103470'
                       AND content_version = '3'
                       AND ( content_translation = 'eng-US' OR language_id = '2' )

SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier
            FROM ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
            WHERE
                ezcontentclass_attribute.version = 0 AND
                ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                ezcontentobject_version.contentobject_id = 103470 AND
                ezcontentobject_version.version = 3 AND
                ezcontentobject_attribute.contentobject_id = 103470

                AND ezcontentobject_attribute.language_code IN ( 'eng-US' )

                AND ezcontentobject_attribute.version = '3'

                AND
                identifier IN ( 'url' )

SELECT * FROM ezurlalias_ml WHERE  action = 'eznode:84057' AND is_original = 1 AND is_alias = 0

SELECT * FROM ezurlalias_ml WHERE parent = 9 AND action != 'eznode:84057'  AND text_md5 =  MD5( 'node_84057' )  AND is_original = 1

SELECT * FROM ezurlalias_ml WHERE  action = 'eznode:84057' AND is_original = 1 AND is_alias = 0

SELECT * FROM ezurlalias_ml WHERE  action = 'eznode:43' AND is_original = 1 AND is_alias = 0

SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 43 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 7 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 )

SELECT text, parent FROM ezurlalias_ml WHERE id = 9

SELECT * FROM ezurlalias_ml WHERE parent = 9 AND text_md5 =  MD5( 'node_84057' )

SELECT * FROM ezurlalias_ml WHERE parent = 9 AND action = 'eznode:84057' AND is_original = 1 AND is_alias = 0

UPDATE ezurlalias_ml SET link = id, lang_mask = cast( cast(lang_mask & -2 AS SIGNED )  | 3 AS SIGNED ) , text = 'node_84057', action = 'eznode:84057', action_type = 'eznode', is_alias = 0, is_original = 1 WHERE parent = 9 AND text_md5 =  MD5( 'node_84057' )

SELECT * FROM ezurlalias_ml WHERE action = 'eznode:84057' AND (cast(lang_mask & 2 AS SIGNED )  > 0) AND is_original = 1 AND is_alias = 0 AND (parent != 9 OR text_md5 !=  MD5( 'node_84057' ) )

SELECT * FROM ezurlalias_ml WHERE action = 'eznode:84057' AND (cast(lang_mask & 2 AS SIGNED )  > 0) AND is_original = 0 AND (parent != 9 OR text_md5 !=  MD5( 'node_84057' ) )

SELECT * FROM ezurlalias_ml WHERE action = 'eznode:84057' AND (cast(lang_mask & 2 AS SIGNED )  > 0) AND is_original = 0 AND (parent != 9 OR text_md5 !=  MD5( 'node_84057' ) )

UPDATE ezurlalias_ml SET link = 88582, is_alias = 0, is_original = 0 WHERE action = 'eznode:84057' AND is_original = 0 AND is_alias = 0 AND (cast(lang_mask & 2 AS SIGNED )  > 0) AND (parent != 9 OR text_md5 !=  MD5( 'node_84057' ) )

SELECT id FROM ezurlalias_ml WHERE action = 'eznode:84057' AND is_alias = 0 AND (parent != 9 OR text_md5 !=  MD5( 'node_84057' ) )

SELECT DISTINCT contentclass_id
                FROM ezcontentclass_attribute
                WHERE version=0
                AND data_type_string='ezuser'

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='103470' 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='3' AND contentobject_id='103470' ORDER BY version ASC

SELECT ezcontentobject.*,
             ezcontentobject_tree.*,
             ezcontentclass.serialized_name_list as class_serialized_name_list,
             ezcontentclass.identifier as class_identifier,
             ezcontentclass.is_container as is_container
          FROM   ezcontentobject_tree,
             ezcontentobject,
             ezcontentclass
          WHERE  contentobject_id=103470 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,       is_main, from_node_id, parent_remote_id, op_code
                    FROM   eznode_assignment WHERE  contentobject_id='103470' AND contentobject_version='3'

SELECT ezcontentobject.*,
             ezcontentobject_tree.*,
             ezcontentclass.serialized_name_list as class_serialized_name_list,
             ezcontentclass.identifier as class_identifier,
             ezcontentclass.is_container as is_container
          FROM   ezcontentobject_tree,
             ezcontentobject,
             ezcontentclass
          WHERE  contentobject_id=103470 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

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 = '103470' AND
                    ezcontentobject_version.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '103470' AND                    ezcontentobject_attribute.version = '3' AND                    ezcontentobject_attribute.language_code = 'eng-US' 
                  
                  ORDER BY
                    ezcontentclass_attribute.placement ASC,
                    ezcontentobject_attribute.language_code ASC

SELECT ezcontentobject_attribute.id, ezcontentobject_attribute.version
            FROM ezcontentobject_version,
                 ezcontentobject_attribute,
                ezcontentclass_attribute
            WHERE
                    ezcontentobject_version.contentobject_id='103470'
                AND ( ezcontentobject_version.status in ( 0, 2, 5 ) OR ( ezcontentobject_version.status = '1' AND ezcontentobject_version.version = '3' ) )
                AND ezcontentobject_attribute.contentobject_id=ezcontentobject_version.contentobject_id
                AND ezcontentobject_attribute.version=ezcontentobject_version.version
                AND ezcontentobject_attribute.language_id!='2'
                AND ezcontentobject_attribute.contentclassattribute_id=ezcontentclass_attribute.id
                AND ezcontentclass_attribute.can_translate=0

SELECT id, contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id,       sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float
                    FROM   ezcontentobject_attribute WHERE  id='479481' AND version='3'

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 = '3' AND
                    ezcontentobject_attribute.contentobject_id = '103470' AND
                    ezcontentobject_version.contentobject_id = '103470' AND
                    ezcontentobject_version.version = '3' AND ezcontentobject_attribute.language_code = 'eng-US' ORDER by
                    ezcontentclass_attribute.placement ASC

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute WHERE  id='479481' AND contentobject_id='103470' AND version='3' AND language_code='eng-US'

UPDATE ezcontentobject_attribute SET language_id=3, contentclassattribute_id=158,
    attribute_original_id=479481, sort_key_int=1, sort_key_string='', data_type_string='ezboolean',
    data_text='', data_int=1, data_float=0.000000 WHERE  id='479481' AND contentobject_id='103470' AND version='3' AND language_code='eng-US'

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

SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,       is_main, from_node_id, parent_remote_id, op_code
                    FROM   eznode_assignment WHERE  contentobject_id='103470' AND contentobject_version='3'

SELECT ezcontentobject.*,
             ezcontentobject_tree.*,
             ezcontentclass.serialized_name_list as class_serialized_name_list,
             ezcontentclass.identifier as class_identifier,
             ezcontentclass.is_container as is_container
          FROM   ezcontentobject_tree,
             ezcontentobject,
             ezcontentclass
          WHERE  contentobject_id=103470 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

SELECT
                    parent_node_id, contentobject_id
                  FROM
                    ezcontentobject_tree
                  WHERE contentobject_id IN ( 103470 )

SELECT 
                        ezcontentclass.serialized_name_list AS class_serialized_name_list,
                        ezcontentclass.identifier as contentclass_identifier,
                        ezcontentclass.is_container as is_container,
                        ezcontentobject.* , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                     FROM
                        ezcontentclass,
                        ezcontentobject,
                        ezcontentobject_link
                        , ezcontentobject_name 
                        
                     WHERE
                        ezcontentclass.id=ezcontentobject.contentclass_id AND
                        ezcontentclass.version=0 AND
                        ezcontentobject.status=1 AND
                        
                        ezcontentobject_link.op_code='0'
                         AND ( relation_type & 1 ) <> 0 
                         AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='103470' AND
                                                                      ezcontentobject_link.from_contentobject_version='3' 
                        
                         AND ezcontentobject.id = ezcontentobject_name.contentobject_id AND
                                 ezcontentobject.current_version = ezcontentobject_name.content_version AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 )

SELECT version FROM ezcontentobject_version
                                      WHERE contentobject_id='103470'
                                      ORDER BY version DESC
LIMIT 0, 2

SELECT 
                        ezcontentclass.serialized_name_list AS class_serialized_name_list,
                        ezcontentclass.identifier as contentclass_identifier,
                        ezcontentclass.is_container as is_container,
                        ezcontentobject.* , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                     FROM
                        ezcontentclass,
                        ezcontentobject,
                        ezcontentobject_link
                        , ezcontentobject_name 
                        
                     WHERE
                        ezcontentclass.id=ezcontentobject.contentclass_id AND
                        ezcontentclass.version=0 AND
                        ezcontentobject.status=1 AND
                        
                        ezcontentobject_link.op_code='0'
                         AND ( relation_type & 1 ) <> 0 
                         AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='103470' AND
                                                                      ezcontentobject_link.from_contentobject_version='2' 
                        
                         AND ezcontentobject.id = ezcontentobject_name.contentobject_id AND
                                 ezcontentobject.current_version = ezcontentobject_name.content_version AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 )

SELECT 
                        ezcontentclass.serialized_name_list AS class_serialized_name_list,
                        ezcontentclass.identifier as contentclass_identifier,
                        ezcontentclass.is_container as is_container,
                        ezcontentobject.* , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                     FROM
                        ezcontentclass,
                        ezcontentobject,
                        ezcontentobject_link
                        , ezcontentobject_name 
                        
                     WHERE
                        ezcontentclass.id=ezcontentobject.contentclass_id AND
                        ezcontentclass.version=0 AND
                        ezcontentobject.status=1 AND
                        
                        ezcontentobject_link.op_code='0'
                         AND ( relation_type & 11 ) <> 0 
                         AND ezcontentobject.id=ezcontentobject_link.from_contentobject_id AND
                                                                      ezcontentobject_link.to_contentobject_id=103470 AND
                                                                      ezcontentobject_link.from_contentobject_version=ezcontentobject.current_version 
                        
                         AND ezcontentobject.id = ezcontentobject_name.contentobject_id AND
                                 ezcontentobject.current_version = ezcontentobject_name.content_version AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 )

SELECT version FROM ezcontentobject_version
                                      WHERE contentobject_id='103470'
                                      ORDER BY version DESC
LIMIT 0, 2

SELECT 
                        ezcontentclass.serialized_name_list AS class_serialized_name_list,
                        ezcontentclass.identifier as contentclass_identifier,
                        ezcontentclass.is_container as is_container,
                        ezcontentobject.* , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                     FROM
                        ezcontentclass,
                        ezcontentobject,
                        ezcontentobject_link
                        , ezcontentobject_name 
                        
                     WHERE
                        ezcontentclass.id=ezcontentobject.contentclass_id AND
                        ezcontentclass.version=0 AND
                        ezcontentobject.status=1 AND
                        
                        ezcontentobject_link.op_code='0'
                         AND ( relation_type & 11 ) <> 0 
                         AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='103470' AND
                                                                      ezcontentobject_link.from_contentobject_version='2' 
                        
                         AND ezcontentobject.id = ezcontentobject_name.contentobject_id AND
                                 ezcontentobject.current_version = ezcontentobject_name.content_version AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 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 = '103470' AND
                    ezcontentobject_version.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '103470' AND                    ezcontentobject_attribute.version = '3' AND                    ezcontentobject_attribute.language_code = 'eng-US' 
                  
                  ORDER BY
                    ezcontentclass_attribute.placement ASC,
                    ezcontentobject_attribute.language_code ASC

SELECT ezcontentobject.*,
                             ezcontentobject_tree.*,
                             ezcontentclass.serialized_name_list as class_serialized_name_list,
                             ezcontentclass.identifier as class_identifier,
                             ezcontentclass.is_container as is_container
                             , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                      FROM ezcontentobject_tree,
                           ezcontentobject,
                           ezcontentclass
                           , ezcontentobject_name 
                      WHERE  node_id IN ( 1, 43 ) and 
                            ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
                            ezcontentclass.version=0 AND
                            ezcontentclass.id = ezcontentobject.contentclass_id
                             AND  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                   ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 ) 

                      ORDER BY path_string

SELECT ezcontentobject.* , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                      FROM
                         ezcontentobject,
                         ezcontentobject_tree
                         , ezcontentobject_name 
                      WHERE
                         ezcontentobject_tree.node_id=43 AND
                         ezcontentobject.id=ezcontentobject_tree.contentobject_id AND
                         ezcontentobject.current_version=ezcontentobject_tree.contentobject_version
                          and  ezcontentobject.id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject.current_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 )

SELECT ezcontentobject.*,
             ezcontentobject_tree.*,
             ezcontentclass.serialized_name_list as class_serialized_name_list,
             ezcontentclass.identifier as class_identifier,
             ezcontentclass.is_container as is_container
          FROM   ezcontentobject_tree,
             ezcontentobject,
             ezcontentclass
          WHERE  contentobject_id=41 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

SQL for _selectOneAssoc:
SELECT * FROM ezdfsfile WHERE name_hash=MD5('var/ezwebin_site/cache/classidentifiers_97d2d6c9eaabc7f69e5aec0a60efd636.php')

RESULT:
array (
  'name' => 'var/ezwebin_site/cache/classidentifiers_97d2d6c9eaabc7f69e5aec0a60efd636.php',
  'name_trunk' => 'var/ezwebin_site/cache/classidentifiers_97d2d6c9eaabc7f69e5aec0a60efd636.php',
  'name_hash' => 'da304debd38eb36a0ca06a2dbefe6de0',
  'datatype' => 'php',
  'scope' => 'classidentifiers',
  'size' => '1794',
  'mtime' => '1296683946',
  'expired' => '0',
  'status' => '0',
)

SELECT
                    parent_node_id, contentobject_id
                  FROM
                    ezcontentobject_tree
                  WHERE contentobject_id IN ( 41 )

SELECT 
                        ezcontentclass.serialized_name_list AS class_serialized_name_list,
                        ezcontentclass.identifier as contentclass_identifier,
                        ezcontentclass.is_container as is_container,
                        ezcontentobject.* , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                     FROM
                        ezcontentclass,
                        ezcontentobject,
                        ezcontentobject_link
                        , ezcontentobject_name 
                        
                     WHERE
                        ezcontentclass.id=ezcontentobject.contentclass_id AND
                        ezcontentclass.version=0 AND
                        ezcontentobject.status=1 AND
                        
                        ezcontentobject_link.op_code='0'
                         AND ( relation_type & 1 ) <> 0 
                         AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='41' AND
                                                                      ezcontentobject_link.from_contentobject_version='1' 
                        
                         AND ezcontentobject.id = ezcontentobject_name.contentobject_id AND
                                 ezcontentobject.current_version = ezcontentobject_name.content_version AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 )

SELECT version FROM ezcontentobject_version
                                      WHERE contentobject_id='41'
                                      ORDER BY version DESC
LIMIT 0, 2

SELECT 
                        ezcontentclass.serialized_name_list AS class_serialized_name_list,
                        ezcontentclass.identifier as contentclass_identifier,
                        ezcontentclass.is_container as is_container,
                        ezcontentobject.* , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                     FROM
                        ezcontentclass,
                        ezcontentobject,
                        ezcontentobject_link
                        , ezcontentobject_name 
                        
                     WHERE
                        ezcontentclass.id=ezcontentobject.contentclass_id AND
                        ezcontentclass.version=0 AND
                        ezcontentobject.status=1 AND
                        
                        ezcontentobject_link.op_code='0'
                         AND ( relation_type & 11 ) <> 0 
                         AND ezcontentobject.id=ezcontentobject_link.from_contentobject_id AND
                                                                      ezcontentobject_link.to_contentobject_id=41 AND
                                                                      ezcontentobject_link.from_contentobject_version=ezcontentobject.current_version 
                        
                         AND ezcontentobject.id = ezcontentobject_name.contentobject_id AND
                                 ezcontentobject.current_version = ezcontentobject_name.content_version AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 )

SELECT version FROM ezcontentobject_version
                                      WHERE contentobject_id='41'
                                      ORDER BY version DESC
LIMIT 0, 2

SELECT ezcontentobject.*,
                             ezcontentobject_tree.*,
                             ezcontentclass.serialized_name_list as class_serialized_name_list,
                             ezcontentclass.identifier as class_identifier,
                             ezcontentclass.is_container as is_container
                             , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                      FROM ezcontentobject_tree,
                           ezcontentobject,
                           ezcontentclass
                           , ezcontentobject_name 
                      WHERE  node_id = 1 and 
                            ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
                            ezcontentclass.version=0 AND
                            ezcontentclass.id = ezcontentobject.contentclass_id
                             AND  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                   ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 ) 

                      ORDER BY path_string

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689784, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

BEGIN

UPDATE ezdfsfile SET mtime=-ABS(mtime), expired=1
WHERE name_trunk = 'var/ezwebin_site/cache/content/ezwebin_site_clean_user/8/4/0/84057-'

UPDATE ezdfsfile SET mtime=-ABS(mtime), expired=1
WHERE name_trunk = 'var/ezwebin_site/cache/content/ezwebin_site_clean_admin/8/4/0/84057-'

COMMIT

BEGIN

UPDATE ezdfsfile SET mtime=-ABS(mtime), expired=1
WHERE name_trunk = 'var/ezwebin_site/cache/content/ezwebin_site_clean_user/43-'

UPDATE ezdfsfile SET mtime=-ABS(mtime), expired=1
WHERE name_trunk = 'var/ezwebin_site/cache/content/ezwebin_site_clean_admin/43-'

COMMIT

BEGIN

UPDATE ezdfsfile SET mtime=-ABS(mtime), expired=1
WHERE name_trunk = 'var/ezwebin_site/cache/content/ezwebin_site_clean_user/1-'

UPDATE ezdfsfile SET mtime=-ABS(mtime), expired=1
WHERE name_trunk = 'var/ezwebin_site/cache/content/ezwebin_site_clean_admin/1-'

COMMIT

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689785, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

SELECT ezcontentobject.*,
             ezcontentobject_tree.*,
             ezcontentclass.serialized_name_list as class_serialized_name_list,
             ezcontentclass.identifier as class_identifier,
             ezcontentclass.is_container as is_container
          FROM   ezcontentobject_tree,
             ezcontentobject,
             ezcontentclass
          WHERE  contentobject_id=103470 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

SELECT DISTINCT
                     ezuser_role.role_id as role_id,
                     ezuser_role.contentobject_id as user_id
                  FROM
                     ezuser_role
                  WHERE
                     ezuser_role.limit_value = '1' AND
                     ezuser_role.limit_identifier = 'section'

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

SELECT id, version, name, is_new
                    FROM   ezrole WHERE  id='8'

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

SELECT id, version, name, is_new
                    FROM   ezrole WHERE  id='11'

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

SELECT id, version, name, is_new
                    FROM   ezrole WHERE  id='3'

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

SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 64 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 7 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 )

SELECT DISTINCT
                       ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                       
                       
                   FROM
                      ezcontentobject_tree,
                      ezcontentobject,ezcontentclass
                      , ezcontentobject_name 
                      
                      
                      
                      
                   WHERE
                       ezcontentobject_tree.path_string like '/1/5/64/%' and  ezcontentobject_tree.depth <= 5  and  
                      
                      
                      
                      ezcontentclass.version=0 AND
                      ezcontentobject_tree.node_id != 64 AND
                      ezcontentobject_tree.contentobject_id = ezcontentobject.id  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id AND
                      
                      
                       ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                   ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 ) 

                      
                      
                      
                       AND 
 ezcontentobject.language_mask & 7 > 0 

                 ORDER BY  path_string ASC

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

SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 84057 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 7 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 )

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='3' AND contentobject_id='103470' ORDER BY version ASC

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

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

SELECT ezcontentobject.*,
             ezcontentobject_tree.*,
             ezcontentclass.serialized_name_list as class_serialized_name_list,
             ezcontentclass.identifier as class_identifier,
             ezcontentclass.is_container as is_container
          FROM   ezcontentobject_tree,
             ezcontentobject,
             ezcontentclass
          WHERE  contentobject_id=103470 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

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

SELECT node_id, count
                    FROM   ezview_counter WHERE  node_id='84057'

SELECT
                    COUNT( outer_object.id ) AS count
                  FROM
                    ezcontentobject outer_object, ezcontentobject inner_object, ezcontentobject_link outer_link
                  INNER JOIN
                    ezcontentobject_link inner_link ON outer_link.id = inner_link.id
                  WHERE
                    outer_object.id = outer_link.from_contentobject_id
                    AND outer_object.status = 1
                    AND inner_object.id = inner_link.from_contentobject_id
                    AND inner_object.status = 1
                    AND inner_link.op_code = 0
                     AND inner_link.to_contentobject_id = 103470
                                 AND inner_link.from_contentobject_version = inner_object.current_version
                     AND ( inner_link.relation_type & 7 ) <> 0

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='103470' AND version='3'
                  
                  ORDER BY language_code

SELECT value FROM ezsite_data WHERE name='ezfind_site_id'

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '103470'
                       AND content_version = '3'
                       AND ( content_translation = 'eng-US' OR language_id = '2' )

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

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '103280'
                       AND content_version = '2'
                       AND ( content_translation = 'eng-US' OR language_id = '2' )

SELECT
                    parent_node_id, contentobject_id
                  FROM
                    ezcontentobject_tree
                  WHERE contentobject_id IN ( 103280 )

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

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

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 = '3' AND
                    ezcontentobject_attribute.contentobject_id = '103470' AND
                    ezcontentobject_version.contentobject_id = '103470' AND
                    ezcontentobject_version.version = '3' AND ezcontentobject_attribute.language_code = 'eng-US' ORDER by
                    ezcontentclass_attribute.placement ASC

INSERT INTO eznotificationevent (status, event_type_string, data_int1, data_int2, data_int3, data_int4, data_text1, data_text2, data_text3, data_text4) VALUES(0, 'ezpublish', 103470, 3, 0, 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  contentobject_id='103470' AND status='5' AND creator_id='103280' ORDER BY version ASC

SELECT id, module_name, function_name, connect_type, workflow_id, name
                    FROM   eztrigger WHERE  name='post_publish' AND module_name='content' AND function_name='publish'

SELECT id, version, is_enabled, workflow_type_string, name, creator_id, modifier_id,       created, modified
                    FROM   ezworkflow WHERE  id='7' AND version='0'

SELECT id, process_key, workflow_id, user_id, content_id, content_version, session_key,       node_id, event_id, event_position, event_state, last_event_id, last_event_position, last_event_status,       event_status, created, modified, activation_date, status, parameters, memento_key
                    FROM   ezworkflow_process WHERE  process_key='019309c328b8f2d22dcf80995285a7ac' ORDER BY user_id ASC

INSERT INTO ezworkflow_process (process_key, workflow_id, user_id, content_id, content_version, session_key, node_id, event_id, event_position, event_state, last_event_id, last_event_position, last_event_status, event_status, created, modified, activation_date, status, parameters, memento_key) VALUES('019309c328b8f2d22dcf80995285a7ac', 7, 103280, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 1296689805, 1296689805, 0, 0, 'a:7:{s:9:\"object_id\";s:6:\"103470\";s:7:\"version\";s:1:\"3\";s:11:\"workflow_id\";s:1:\"7\";s:12:\"trigger_name\";s:12:\"post_publish\";s:11:\"module_name\";s:7:\"content\";s:15:\"module_function\";s:7:\"publish\";s:7:\"user_id\";s:6:\"103280\";}', '')

SELECT id, version, is_enabled, workflow_type_string, name, creator_id, modifier_id,       created, modified
                    FROM   ezworkflow WHERE  id='7' AND version='0'

SELECT id, version, workflow_id, workflow_type_string, description, data_int1, data_int2,       data_int3, data_int4, data_text1, data_text2, data_text3, data_text4, data_text5,       placement
                    FROM   ezworkflow_event WHERE  id='0' AND version='0'

SELECT id, placement
                    FROM   ezworkflow_event WHERE  workflow_id='7' AND version='0' ORDER BY placement ASC
LIMIT 0, 1

SELECT id, version, workflow_id, workflow_type_string, description, data_int1, data_int2,       data_int3, data_int4, data_text1, data_text2, data_text3, data_text4, data_text5,       placement
                    FROM   ezworkflow_event WHERE  id='4' AND version='0'

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

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'No state yet'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Accepted event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Rejected event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event deferred to cron job'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event deferred to cron job, event will be rerun'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event runs a sub event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Canceled whole workflow'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Workflow was reset for reuse'

SELECT id, placement
                    FROM   ezworkflow_event WHERE  workflow_id='7' AND version='0' ORDER BY placement ASC
LIMIT 1, 1

SELECT id, version, workflow_id, workflow_type_string, description, data_int1, data_int2,       data_int3, data_int4, data_text1, data_text2, data_text3, data_text4, data_text5,       placement
                    FROM   ezworkflow_event WHERE  id='8' AND version='0'

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

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'No state yet'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Accepted event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Rejected event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event deferred to cron job'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event deferred to cron job, event will be rerun'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event runs a sub event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Canceled whole workflow'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689805, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Workflow was reset for reuse'

SELECT id, placement
                    FROM   ezworkflow_event WHERE  workflow_id='7' AND version='0' ORDER BY placement ASC
LIMIT 2, 1

SELECT id, version, workflow_id, workflow_type_string, description, data_int1, data_int2,       data_int3, data_int4, data_text1, data_text2, data_text3, data_text4, data_text5,       placement
                    FROM   ezworkflow_event WHERE  id='25' AND version='0'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689806, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'No state yet'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689806, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Accepted event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689806, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Rejected event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689806, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event deferred to cron job'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689806, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event deferred to cron job, event will be rerun'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689806, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Event runs a sub event'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689806, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Canceled whole workflow'

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689806, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'kernel/classes'. The untranslated message is: 'Workflow was reset for reuse'

SELECT id, placement
                    FROM   ezworkflow_event WHERE  workflow_id='7' AND version='0' ORDER BY placement ASC
LIMIT 3, 1

SELECT id
                    FROM   ezworkflow_process WHERE  id='303066'

UPDATE ezworkflow_process SET process_key='019309c328b8f2d22dcf80995285a7ac', workflow_id=7,
    user_id=103280, content_id=0, content_version=0, session_key='0', node_id=0,
    event_id=0, event_position=0, event_state=0, last_event_id=25,
    last_event_position=3, last_event_status=0, event_status=1, created=1296689805,
    modified=1296689806, activation_date=0, status=2,
    parameters='a:7:{s:9:\"object_id\";s:6:\"103470\";s:7:\"version\";s:1:\"3\";s:11:\"workflow_id\";s:1:\"7\";s:12:\"trigger_name\";s:12:\"post_publish\";s:11:\"module_name\";s:7:\"content\";s:15:\"module_function\";s:7:\"publish\";s:7:\"user_id\";s:6:\"103280\";}', memento_key='' WHERE  id='303066'

DELETE FROM ezworkflow_process  WHERE  id='303066'

COMMIT

SELECT ezcontentobject.*,
             ezcontentobject_tree.*,
             ezcontentclass.serialized_name_list as class_serialized_name_list,
             ezcontentclass.identifier as class_identifier,
             ezcontentclass.is_container as is_container
          FROM   ezcontentobject_tree,
             ezcontentobject,
             ezcontentclass
          WHERE  contentobject_id=103470 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

BEGIN WORK

SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 43 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 7 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 )

COMMIT

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '103470'
                       AND content_version = '3'
                       AND ( content_translation = 'eng-US' OR language_id = '2' )

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

SELECT ezcontentobject.*,
                       ezcontentobject_tree.*,
                       ezcontentclass.serialized_name_list as class_serialized_name_list,
                       ezcontentclass.identifier as class_identifier,
                       ezcontentclass.is_container as is_container
                       , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                FROM ezcontentobject_tree,
                     ezcontentobject,
                     ezcontentclass
                     , ezcontentobject_name 
                WHERE node_id = 84057 AND 
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_id
                       AND 
 ezcontentobject.language_mask & 7 > 0 

                       and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                  ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
   <

     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) << 1 )
 )

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

Translation cache for context 'cachecontexts' already exists

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/ezwebin_site/cache/expiry.php', 'var/ezwebin_site/cache/expiry.php', '5e18ccd58f44eeee23cf8ea4aef11c63', 'expirycache', 775, 1296689806, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/ezwebin_site/cache/expiry.php', scope=VALUES(scope), size=VALUES(size), mtime=VALUES(mtime), expired=VALUES(expired)

COMMIT

Missing translation for message in context: 'lib/template'. The untranslated message is: 'The maximum nesting level of %max has been reached. The execution is stopped to avoid infinite recursion.'

End