eZ debug

Script start

SET NAMES 'utf8'

SELECT data, user_id, user_hash, expiration_time FROM ezsession WHERE session_key='f82d3bc679779918dab52381155f2ad4'

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

RESULT:
array (
  'name' => 'var/cache/expiry.php',
  'name_trunk' => 'var/cache/expiry.php',
  'name_hash' => '27c1b0b01c82304c9aaadf79a9853510',
  'datatype' => 'misc',
  'scope' => 'expirycache',
  'size' => '766',
  'mtime' => '1270554882',
  'expired' => '0',
  'status' => '0',
)

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

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

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

RESULT:
array (
  'name' => 'var/cache/ezcontentlanguage_cache.php',
  'name_trunk' => 'var/cache/ezcontentlanguage_cache.php',
  'name_hash' => '6c8233c8ef8ee3ec05a3c134e367ee0d',
  'datatype' => 'php',
  'scope' => 'content',
  'size' => '349',
  'mtime' => '1269012420',
  '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( '419138' )
AND e3.parent = e2.link AND (e3.lang_mask & 7 > 0) AND e3.text_md5 =  MD5( '6' )
AND e4.parent = e3.link AND (e4.lang_mask & 7 > 0) AND e4.text_md5 =  MD5( 'ger-de' )
LIMIT 0, 1

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

RESULT:
array (
  'name' => 'var/cache/wildcard/wildcard_6a50f9f9e1ac54509c3c6d51d6182b82_index.php',
  'name_trunk' => 'var/cache/wildcard/wildcard_6a50f9f9e1ac54509c3c6d51d6182b82_index.php',
  'name_hash' => '0d09ba3496f53f27a9bd4402d2de7aa8',
  'datatype' => 'php',
  'scope' => 'wildcard-cache-index',
  'size' => '99',
  'mtime' => '1270132391',
  'expired' => '0',
  'status' => '0',
)

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

RESULT:
array (
  'name' => 'var/cache/statelimitations_4fcb130eb3b47f0d3916d1cd92a5b4be.php',
  'name_trunk' => 'var/cache/statelimitations_4fcb130eb3b47f0d3916d1cd92a5b4be.php',
  'name_hash' => 'b3bc9578ca347ea34c9af9d994abed2d',
  'datatype' => 'php',
  'scope' => 'statelimitations',
  'size' => '39',
  'mtime' => '1270132434',
  '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='419138' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.version=0

SELECT id, version, serialized_name_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='23' 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='6' AND contentobject_id='419138'
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='6' AND contentobject_id='419138'
ORDER BY version ASC

SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
                    WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
                          contentobject_id=419138

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 = '6' AND
                    ezcontentobject_attribute.contentobject_id = '419138' AND
                    ezcontentobject_version.contentobject_id = '419138' AND
                    ezcontentobject_version.version = '6' AND ezcontentobject_attribute.language_code = 'ger-DE' ORDER by
                    ezcontentclass_attribute.placement ASC

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

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=419138 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, 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
                    FROM   ezcontentclass_attribute
WHERE  id='235' AND version='0'

SELECT id, serialized_name_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
                    FROM   ezcontentclass_attribute
WHERE  id='328' AND version='0'

SELECT id, serialized_name_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
                    FROM   ezcontentclass_attribute
WHERE  id='657' AND version='0'

SELECT id, serialized_name_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
                    FROM   ezcontentclass_attribute
WHERE  id='678' AND version='0'

SELECT id, serialized_name_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
                    FROM   ezcontentclass_attribute
WHERE  id='679' AND version='0'

SELECT id, serialized_name_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
                    FROM   ezcontentclass_attribute
WHERE  id='343' AND version='0'

SELECT id, serialized_name_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
                    FROM   ezcontentclass_attribute
WHERE  id='545' AND version='0'

SELECT id, serialized_name_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
                    FROM   ezcontentclass_attribute
WHERE  id='341' AND version='0'

SELECT id, serialized_name_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
                    FROM   ezcontentclass_attribute
WHERE  id='342' AND version='0'

SELECT id, serialized_name_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
                    FROM   ezcontentclass_attribute
WHERE  id='638' AND version='0'

SELECT id, serialized_name_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
                    FROM   ezcontentclass_attribute
WHERE  id='236' AND version='0'

SELECT id, serialized_name_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
                    FROM   ezcontentclass_attribute
WHERE  id='237' AND version='0'

SELECT id, serialized_name_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
                    FROM   ezcontentclass_attribute
WHERE  id='445' AND version='0'

SELECT id, serialized_name_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
                    FROM   ezcontentclass_attribute
WHERE  id='446' AND version='0'

DELETE FROM ezurl_object_link
WHERE  contentobject_attribute_id='5718101' AND contentobject_attribute_version='6'

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='419138' AND
                                                                      ezcontentobject_link.from_contentobject_version='6'

                         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='419138' AND
                                                                      ezcontentobject_link.from_contentobject_version='6'

                         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 = '419138' AND
                    ezcontentobject_version.version = '5' AND
                    ezcontentobject_attribute.contentobject_id = '419138' AND
                    ezcontentobject_attribute.version = '5' AND
                    ezcontentobject_attribute.language_code = 'ger-DE'

                  ORDER BY
                    ezcontentclass_attribute.placement ASC,
                    ezcontentobject_attribute.language_code ASC

BEGIN WORK

SELECT id
                    FROM   ezcontentobject_version
WHERE  id='625037'

UPDATE ezcontentobject_version
SET contentobject_id=419138, creator_id=197341, version=6, status=0,
    created=1270555043, modified=1270555097, workflow_event_pos=0, user_id=0,
    language_mask=3, initial_language_id=2
WHERE  id='625037'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute
WHERE  id='5718088' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=235,
    attribute_original_id=0, sort_key_int=0, sort_key_string='blocktest',
    data_type_string='ezstring', data_text='Blocktest', data_int=NULL, data_float=0.000000
WHERE  id='5718088' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute
WHERE  id='5718089' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=328,
    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='5718089' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute
WHERE  id='5718090' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=657,
    attribute_original_id=0, sort_key_int=1, sort_key_string='', data_type_string='ezboolean',
    data_text='', data_int=1, data_float=0.000000
WHERE  id='5718090' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute
WHERE  id='5718091' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=678,
    attribute_original_id=0, sort_key_int=0, sort_key_string='', data_type_string='ezboolean',
    data_text='', data_int=0, data_float=0.000000
WHERE  id='5718091' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute
WHERE  id='5718092' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=679,
    attribute_original_id=0, sort_key_int=0, sort_key_string='', data_type_string='ezboolean',
    data_text='', data_int=0, data_float=0.000000
WHERE  id='5718092' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute
WHERE  id='5718093' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=343,
    attribute_original_id=0, sort_key_int=0, sort_key_string='0',
    data_type_string='ezselection', data_text='0', data_int=NULL, data_float=0.000000
WHERE  id='5718093' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

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

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='419138' AND version='6'

                  ORDER BY language_code

DELETE FROM ezcontentobject_link
                         WHERE       from_contentobject_id=419138 AND
                                     from_contentobject_version=6 AND contentclassattribute_id=545  AND
                                     op_code='0'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute
WHERE  id='5718094' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=545,
    attribute_original_id=0, sort_key_int=0, sort_key_string='',
    data_type_string='ezobjectrelation', data_text='', data_int=NULL, data_float=0.000000
WHERE  id='5718094' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

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

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='419138' AND version='6'

                  ORDER BY language_code

DELETE FROM ezcontentobject_link
                         WHERE       from_contentobject_id=419138 AND
                                     from_contentobject_version=6 AND contentclassattribute_id=341  AND
                                     op_code='0'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute
WHERE  id='5718095' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=341,
    attribute_original_id=0, sort_key_int=0, sort_key_string='',
    data_type_string='ezobjectrelation', data_text='', data_int=NULL, data_float=0.000000
WHERE  id='5718095' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

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

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='419138' AND version='6'

                  ORDER BY language_code

DELETE FROM ezcontentobject_link
                         WHERE       from_contentobject_id=419138 AND
                                     from_contentobject_version=6 AND contentclassattribute_id=342  AND
                                     op_code='0'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute
WHERE  id='5718096' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=342,
    attribute_original_id=0, sort_key_int=0, sort_key_string='',
    data_type_string='ezobjectrelation', data_text='', data_int=NULL, data_float=0.000000
WHERE  id='5718096' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

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

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='419138' AND version='6'

                  ORDER BY language_code

DELETE FROM ezcontentobject_link
                         WHERE       from_contentobject_id=419138 AND
                                     from_contentobject_version=6 AND contentclassattribute_id=638  AND
                                     op_code='0'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute
WHERE  id='5718097' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=638,
    attribute_original_id=0, sort_key_int=0, sort_key_string='',
    data_type_string='ezobjectrelation', data_text='', data_int=NULL, data_float=0.000000
WHERE  id='5718097' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute
WHERE  id='5718098' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=236,
    attribute_original_id=0, sort_key_int=0, sort_key_string='', data_type_string='ezpage',
    data_text='<?xml version=\"1.0\"?>\n<page>\n  <zone_layout>2ZonesLayout_quer</zone_layout>\n  <zone id=\"id_2103367d887d6844ec512110283143f8\">\n    <zone_identifier>head</zone_identifier>\n    <block id=\"id_d3254921185d5578fac2578c3acbb598\">\n      <name>Wirtschafts Aufmacher</name>\n      <zone_id>2103367d887d6844ec512110283143f8</zone_id>\n      <type>head_topnews6news</type>\n      <view>head_topnews6news_1_source</view>\n      <overflow_id></overflow_id>\n    </block>\n  </zone>\n  <zone id=\"id_ec1e2a0ac8eb6615ca098dd9f3e8b178\">\n    <zone_identifier>left</zone_identifier>\n    <block id=\"id_77bb9bbc49c496c7e4ebcc4981736fba\">\n      <name>News aus Niedersachsen</name>\n      <zone_id>ec1e2a0ac8eb6615ca098dd9f3e8b178</zone_id>\n      <type>left_newswithanimation1quell</type>\n      <view>left_newswithanimation1quell</view>\n      <overflow_id></overflow_id>\n      <fetch_params>a:1:{s:6:\"Source\";s:3:\"625\";}</fetch_params>\n    </block>\n    <block id=\"id_37283fed5178299764ec0786145b9fbc\">\n      <name>Politik Niedersachsen</name>\n      <zone_id>ec1e2a0ac8eb6615ca098dd9f3e8b178</zone_id>\n      <type>left_newswithimageand35linksfromrubric</type>\n      <view>left_newswithimageand35linksfromrubric</view>\n      <overflow_id></overflow_id>\n    </block>\n    <block id=\"id_5b57980e6f16a9af89790b7268099dd1\">\n      <name>Nachricht ohne Bild</name>\n      <zone_id>ec1e2a0ac8eb6615ca098dd9f3e8b178</zone_id>\n      <type>left_newswithoutimage</type>\n      <view>left_newswithoutimage</view>\n      <overflow_id></overflow_id>\n    </block>\n    <block id=\"id_e458a42a61d39ea7f8ad1e88859a1ac4\">\n      <name>Nachricht ohne Bild, 1 Quelle</name>\n      <zone_id>ec1e2a0ac8eb6615ca098dd9f3e8b178</zone_id>\n      <type>left_newswithoutimage1quell</type>\n      <view>left_newswithoutimage1quell</view>\n      <overflow_id></overflow_id>\n      <fetch_params>a:1:{s:6:\"Source\";s:4:\"1727\";}</fetch_params>\n    </block>\n    <block id=\"id_63f0d5e8a55dfe27e9e99918974c1a01\">\n      <name></name>\n      <zone_id>ec1e2a0ac8eb6615ca098dd9f3e8b178</zone_id>\n      <type>left_kalender2sp</type>\n      <view>left_kalender2sp</view>\n      <overflow_id></overflow_id>\n      <item action=\"add\">\n        <object_id>1772</object_id>\n        <node_id>1720</node_id>\n        <priority>1</priority>\n        <ts_publication>1270555083</ts_publication>\n      </item>\n    </block>\n  </zone>\n  <zone id=\"id_1ff71c8d15b6db1b52e3c1a7b35e6152\">\n    <zone_identifier>right</zone_identifier>\n    <block id=\"id_27a615f2f06561c6230f31af8c6d3941\">\n      <name></name>\n      <zone_id>1ff71c8d15b6db1b52e3c1a7b35e6152</zone_id>\n      <type>right_imageoftheday</type>\n      <view>right_imageoftheday</view>\n      <overflow_id></overflow_id>\n    </block>\n  </zone>\n</page>\n', data_int=NULL, data_float=0.000000
WHERE  id='5718098' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

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

SELECT ezkeyword.id, ezkeyword.keyword FROM ezkeyword, ezkeyword_attribute_link
                                                   WHERE ezkeyword.id=ezkeyword_attribute_link.keyword_id
                                                   AND ezkeyword_attribute_link.objectattribute_id='5718099'

SELECT ezkeyword.id FROM ezkeyword LEFT JOIN ezkeyword_attribute_link  ON ezkeyword.id=ezkeyword_attribute_link.keyword_id WHERE ezkeyword_attribute_link.keyword_id IS NULL

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute
WHERE  id='5718099' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=237,
    attribute_original_id=0, sort_key_int=0, sort_key_string='', data_type_string='ezkeyword',
    data_text='', data_int=NULL, data_float=0.000000
WHERE  id='5718099' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

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

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='419138' AND version='6'

                  ORDER BY language_code

DELETE FROM ezcontentobject_link
                         WHERE       from_contentobject_id=419138 AND
                                     from_contentobject_version=6 AND contentclassattribute_id=445  AND
                                     op_code='0'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute
WHERE  id='5718100' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=445,
    attribute_original_id=0, sort_key_int=0, sort_key_string='',
    data_type_string='ezobjectrelation', data_text='', data_int=NULL, data_float=0.000000
WHERE  id='5718100' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

SELECT id, contentobject_id, version, language_code
                    FROM   ezcontentobject_attribute
WHERE  id='5718101' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=446,
    attribute_original_id=0, sort_key_int=0, sort_key_string='', data_type_string='ezurl',
    data_text='', data_int=0, data_float=0.000000
WHERE  id='5718101' AND contentobject_id='419138' AND version='6' AND language_code='ger-DE'

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 = 419138 AND
                ezcontentobject_version.version = 6 AND
                ezcontentobject_attribute.contentobject_id = 419138

                AND
		ezcontentobject_attribute.language_code IN ( 'ger-DE' )

                AND
		 ezcontentobject_attribute.version = '6'

                AND
                identifier IN ( 'name' )

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

RESULT:
array (
  'name' => 'var/cache/classattributeidentifiers_4fcb130eb3b47f0d3916d1cd92a5b4be.php',
  'name_trunk' => 'var/cache/classattributeidentifiers_4fcb130eb3b47f0d3916d1cd92a5b4be.php',
  'name_hash' => 'fd37aa249bba9f8e0d0480effd2664ac',
  'datatype' => 'php',
  'scope' => 'classattributeidenti',
  'size' => '24923',
  'mtime' => '1270132436',
  'expired' => '0',
  'status' => '0',
)

SELECT COUNT(*) AS count FROM ezcontentobject_name WHERE contentobject_id = '419138'
                                 AND content_version = '6' AND content_translation ='ger-DE'

UPDATE ezcontentobject_name SET name='Blocktest'
                         WHERE
                         contentobject_id = '419138'  AND
                         content_version = '6' AND
                         content_translation ='ger-DE'

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='419138' AND contentobject_version='6'

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

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '419138'
                       AND content_version = '5'
                       AND ( content_translation = 'ger-DE' OR language_id = '2' )

BEGIN WORK

SELECT id, main, memento_key, main_key, memento_data
                    FROM   ezoperation_memento
WHERE  memento_key='0a6f326f87d670f1bdf9066ddb464320' AND main='1'

SELECT id, main, memento_key, main_key, memento_data
                    FROM   ezoperation_memento
WHERE  memento_key='0a6f326f87d670f1bdf9066ddb464320' AND main='0'

SELECT id
                    FROM   ezcontentobject_version
WHERE  id='625037'

UPDATE ezcontentobject_version
SET contentobject_id=419138, creator_id=197341, version=6, status=2,
    created=1270555043, modified=1270555097, workflow_event_pos=0, user_id=0,
    language_mask=3, initial_language_id=2
WHERE  id='625037'

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='419138' 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='6' AND contentobject_id='419138'
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='419138' AND contentobject_version='6' 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='5' AND contentobject_id='419138'
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 ezcontentobject_tree.contentobject_id=419138 AND
                          ezcontentobject_tree.main_node_id = ezcontentobject_tree.node_id AND
                          ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                          ezcontentclass.version=0  AND
                          ezcontentclass.id = ezcontentobject.contentclass_id

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='1' 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='ef81e8417b5452c006e5bd936e0c9d3a'
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('ef81e8417b5452c006e5bd936e0c9d3a', 1, 197341, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 1270555098, 1270555098, 0, 0, 'a:7:{s:9:\"object_id\";s:6:\"419138\";s:7:\"version\";s:1:\"6\";s:11:\"workflow_id\";s:1:\"1\";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:\"197341\";}', '')

SELECT id, version, is_enabled, workflow_type_string, name, creator_id, modifier_id,
       created, modified
                    FROM   ezworkflow
WHERE  id='1' 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='1' 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='1' AND version='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 = '6' AND
                    ezcontentobject_attribute.contentobject_id = '419138' AND
                    ezcontentobject_version.contentobject_id = '419138' AND
                    ezcontentobject_version.version = '6' AND ezcontentobject_attribute.language_code = 'ger-DE' ORDER by
                    ezcontentclass_attribute.placement ASC

SELECT id, workflow_event_id, workflow_event_version, contentclass_id, contentclass_attribute_id
                    FROM   ezwaituntildatevalue
WHERE  workflow_event_id='1' AND workflow_event_version='0'
ORDER BY id ASC

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

SELECT id
                    FROM   ezworkflow_process
WHERE  id='812852'

UPDATE ezworkflow_process
SET process_key='ef81e8417b5452c006e5bd936e0c9d3a', workflow_id=1,
    user_id=197341, content_id=0, content_version=0, session_key='0', node_id=0,
    event_id=0, event_position=0, event_state=0, last_event_id=1,
    last_event_position=1, last_event_status=0, event_status=1, created=1270555098,
    modified=1270555098, activation_date=0, status=2,
    parameters='a:7:{s:9:\"object_id\";s:6:\"419138\";s:7:\"version\";s:1:\"6\";s:11:\"workflow_id\";s:1:\"1\";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:\"197341\";}', memento_key=''
WHERE  id='812852'

DELETE FROM ezworkflow_process
WHERE  id='812852'

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

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='419138' AND version='5'

                  ORDER BY language_code

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='419138' AND version='6'

                  ORDER BY language_code

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='419138' AND version='6'

                  ORDER BY language_code

SELECT id
                    FROM   ezcontentobject_version
WHERE  id='625037'

UPDATE ezcontentobject_version
SET contentobject_id=419138, creator_id=197341, version=6, status=2,
    created=1270555043, modified=1270555097, workflow_event_pos=0, user_id=0,
    language_mask=3, initial_language_id=2
WHERE  id='625037'

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

SELECT id
                    FROM   ezcontentobject_version
WHERE  id='625036'

UPDATE ezcontentobject_version
SET contentobject_id=419138, creator_id=197341, version=5, status=3,
    created=1270551977, modified=1270554866, workflow_event_pos=0, user_id=0,
    language_mask=3, initial_language_id=2
WHERE  id='625036'

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='419138' 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='6' AND contentobject_id='419138'
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='419138' AND contentobject_version='6'

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='419138' AND contentobject_version='6' AND parent_node='70531'

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 = 70531 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 = 70531 AND
                      contentobject_id = 419138 AND
                      ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                      ezcontentclass.version=0  AND
                      ezcontentclass.id = ezcontentobject.contentclass_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 ezcontentobject_tree.contentobject_id=419138 AND
                          ezcontentobject_tree.main_node_id = ezcontentobject_tree.node_id AND
                          ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                          ezcontentclass.version=0  AND
                          ezcontentclass.id = ezcontentobject.contentclass_id

SELECT id
                    FROM   ezcontentobject_version
WHERE  id='625037'

UPDATE ezcontentobject_version
SET contentobject_id=419138, creator_id=197341, version=6, status=1,
    created=1270555043, modified=1270555097, workflow_event_pos=0, user_id=0,
    language_mask=3, initial_language_id=2
WHERE  id='625037'

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

SELECT to_contentobject_id, relation_type FROM ezcontentobject_link
                                                WHERE contentclassattribute_id='0'
                                                  AND from_contentobject_id='419138'
                                                  AND from_contentobject_version='5'
                                                  AND op_code='0'

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

DELETE FROM ezcontentobject_link
                     WHERE contentclassattribute_id='0'
                       AND from_contentobject_id='419138'
                       AND from_contentobject_version='6'

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='419138' AND version='6'

                  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 = 419138 AND
                ezcontentobject_version.version = 6 AND
                ezcontentobject_attribute.contentobject_id = 419138

                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 = '6'

                AND
                identifier IN ( 'name' )

SELECT COUNT(*) AS count FROM ezcontentobject_name WHERE contentobject_id = '419138'
                                 AND content_version = '6' AND content_translation ='ger-DE'

UPDATE ezcontentobject_name SET name='Blocktest'
                         WHERE
                         contentobject_id = '419138'  AND
                         content_version = '6' AND
                         content_translation ='ger-DE'

SELECT DISTINCT language_code
                  FROM ezcontentobject_attribute
                  WHERE contentobject_id='419138' AND version='6'

                  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 = 419138 AND
                ezcontentobject_version.version = 6 AND
                ezcontentobject_attribute.contentobject_id = 419138

                AND
		ezcontentobject_attribute.language_code IN ( 'ger-DE' )

                AND
		 ezcontentobject_attribute.version = '6'

                AND
                identifier IN ( 'name' )

SELECT COUNT(*) AS count FROM ezcontentobject_name WHERE contentobject_id = '419138'
                                 AND content_version = '6' AND content_translation ='ger-DE'

UPDATE ezcontentobject_name SET name='Blocktest'
                         WHERE
                         contentobject_id = '419138'  AND
                         content_version = '6' AND
                         content_translation ='ger-DE'

SELECT id
                    FROM   ezcontentobject_version
WHERE  id='625037'

UPDATE ezcontentobject_version
SET contentobject_id=419138, creator_id=197341, version=6, status=1,
    created=1270555043, modified=1270555097, workflow_event_pos=0, user_id=0,
    language_mask=3, initial_language_id=2
WHERE  id='625037'

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=419138 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=1270555098 WHERE node_id='1' OR node_id='2' OR node_id='87' OR node_id='70531' OR node_id='447385'

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '419138'
                       AND content_version = '6'
                       AND ( content_translation = 'ger-DE' OR language_id = '2' )

SELECT id
                    FROM   ezcontentobject
WHERE  id='419138'

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '419138'
                       AND content_version = '6'
                       AND ( content_translation = 'ger-DE' OR language_id = '2' )

UPDATE ezcontentobject
SET section_id=1, owner_id=197341, contentclass_id=23,
    name='Blocktest', is_published=0, published=1270548293, modified=1270555098,
    current_version=6, status=1, remote_id='ff4921152fdc8df3ee05b92fd60b8ebe',
    language_mask=2, initial_language_id=2
WHERE  id='419138'

UPDATE ezcontentobject_tree SET contentobject_version='6' WHERE contentobject_id='419138'

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=419138 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 = '419138'
                       AND content_version = '6'
                       AND ( content_translation = 'ger-DE' 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 = 419138 AND
                ezcontentobject_version.version = 6 AND
                ezcontentobject_attribute.contentobject_id = 419138

                AND
		ezcontentobject_attribute.language_code IN ( 'ger-DE' )

                AND
		 ezcontentobject_attribute.version = '6'

                AND
                identifier IN ( 'name' )

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

SELECT * FROM ezurlalias_ml WHERE parent = 84810 AND action != 'eznode:447385'  AND text_md5 =  MD5( 'blocktest' )  AND is_original = 1

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

SELECT * FROM ezurlalias_ml WHERE  action = 'eznode:70531' 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 = 70531 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 = 84810

SELECT * FROM ezurlalias_ml WHERE parent = 84810 AND text_md5 =  MD5( 'blocktest' )

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

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

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

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

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

UPDATE ezurlalias_ml SET link = 377902, is_alias = 0, is_original = 0
WHERE action = 'eznode:447385' AND is_original = 0 AND is_alias = 0 AND (cast(lang_mask & 2 AS SIGNED )  > 0) AND (parent != 84810 OR text_md5 !=  MD5( 'blocktest' ) )

SELECT id FROM ezurlalias_ml
WHERE action = 'eznode:447385' AND is_alias = 0 AND (parent != 84810 OR text_md5 !=  MD5( 'blocktest' ) )

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

SELECT id, name, hash, contentobject_id, contentobject_version, output_format, design_to_use,
       send_date, send_status, newslettertype_id, category, pretext, posttext, object_relations,
       preview_email, preview_mobile, recurrence_type, recurrence_value, recurrence_condition, recurrence_last_sent, status,
       created, creator_id
                    FROM   eznewsletter
WHERE  contentobject_id='419138' AND contentobject_version='6' AND status='0'

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='419138' 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='6' AND contentobject_id='419138'
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=419138 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='419138' AND contentobject_version='6'

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=419138 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 = '419138' AND
                    ezcontentobject_version.version = '6' AND
                    ezcontentobject_attribute.contentobject_id = '419138' AND
                    ezcontentobject_attribute.version = '6' AND
                    ezcontentobject_attribute.language_code = 'ger-DE'

                  ORDER BY
                    ezcontentclass_attribute.placement ASC,
                    ezcontentobject_attribute.language_code ASC

UPDATE ezm_block SET name='Wirtschafts Aufmacher',
                                                                      overflow_id='',
                                                                      fetch_params='',
                                                                      rotation_type='0',
                                                                      rotation_interval='0'
                                                            WHERE id='d3254921185d5578fac2578c3acbb598'

UPDATE ezm_block SET name='News aus Niedersachsen',
                                                                      overflow_id='',
                                                                      fetch_params='a:1:{s:6:"Source";s:3:"625";}',
                                                                      rotation_type='0',
                                                                      rotation_interval='0'
                                                            WHERE id='77bb9bbc49c496c7e4ebcc4981736fba'

UPDATE ezm_block SET name='Politik Niedersachsen',
                                                                      overflow_id='',
                                                                      fetch_params='',
                                                                      rotation_type='0',
                                                                      rotation_interval='0'
                                                            WHERE id='37283fed5178299764ec0786145b9fbc'

UPDATE ezm_block SET name='Nachricht ohne Bild',
                                                                      overflow_id='',
                                                                      fetch_params='',
                                                                      rotation_type='0',
                                                                      rotation_interval='0'
                                                            WHERE id='5b57980e6f16a9af89790b7268099dd1'

UPDATE ezm_block SET name='Nachricht ohne Bild, 1 Quelle',
                                                                      overflow_id='',
                                                                      fetch_params='a:1:{s:6:"Source";s:4:"1727";}',
                                                                      rotation_type='0',
                                                                      rotation_interval='0'
                                                            WHERE id='e458a42a61d39ea7f8ad1e88859a1ac4'

UPDATE ezm_block SET name='',
                                                                      overflow_id='',
                                                                      fetch_params='',
                                                                      rotation_type='0',
                                                                      rotation_interval='0'
                                                            WHERE id='63f0d5e8a55dfe27e9e99918974c1a01'

SELECT COUNT( * ) as count FROM ezm_pool
                                                              WHERE block_id='63f0d5e8a55dfe27e9e99918974c1a01'
                                                                 AND object_id='1772'

INSERT INTO ezm_pool ( block_id, object_id, node_id, priority, ts_publication )
                                            VALUES ( '63f0d5e8a55dfe27e9e99918974c1a01',
                                                     '1772',
                                                     '1720',
                                                     '1',
                                                     '1270555083'  )

UPDATE ezm_block SET name='',
                                                                      overflow_id='',
                                                                      fetch_params='',
                                                                      rotation_type='0',
                                                                      rotation_interval='0'
                                                            WHERE id='27a615f2f06561c6230f31af8c6d3941'

SELECT id
                         FROM ezm_block
                         WHERE is_removed=1

SELECT DISTINCT node_id
                         FROM ezm_block

SELECT *
                                FROM ezm_block
                                WHERE node_id=77

SELECT * FROM ezm_block WHERE id='0b9a6658e2b387ab90eeec35f9ffa95d'

UPDATE ezm_block SET last_update=1270555094 WHERE id='0b9a6658e2b387ab90eeec35f9ffa95d'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='0b9a6658e2b387ab90eeec35f9ffa95d'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='24aeec63a08ceca88d217b1c65286341'

UPDATE ezm_block SET last_update=1270555094 WHERE id='24aeec63a08ceca88d217b1c65286341'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='24aeec63a08ceca88d217b1c65286341'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='85e26043fe2a9f6a896c784a84c5b5df'

UPDATE ezm_block SET last_update=1270555094 WHERE id='85e26043fe2a9f6a896c784a84c5b5df'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='85e26043fe2a9f6a896c784a84c5b5df'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='9070a61747d54afc30b056a3ab61ba9b'

UPDATE ezm_block SET last_update=1270555094 WHERE id='9070a61747d54afc30b056a3ab61ba9b'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='9070a61747d54afc30b056a3ab61ba9b'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='c6db1331da3ecd1ea357e066faf4350f'

UPDATE ezm_block SET last_update=1270555094 WHERE id='c6db1331da3ecd1ea357e066faf4350f'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='c6db1331da3ecd1ea357e066faf4350f'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='e567f9d932d7044054ffa7b6a8196907'

UPDATE ezm_block SET last_update=1270555094 WHERE id='e567f9d932d7044054ffa7b6a8196907'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='e567f9d932d7044054ffa7b6a8196907'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='ed6ff3d3d93114af807182cc76f0f9c3'

UPDATE ezm_block SET last_update=1270555094 WHERE id='ed6ff3d3d93114af807182cc76f0f9c3'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='ed6ff3d3d93114af807182cc76f0f9c3'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=87

SELECT * FROM ezm_block WHERE id='3c3258c03f46b977950547f4ca91bd73'

UPDATE ezm_block SET last_update=1270555094 WHERE id='3c3258c03f46b977950547f4ca91bd73'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='3c3258c03f46b977950547f4ca91bd73'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='474bef076a0ed33202cec521fa7a2edf'

UPDATE ezm_block SET last_update=1270555094 WHERE id='474bef076a0ed33202cec521fa7a2edf'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='474bef076a0ed33202cec521fa7a2edf'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='63ea451ebe14df955404b9e4fc3d1ecd'

UPDATE ezm_block SET last_update=1270555094 WHERE id='63ea451ebe14df955404b9e4fc3d1ecd'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='63ea451ebe14df955404b9e4fc3d1ecd'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='8b87f09e9803221363451fce5c152b5f'

UPDATE ezm_block SET last_update=1270555094 WHERE id='8b87f09e9803221363451fce5c152b5f'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='8b87f09e9803221363451fce5c152b5f'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='98f89c804d0b6026700fb846473a4dd4'

UPDATE ezm_block SET last_update=1270555094 WHERE id='98f89c804d0b6026700fb846473a4dd4'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='98f89c804d0b6026700fb846473a4dd4'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='ab7119a2fb1436fc6b0edfad3c6e8f7f'

UPDATE ezm_block SET last_update=1270555094 WHERE id='ab7119a2fb1436fc6b0edfad3c6e8f7f'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='ab7119a2fb1436fc6b0edfad3c6e8f7f'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='b64702dd3076536456e3a6b6e4881657'

UPDATE ezm_block SET last_update=1270555094 WHERE id='b64702dd3076536456e3a6b6e4881657'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='b64702dd3076536456e3a6b6e4881657'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='c1573373dad0d345d980a530d078115c'

UPDATE ezm_block SET last_update=1270555094 WHERE id='c1573373dad0d345d980a530d078115c'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='c1573373dad0d345d980a530d078115c'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='c54206b143670583b1d34033224719d4'

UPDATE ezm_block SET last_update=1270555094 WHERE id='c54206b143670583b1d34033224719d4'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='c54206b143670583b1d34033224719d4'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='f11dd188bb7438dd9a08668b36642e5f'

UPDATE ezm_block SET last_update=1270555094 WHERE id='f11dd188bb7438dd9a08668b36642e5f'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='f11dd188bb7438dd9a08668b36642e5f'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='fa12ff2803db5cce6397c67eeaa6b6c3'

UPDATE ezm_block SET last_update=1270555094 WHERE id='fa12ff2803db5cce6397c67eeaa6b6c3'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='fa12ff2803db5cce6397c67eeaa6b6c3'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=89

SELECT * FROM ezm_block WHERE id='076444b85357e6d23efbc80dea5cbddc'

UPDATE ezm_block SET last_update=1270555094 WHERE id='076444b85357e6d23efbc80dea5cbddc'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='076444b85357e6d23efbc80dea5cbddc'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='0ed41eb5577acf48217f82dfb33845d4'

UPDATE ezm_block SET last_update=1270555094 WHERE id='0ed41eb5577acf48217f82dfb33845d4'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='0ed41eb5577acf48217f82dfb33845d4'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='611fa1e8c2b66d1fb968fac50aa5a949'

UPDATE ezm_block SET last_update=1270555094 WHERE id='611fa1e8c2b66d1fb968fac50aa5a949'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='611fa1e8c2b66d1fb968fac50aa5a949'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='63c16eed4203bdb371a05a5bd1685b6b'

UPDATE ezm_block SET last_update=1270555094 WHERE id='63c16eed4203bdb371a05a5bd1685b6b'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='63c16eed4203bdb371a05a5bd1685b6b'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='7e1be0e572b1cac375512e7fe2e71788'

UPDATE ezm_block SET last_update=1270555094 WHERE id='7e1be0e572b1cac375512e7fe2e71788'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='7e1be0e572b1cac375512e7fe2e71788'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='7fc85a0053b0a780798442e8e86f768d'

UPDATE ezm_block SET last_update=1270555094 WHERE id='7fc85a0053b0a780798442e8e86f768d'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='7fc85a0053b0a780798442e8e86f768d'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='841049e7540b1702283f3c65d15d660d'

UPDATE ezm_block SET last_update=1270555094 WHERE id='841049e7540b1702283f3c65d15d660d'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='841049e7540b1702283f3c65d15d660d'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='8588d9e948d24bac72e1900492b3ed0e'

UPDATE ezm_block SET last_update=1270555094 WHERE id='8588d9e948d24bac72e1900492b3ed0e'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='8588d9e948d24bac72e1900492b3ed0e'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='87a0deb170ce78e97087046fe5d34d34'

UPDATE ezm_block SET last_update=1270555094 WHERE id='87a0deb170ce78e97087046fe5d34d34'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='87a0deb170ce78e97087046fe5d34d34'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='8b3b30226c3fc8301ec1eeb92c536486'

UPDATE ezm_block SET last_update=1270555094 WHERE id='8b3b30226c3fc8301ec1eeb92c536486'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='8b3b30226c3fc8301ec1eeb92c536486'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='8f262c2972349511f34d8ae8d5c1232a'

UPDATE ezm_block SET last_update=1270555094 WHERE id='8f262c2972349511f34d8ae8d5c1232a'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='8f262c2972349511f34d8ae8d5c1232a'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='91445ec0757a78d08201ce69fd03510e'

UPDATE ezm_block SET last_update=1270555094 WHERE id='91445ec0757a78d08201ce69fd03510e'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='91445ec0757a78d08201ce69fd03510e'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='936a7cfc2fa2dd1a46a2f345ba54b13b'

UPDATE ezm_block SET last_update=1270555094 WHERE id='936a7cfc2fa2dd1a46a2f345ba54b13b'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='936a7cfc2fa2dd1a46a2f345ba54b13b'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='96dce3e5a5e2f146189e8a642ed0ecde'

UPDATE ezm_block SET last_update=1270555094 WHERE id='96dce3e5a5e2f146189e8a642ed0ecde'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='96dce3e5a5e2f146189e8a642ed0ecde'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='a23ba104c88348b91a076fde5cb6b181'

UPDATE ezm_block SET last_update=1270555094 WHERE id='a23ba104c88348b91a076fde5cb6b181'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='a23ba104c88348b91a076fde5cb6b181'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='a3c6664edfe175059d2f13d1540b7957'

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 = 48091 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='a3c6664edfe175059d2f13d1540b7957'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='a3c6664edfe175059d2f13d1540b7957'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='bbf8b7a53b4676be878402e16682f4a0'

UPDATE ezm_block SET last_update=1270555094 WHERE id='bbf8b7a53b4676be878402e16682f4a0'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='bbf8b7a53b4676be878402e16682f4a0'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='cac0a6647c4cbc4a8135dd3bd45ac7d5'

UPDATE ezm_block SET last_update=1270555094 WHERE id='cac0a6647c4cbc4a8135dd3bd45ac7d5'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='cac0a6647c4cbc4a8135dd3bd45ac7d5'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='cdc5b131453519620bb4b0d1edcfef57'

UPDATE ezm_block SET last_update=1270555094 WHERE id='cdc5b131453519620bb4b0d1edcfef57'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='cdc5b131453519620bb4b0d1edcfef57'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='ce8c8c6f247f55bab2d1594fdf9ec0df'

UPDATE ezm_block SET last_update=1270555094 WHERE id='ce8c8c6f247f55bab2d1594fdf9ec0df'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='ce8c8c6f247f55bab2d1594fdf9ec0df'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='d01860ae4e8c4c5e3ca64e12a8bbd0b8'

UPDATE ezm_block SET last_update=1270555094 WHERE id='d01860ae4e8c4c5e3ca64e12a8bbd0b8'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='d01860ae4e8c4c5e3ca64e12a8bbd0b8'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='dd2ca19d8ab812c8eef952442650a495'

UPDATE ezm_block SET last_update=1270555094 WHERE id='dd2ca19d8ab812c8eef952442650a495'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='dd2ca19d8ab812c8eef952442650a495'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='df7eb5b2a6f9cfc1e2793463480fe8bb'

UPDATE ezm_block SET last_update=1270555094 WHERE id='df7eb5b2a6f9cfc1e2793463480fe8bb'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='df7eb5b2a6f9cfc1e2793463480fe8bb'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='e34aa7ecc9b9d0bdd643cf57e6314581'

UPDATE ezm_block SET last_update=1270555094 WHERE id='e34aa7ecc9b9d0bdd643cf57e6314581'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='e34aa7ecc9b9d0bdd643cf57e6314581'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='ec4c195ecf7e03bbb6f4a090bb45fc7a'

UPDATE ezm_block SET last_update=1270555094 WHERE id='ec4c195ecf7e03bbb6f4a090bb45fc7a'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='ec4c195ecf7e03bbb6f4a090bb45fc7a'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='edaf4a78145059a4634a48e15326d180'

UPDATE ezm_block SET last_update=1270555094 WHERE id='edaf4a78145059a4634a48e15326d180'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='edaf4a78145059a4634a48e15326d180'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='ee29e28cdfc27a2541d88f2f7fac54f9'

UPDATE ezm_block SET last_update=1270555094 WHERE id='ee29e28cdfc27a2541d88f2f7fac54f9'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='ee29e28cdfc27a2541d88f2f7fac54f9'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='f7b93750f6c303c1f3cbba97963a9e4b'

UPDATE ezm_block SET last_update=1270555094 WHERE id='f7b93750f6c303c1f3cbba97963a9e4b'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='f7b93750f6c303c1f3cbba97963a9e4b'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='f89063a87db9a85459b1859d017701a7'

UPDATE ezm_block SET last_update=1270555094 WHERE id='f89063a87db9a85459b1859d017701a7'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='f89063a87db9a85459b1859d017701a7'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='ff420d1ed371e0f90f9fac61450669cf'

UPDATE ezm_block SET last_update=1270555094 WHERE id='ff420d1ed371e0f90f9fac61450669cf'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='ff420d1ed371e0f90f9fac61450669cf'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=90

SELECT * FROM ezm_block WHERE id='0dca834185a8058a2155d3d029095496'

UPDATE ezm_block SET last_update=1270555094 WHERE id='0dca834185a8058a2155d3d029095496'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='0dca834185a8058a2155d3d029095496'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='13a9762944db5d10ff0a3cf4e15c6c92'

UPDATE ezm_block SET last_update=1270555094 WHERE id='13a9762944db5d10ff0a3cf4e15c6c92'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='13a9762944db5d10ff0a3cf4e15c6c92'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='1831173e430da6db65db546eb082c10b'

UPDATE ezm_block SET last_update=1270555094 WHERE id='1831173e430da6db65db546eb082c10b'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='1831173e430da6db65db546eb082c10b'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='2202db76ef1ce4f620ea072fa59448b0'

UPDATE ezm_block SET last_update=1270555094 WHERE id='2202db76ef1ce4f620ea072fa59448b0'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='2202db76ef1ce4f620ea072fa59448b0'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='3a30acbc6548681b90b72fef18c6e912'

UPDATE ezm_block SET last_update=1270555094 WHERE id='3a30acbc6548681b90b72fef18c6e912'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='3a30acbc6548681b90b72fef18c6e912'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='43346ede4bba67af8ddf157714ef579d'

UPDATE ezm_block SET last_update=1270555094 WHERE id='43346ede4bba67af8ddf157714ef579d'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='43346ede4bba67af8ddf157714ef579d'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='45649cd3e11e62c81f0a68e0d3d24178'

UPDATE ezm_block SET last_update=1270555094 WHERE id='45649cd3e11e62c81f0a68e0d3d24178'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='45649cd3e11e62c81f0a68e0d3d24178'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='519cab911224ed7ee80e17c0c277c5ac'

UPDATE ezm_block SET last_update=1270555094 WHERE id='519cab911224ed7ee80e17c0c277c5ac'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='519cab911224ed7ee80e17c0c277c5ac'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='7a0816528088e772dac9f73484e1e358'

UPDATE ezm_block SET last_update=1270555094 WHERE id='7a0816528088e772dac9f73484e1e358'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='7a0816528088e772dac9f73484e1e358'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='88e73e07d64e79d99041ff42129a5e12'

UPDATE ezm_block SET last_update=1270555094 WHERE id='88e73e07d64e79d99041ff42129a5e12'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='88e73e07d64e79d99041ff42129a5e12'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='8dc08754df63b87e722a482add504ca1'

UPDATE ezm_block SET last_update=1270555094 WHERE id='8dc08754df63b87e722a482add504ca1'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='8dc08754df63b87e722a482add504ca1'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='b0b8a7219dbe2e5bd1d22c40dd79430a'

UPDATE ezm_block SET last_update=1270555094 WHERE id='b0b8a7219dbe2e5bd1d22c40dd79430a'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='b0b8a7219dbe2e5bd1d22c40dd79430a'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='c3cf13ab42f89e5e3720ee2be35d2ef0'

UPDATE ezm_block SET last_update=1270555094 WHERE id='c3cf13ab42f89e5e3720ee2be35d2ef0'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='c3cf13ab42f89e5e3720ee2be35d2ef0'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='c66fae425e2251f5258e4a8deff81f49'

UPDATE ezm_block SET last_update=1270555094 WHERE id='c66fae425e2251f5258e4a8deff81f49'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='c66fae425e2251f5258e4a8deff81f49'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='c8a17e1f1662970c685bd1b6e88a1fe2'

UPDATE ezm_block SET last_update=1270555094 WHERE id='c8a17e1f1662970c685bd1b6e88a1fe2'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='c8a17e1f1662970c685bd1b6e88a1fe2'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=91

SELECT * FROM ezm_block WHERE id='015db871d9048beeeb36295c07ca350f'

UPDATE ezm_block SET last_update=1270555094 WHERE id='015db871d9048beeeb36295c07ca350f'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='015db871d9048beeeb36295c07ca350f'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='01cb95e9532da830132b8f140ec1e422'

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 = 6279 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='01cb95e9532da830132b8f140ec1e422'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='01cb95e9532da830132b8f140ec1e422'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='033b11ede03543da0baccd2d17ec5368'

UPDATE ezm_block SET last_update=1270555094 WHERE id='033b11ede03543da0baccd2d17ec5368'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='033b11ede03543da0baccd2d17ec5368'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='03daa3fd162ecba5269891e6c71d7eac'

UPDATE ezm_block SET last_update=1270555094 WHERE id='03daa3fd162ecba5269891e6c71d7eac'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='03daa3fd162ecba5269891e6c71d7eac'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='0689a77aba7bdb1b73827202c93dce29'

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 = 624 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='0689a77aba7bdb1b73827202c93dce29'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='0689a77aba7bdb1b73827202c93dce29'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='099e149c5356afc4a26ca474bd3b414a'

UPDATE ezm_block SET last_update=1270555094 WHERE id='099e149c5356afc4a26ca474bd3b414a'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='099e149c5356afc4a26ca474bd3b414a'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='0c6f732cb70886bfe1f3d310ea5c06ed'

UPDATE ezm_block SET last_update=1270555094 WHERE id='0c6f732cb70886bfe1f3d310ea5c06ed'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='0c6f732cb70886bfe1f3d310ea5c06ed'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='0d1407e5d434914261031cf6e2f42c63'

UPDATE ezm_block SET last_update=1270555094 WHERE id='0d1407e5d434914261031cf6e2f42c63'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='0d1407e5d434914261031cf6e2f42c63'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT count(*) AS count, max(priority) AS priority
                                                       FROM ezm_pool
                                                       WHERE block_id='0d1407e5d434914261031cf6e2f42c63'
                                                         AND ts_visible>0
                                                         AND ts_hidden=0

UPDATE ezm_pool
                             SET ts_visible=1270555094, priority=925447
                             WHERE block_id='0d1407e5d434914261031cf6e2f42c63'
                               AND object_id=266728

UPDATE ezm_pool
                             SET ts_visible=1270555094, priority=925448
                             WHERE block_id='0d1407e5d434914261031cf6e2f42c63'
                               AND object_id=266699

UPDATE ezm_pool
                             SET ts_visible=1270555094, priority=925449
                             WHERE block_id='0d1407e5d434914261031cf6e2f42c63'
                               AND object_id=266704

UPDATE ezm_pool
                             SET ts_visible=1270555094, priority=925450
                             WHERE block_id='0d1407e5d434914261031cf6e2f42c63'
                               AND object_id=266714

SELECT node_id, object_id, rotation_until
                                           FROM ezm_pool
                                           WHERE block_id='0d1407e5d434914261031cf6e2f42c63'
                                             AND ts_visible>0
                                             AND ts_hidden=0
                                           ORDER BY priority ASC
LIMIT 0, 4

UPDATE ezm_pool
                                         SET ts_visible=0,
                                             ts_publication=-1270555094,
                                             priority=343047991
                                         WHERE block_id='0d1407e5d434914261031cf6e2f42c63'
                                           AND object_id=266706

UPDATE ezm_pool
                                         SET ts_visible=0,
                                             ts_publication=-1270555094,
                                             priority=142393530
                                         WHERE block_id='0d1407e5d434914261031cf6e2f42c63'
                                           AND object_id=266705

UPDATE ezm_pool
                                         SET ts_visible=0,
                                             ts_publication=-1270555094,
                                             priority=2100415344
                                         WHERE block_id='0d1407e5d434914261031cf6e2f42c63'
                                           AND object_id=266728

UPDATE ezm_pool
                                         SET ts_visible=0,
                                             ts_publication=-1270555094,
                                             priority=1974428724
                                         WHERE block_id='0d1407e5d434914261031cf6e2f42c63'
                                           AND object_id=266699

SELECT count(*) AS count
                                               FROM ezm_pool
                                               WHERE block_id='0d1407e5d434914261031cf6e2f42c63'
                                                 AND ts_hidden>0

SELECT * FROM ezm_block WHERE id='1267ec1421a531e99e909773d8a9e8e2'

UPDATE ezm_block SET last_update=1270555094 WHERE id='1267ec1421a531e99e909773d8a9e8e2'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='1267ec1421a531e99e909773d8a9e8e2'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='12eb6db4810824b83295c321a9615f18'

UPDATE ezm_block SET last_update=1270555094 WHERE id='12eb6db4810824b83295c321a9615f18'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='12eb6db4810824b83295c321a9615f18'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='18678f57583593b1332dfbc950bda0d4'

UPDATE ezm_block SET last_update=1270555094 WHERE id='18678f57583593b1332dfbc950bda0d4'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='18678f57583593b1332dfbc950bda0d4'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='18b20a78cc3b7f2fb762f7a8043fa0bd'

UPDATE ezm_block SET last_update=1270555094 WHERE id='18b20a78cc3b7f2fb762f7a8043fa0bd'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='18b20a78cc3b7f2fb762f7a8043fa0bd'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='1f182bd313f3f1e9ca45f2acac1d02e3'

UPDATE ezm_block SET last_update=1270555094 WHERE id='1f182bd313f3f1e9ca45f2acac1d02e3'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='1f182bd313f3f1e9ca45f2acac1d02e3'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='21630c58a5bb06d7399ff03e843e7f2b'

UPDATE ezm_block SET last_update=1270555094 WHERE id='21630c58a5bb06d7399ff03e843e7f2b'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='21630c58a5bb06d7399ff03e843e7f2b'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='249bcd1c6bc6f44b1b35bde71da4c5ef'

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 = 4504 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='249bcd1c6bc6f44b1b35bde71da4c5ef'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='249bcd1c6bc6f44b1b35bde71da4c5ef'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='2ad0b977e7dfa653eb4c8241125876cc'

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 = 6278 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='2ad0b977e7dfa653eb4c8241125876cc'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='2ad0b977e7dfa653eb4c8241125876cc'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='30dcbff36945c39ea87d04b4fa4b64a1'

UPDATE ezm_block SET last_update=1270555094 WHERE id='30dcbff36945c39ea87d04b4fa4b64a1'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='30dcbff36945c39ea87d04b4fa4b64a1'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='35ab1eecb6dabd62d073fa661b7fe52c'

UPDATE ezm_block SET last_update=1270555094 WHERE id='35ab1eecb6dabd62d073fa661b7fe52c'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='35ab1eecb6dabd62d073fa661b7fe52c'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='38b853130248cdf339e31d8c89b91dee'

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 = 5450 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='38b853130248cdf339e31d8c89b91dee'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='38b853130248cdf339e31d8c89b91dee'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='38f11a53159da8268fb11481d45491cd'

UPDATE ezm_block SET last_update=1270555094 WHERE id='38f11a53159da8268fb11481d45491cd'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='38f11a53159da8268fb11481d45491cd'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='3f6632214909d85a2ad6446544d4033b'

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 = 1729 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='3f6632214909d85a2ad6446544d4033b'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='3f6632214909d85a2ad6446544d4033b'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='3fcd98421262c482b9d0062ec76e69ce'

UPDATE ezm_block SET last_update=1270555094 WHERE id='3fcd98421262c482b9d0062ec76e69ce'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='3fcd98421262c482b9d0062ec76e69ce'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='409b392881e8610a74c56f7cddcd112e'

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 = 6275 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='409b392881e8610a74c56f7cddcd112e'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='409b392881e8610a74c56f7cddcd112e'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='4347548b0358e6a4eb0da5f3f43759e6'

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 = 1727 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='4347548b0358e6a4eb0da5f3f43759e6'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='4347548b0358e6a4eb0da5f3f43759e6'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='46f64593ef3727b04fb440228ed121ad'

UPDATE ezm_block SET last_update=1270555094 WHERE id='46f64593ef3727b04fb440228ed121ad'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='46f64593ef3727b04fb440228ed121ad'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='4935b747ca8f4eb2fcea2fa46bcd8e23'

UPDATE ezm_block SET last_update=1270555094 WHERE id='4935b747ca8f4eb2fcea2fa46bcd8e23'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='4935b747ca8f4eb2fcea2fa46bcd8e23'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='507a17c871b9be52f1a7a03d2ca3bc85'

UPDATE ezm_block SET last_update=1270555094 WHERE id='507a17c871b9be52f1a7a03d2ca3bc85'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='507a17c871b9be52f1a7a03d2ca3bc85'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='5372b9d2bdb44c8e32a93088a4da85d6'

UPDATE ezm_block SET last_update=1270555094 WHERE id='5372b9d2bdb44c8e32a93088a4da85d6'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='5372b9d2bdb44c8e32a93088a4da85d6'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='54078d9c0e4198b139a9045b186dccdd'

UPDATE ezm_block SET last_update=1270555094 WHERE id='54078d9c0e4198b139a9045b186dccdd'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='54078d9c0e4198b139a9045b186dccdd'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='540a1337936c2530896328c10c5d2ebb'

UPDATE ezm_block SET last_update=1270555094 WHERE id='540a1337936c2530896328c10c5d2ebb'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='540a1337936c2530896328c10c5d2ebb'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='54114ad24fabf742091ab6e596b59bfa'

UPDATE ezm_block SET last_update=1270555094 WHERE id='54114ad24fabf742091ab6e596b59bfa'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='54114ad24fabf742091ab6e596b59bfa'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='570a6a947be2c39b22993b1a274b76d5'

UPDATE ezm_block SET last_update=1270555094 WHERE id='570a6a947be2c39b22993b1a274b76d5'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='570a6a947be2c39b22993b1a274b76d5'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT count(*) AS count, max(priority) AS priority
                                                       FROM ezm_pool
                                                       WHERE block_id='570a6a947be2c39b22993b1a274b76d5'
                                                         AND ts_visible>0
                                                         AND ts_hidden=0

UPDATE ezm_pool
                             SET ts_visible=1270555094, priority=462783
                             WHERE block_id='570a6a947be2c39b22993b1a274b76d5'
                               AND object_id=267481

UPDATE ezm_pool
                             SET ts_visible=1270555094, priority=462784
                             WHERE block_id='570a6a947be2c39b22993b1a274b76d5'
                               AND object_id=267502

SELECT node_id, object_id, rotation_until
                                           FROM ezm_pool
                                           WHERE block_id='570a6a947be2c39b22993b1a274b76d5'
                                             AND ts_visible>0
                                             AND ts_hidden=0
                                           ORDER BY priority ASC
LIMIT 0, 2

UPDATE ezm_pool
                                         SET ts_visible=0,
                                             ts_publication=-1270555094,
                                             priority=1839534324
                                         WHERE block_id='570a6a947be2c39b22993b1a274b76d5'
                                           AND object_id=267479

UPDATE ezm_pool
                                         SET ts_visible=0,
                                             ts_publication=-1270555094,
                                             priority=34097675
                                         WHERE block_id='570a6a947be2c39b22993b1a274b76d5'
                                           AND object_id=267484

SELECT count(*) AS count
                                               FROM ezm_pool
                                               WHERE block_id='570a6a947be2c39b22993b1a274b76d5'
                                                 AND ts_hidden>0

SELECT * FROM ezm_block WHERE id='5f94750d37f4419edad6e5f6ca9fd77d'

UPDATE ezm_block SET last_update=1270555094 WHERE id='5f94750d37f4419edad6e5f6ca9fd77d'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='5f94750d37f4419edad6e5f6ca9fd77d'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='6487e4a9bb4cbc3061487bc08a025806'

UPDATE ezm_block SET last_update=1270555094 WHERE id='6487e4a9bb4cbc3061487bc08a025806'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='6487e4a9bb4cbc3061487bc08a025806'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='69bde95513bf9f2d4797fb4ef4f77bb9'

UPDATE ezm_block SET last_update=1270555094 WHERE id='69bde95513bf9f2d4797fb4ef4f77bb9'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='69bde95513bf9f2d4797fb4ef4f77bb9'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='6a881cdee7402413418ea921a1b511f5'

UPDATE ezm_block SET last_update=1270555094 WHERE id='6a881cdee7402413418ea921a1b511f5'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='6a881cdee7402413418ea921a1b511f5'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='6ba0f3c91a922a22bb8dfac302e9f793'

UPDATE ezm_block SET last_update=1270555094 WHERE id='6ba0f3c91a922a22bb8dfac302e9f793'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='6ba0f3c91a922a22bb8dfac302e9f793'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='73e21f013e4837aa58b2ec2d172dd0dc'

UPDATE ezm_block SET last_update=1270555094 WHERE id='73e21f013e4837aa58b2ec2d172dd0dc'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='73e21f013e4837aa58b2ec2d172dd0dc'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='7571acc1b77c456e9e696c3e75866f2c'

UPDATE ezm_block SET last_update=1270555094 WHERE id='7571acc1b77c456e9e696c3e75866f2c'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='7571acc1b77c456e9e696c3e75866f2c'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='795c96e11175afe2c5f4f2b02292b366'

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 = 13141 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='795c96e11175afe2c5f4f2b02292b366'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='795c96e11175afe2c5f4f2b02292b366'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='7cc5bd789517344902fcdd5ceb8616f2'

UPDATE ezm_block SET last_update=1270555094 WHERE id='7cc5bd789517344902fcdd5ceb8616f2'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='7cc5bd789517344902fcdd5ceb8616f2'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='8bd79831871e963348d95af37780b8f7'

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 = 6281 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='8bd79831871e963348d95af37780b8f7'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='8bd79831871e963348d95af37780b8f7'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='90586d66b3951fcec5546e41b9e26f86'

UPDATE ezm_block SET last_update=1270555094 WHERE id='90586d66b3951fcec5546e41b9e26f86'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='90586d66b3951fcec5546e41b9e26f86'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='a25baac3245a74e2b2aef171a49142c6'

UPDATE ezm_block SET last_update=1270555094 WHERE id='a25baac3245a74e2b2aef171a49142c6'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='a25baac3245a74e2b2aef171a49142c6'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='a31b8ede8e764397d5015aa4181bcbb4'

UPDATE ezm_block SET last_update=1270555094 WHERE id='a31b8ede8e764397d5015aa4181bcbb4'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='a31b8ede8e764397d5015aa4181bcbb4'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='a5b28cb505c8c922982e4332b3e764a6'

UPDATE ezm_block SET last_update=1270555094 WHERE id='a5b28cb505c8c922982e4332b3e764a6'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='a5b28cb505c8c922982e4332b3e764a6'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='a8fe70662e584fc2adfc3139760cf890'

UPDATE ezm_block SET last_update=1270555094 WHERE id='a8fe70662e584fc2adfc3139760cf890'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='a8fe70662e584fc2adfc3139760cf890'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT count(*) AS count, max(priority) AS priority
                                                       FROM ezm_pool
                                                       WHERE block_id='a8fe70662e584fc2adfc3139760cf890'
                                                         AND ts_visible>0
                                                         AND ts_hidden=0

UPDATE ezm_pool
                             SET ts_visible=1270555094, priority=925623
                             WHERE block_id='a8fe70662e584fc2adfc3139760cf890'
                               AND object_id=266510

UPDATE ezm_pool
                             SET ts_visible=1270555094, priority=925624
                             WHERE block_id='a8fe70662e584fc2adfc3139760cf890'
                               AND object_id=266544

UPDATE ezm_pool
                             SET ts_visible=1270555094, priority=925625
                             WHERE block_id='a8fe70662e584fc2adfc3139760cf890'
                               AND object_id=266548

UPDATE ezm_pool
                             SET ts_visible=1270555094, priority=925626
                             WHERE block_id='a8fe70662e584fc2adfc3139760cf890'
                               AND object_id=266557

SELECT node_id, object_id, rotation_until
                                           FROM ezm_pool
                                           WHERE block_id='a8fe70662e584fc2adfc3139760cf890'
                                             AND ts_visible>0
                                             AND ts_hidden=0
                                           ORDER BY priority ASC
LIMIT 0, 4

UPDATE ezm_pool
                                         SET ts_visible=0,
                                             ts_publication=-1270555094,
                                             priority=61355333
                                         WHERE block_id='a8fe70662e584fc2adfc3139760cf890'
                                           AND object_id=263005

UPDATE ezm_pool
                                         SET ts_visible=0,
                                             ts_publication=-1270555094,
                                             priority=1188272739
                                         WHERE block_id='a8fe70662e584fc2adfc3139760cf890'
                                           AND object_id=266560

UPDATE ezm_pool
                                         SET ts_visible=0,
                                             ts_publication=-1270555094,
                                             priority=1296159689
                                         WHERE block_id='a8fe70662e584fc2adfc3139760cf890'
                                           AND object_id=266510

UPDATE ezm_pool
                                         SET ts_visible=0,
                                             ts_publication=-1270555094,
                                             priority=1647344505
                                         WHERE block_id='a8fe70662e584fc2adfc3139760cf890'
                                           AND object_id=266544

SELECT count(*) AS count
                                               FROM ezm_pool
                                               WHERE block_id='a8fe70662e584fc2adfc3139760cf890'
                                                 AND ts_hidden>0

SELECT * FROM ezm_block WHERE id='af4b5f9aecea2e4e0f68eb1212da3ad1'

UPDATE ezm_block SET last_update=1270555094 WHERE id='af4b5f9aecea2e4e0f68eb1212da3ad1'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='af4b5f9aecea2e4e0f68eb1212da3ad1'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='ba0ca62d3f97470bd29b133e8af03556'

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 = 1739 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='ba0ca62d3f97470bd29b133e8af03556'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='ba0ca62d3f97470bd29b133e8af03556'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='bc26e89001e701458d11475db4baf664'

UPDATE ezm_block SET last_update=1270555094 WHERE id='bc26e89001e701458d11475db4baf664'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='bc26e89001e701458d11475db4baf664'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='befac8939c55b7145f48ee4e7e0cadc0'

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 = 6277 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='befac8939c55b7145f48ee4e7e0cadc0'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='befac8939c55b7145f48ee4e7e0cadc0'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='c00e9b426bda204391e277abe74f1fc6'

UPDATE ezm_block SET last_update=1270555094 WHERE id='c00e9b426bda204391e277abe74f1fc6'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='c00e9b426bda204391e277abe74f1fc6'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='c34a922af8e464b836d74c28dc4aeda4'

UPDATE ezm_block SET last_update=1270555094 WHERE id='c34a922af8e464b836d74c28dc4aeda4'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='c34a922af8e464b836d74c28dc4aeda4'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='cd4c0c98ba4b98f5a3a175fc1fbd208c'

UPDATE ezm_block SET last_update=1270555094 WHERE id='cd4c0c98ba4b98f5a3a175fc1fbd208c'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='cd4c0c98ba4b98f5a3a175fc1fbd208c'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='d188abd548d7a5d1cf606130ee6cfc2e'

UPDATE ezm_block SET last_update=1270555094 WHERE id='d188abd548d7a5d1cf606130ee6cfc2e'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='d188abd548d7a5d1cf606130ee6cfc2e'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='d3b44db6fd074228c3b1edf14e490560'

UPDATE ezm_block SET last_update=1270555094 WHERE id='d3b44db6fd074228c3b1edf14e490560'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='d3b44db6fd074228c3b1edf14e490560'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='dc3bacb2517013d716d645c2836a542f'

UPDATE ezm_block SET last_update=1270555094 WHERE id='dc3bacb2517013d716d645c2836a542f'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='dc3bacb2517013d716d645c2836a542f'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='e413061875a07896873b831e7f5cb3f1'

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 = 1728 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='e413061875a07896873b831e7f5cb3f1'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='e413061875a07896873b831e7f5cb3f1'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='e8a3313eb2b441efbf4854b22c1bd765'

UPDATE ezm_block SET last_update=1270555094 WHERE id='e8a3313eb2b441efbf4854b22c1bd765'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='e8a3313eb2b441efbf4854b22c1bd765'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='efc3207ca4ed719a58aa54be71a70039'

UPDATE ezm_block SET last_update=1270555094 WHERE id='efc3207ca4ed719a58aa54be71a70039'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='efc3207ca4ed719a58aa54be71a70039'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='f17dc4efdfd6f5653049a257b86066d9'

UPDATE ezm_block SET last_update=1270555094 WHERE id='f17dc4efdfd6f5653049a257b86066d9'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='f17dc4efdfd6f5653049a257b86066d9'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='f80f3b2431a478b940ef89b16cfa99e4'

UPDATE ezm_block SET last_update=1270555094 WHERE id='f80f3b2431a478b940ef89b16cfa99e4'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='f80f3b2431a478b940ef89b16cfa99e4'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='fa97125d86aeaf4ffeb5df4aec56c773'

UPDATE ezm_block SET last_update=1270555094 WHERE id='fa97125d86aeaf4ffeb5df4aec56c773'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='fa97125d86aeaf4ffeb5df4aec56c773'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='fd0f31b12b04766a292f1996db953aec'

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 = 48091 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='fd0f31b12b04766a292f1996db953aec'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='fd0f31b12b04766a292f1996db953aec'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='fe4b6aad7541b4c996d3600b98c3bac4'

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 = 39045 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='fe4b6aad7541b4c996d3600b98c3bac4'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='fe4b6aad7541b4c996d3600b98c3bac4'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT ezcontentobject.* , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation
                      FROM
                         ezcontentobject,
                         ezcontentobject_tree
                         , ezcontentobject_name
                      WHERE
                         ezcontentobject_tree.node_id=91 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=90 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/cache/classidentifiers_4fcb130eb3b47f0d3916d1cd92a5b4be.php')

RESULT:
array (
  'name' => 'var/cache/classidentifiers_4fcb130eb3b47f0d3916d1cd92a5b4be.php',
  'name_trunk' => 'var/cache/classidentifiers_4fcb130eb3b47f0d3916d1cd92a5b4be.php',
  'name_hash' => '41eb5446e96d9c4063e6a29c6cd1567d',
  'datatype' => 'php',
  'scope' => 'classidentifiers',
  'size' => '4235',
  'mtime' => '1270132413',
  'expired' => '0',
  'status' => '0',
)

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

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 & 15 ) <> 0
                         AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='90' AND
                                                                      ezcontentobject_link.from_contentobject_version='7260'

                         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='90'
                                      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 & 15 ) <> 0
                         AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='90' AND
                                                                      ezcontentobject_link.from_contentobject_version='7252'

                         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 & 15 ) <> 0
                         AND ezcontentobject.id=ezcontentobject_link.from_contentobject_id AND
                                                                      ezcontentobject_link.to_contentobject_id=90 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='90'
                                      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 & 15 ) <> 0
                         AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='90' AND
                                                                      ezcontentobject_link.from_contentobject_version='7252'

                         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=4527 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

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=4479 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

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=64525 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

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=4527 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

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=4479 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

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=64525 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

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=87 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

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=4527 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

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=4479 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

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=64525 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 = '90' AND
                    ezcontentobject_version.version = '7260' AND
                    ezcontentobject_attribute.contentobject_id = '90' AND
                    ezcontentobject_attribute.version = '7260' AND
                    ezcontentobject_attribute.language_code = 'ger-DE'

                  ORDER BY
                    ezcontentclass_attribute.placement ASC,
                    ezcontentobject_attribute.language_code ASC

SELECT ezkeyword.keyword FROM ezkeyword_attribute_link, ezkeyword
                                    WHERE ezkeyword_attribute_link.keyword_id=ezkeyword.id AND
                                    ezkeyword_attribute_link.objectattribute_id='408'

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/cache/expiry.php', 'var/cache/expiry.php', '27c1b0b01c82304c9aaadf79a9853510', 'expirycache', 766, 1270555099, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/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/cache/content/admin_xxx/91-'

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

COMMIT

BEGIN

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

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

COMMIT

BEGIN

UPDATE ezdfsfile SET mtime=-ABS(mtime), expired=1
WHERE name_trunk = 'var/cache/content/admin_xxx/5/2/5295-'

UPDATE ezdfsfile SET mtime=-ABS(mtime), expired=1
WHERE name_trunk = 'var/cache/content/xxx/5/2/5295-'

COMMIT

BEGIN

UPDATE ezdfsfile SET mtime=-ABS(mtime), expired=1
WHERE name_trunk = 'var/cache/content/admin_xxx/5/0/5089-'

UPDATE ezdfsfile SET mtime=-ABS(mtime), expired=1
WHERE name_trunk = 'var/cache/content/xxx/5/0/5089-'

COMMIT

BEGIN

UPDATE ezdfsfile SET mtime=-ABS(mtime), expired=1
WHERE name_trunk = 'var/cache/content/admin_xxx/6/2/8/62809-'

UPDATE ezdfsfile SET mtime=-ABS(mtime), expired=1
WHERE name_trunk = 'var/cache/content/xxx/6/2/8/62809-'

COMMIT

BEGIN

INSERT INTO ezdfsfile (datatype, name, name_trunk, name_hash, scope, size, mtime, expired) VALUES ('misc', 'var/cache/expiry.php', 'var/cache/expiry.php', '27c1b0b01c82304c9aaadf79a9853510', 'expirycache', 766, 1270555099, 0)
ON DUPLICATE KEY UPDATE datatype=VALUES(datatype), name_trunk='var/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=90 AND
             ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
             ezcontentclass.version=0 AND
             ezcontentclass.id = ezcontentobject.contentclass_id
          ORDER BY path_string

SELECT *
                                FROM ezm_block
                                WHERE node_id=92

SELECT * FROM ezm_block WHERE id='0e09b4aefaa12e2873eaf87903ae9c0a'

UPDATE ezm_block SET last_update=1270555094 WHERE id='0e09b4aefaa12e2873eaf87903ae9c0a'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='0e09b4aefaa12e2873eaf87903ae9c0a'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='a5368fd3ada7ff0e005ad771b4cd10cc'

UPDATE ezm_block SET last_update=1270555094 WHERE id='a5368fd3ada7ff0e005ad771b4cd10cc'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='a5368fd3ada7ff0e005ad771b4cd10cc'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='a9e982e880bd444a99e3f785fb7cffbc'

UPDATE ezm_block SET last_update=1270555094 WHERE id='a9e982e880bd444a99e3f785fb7cffbc'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='a9e982e880bd444a99e3f785fb7cffbc'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='afea2164b306218b30edb63b1c61ee22'

UPDATE ezm_block SET last_update=1270555094 WHERE id='afea2164b306218b30edb63b1c61ee22'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='afea2164b306218b30edb63b1c61ee22'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='b14bce6df3252d8060829932f04bf4d8'

UPDATE ezm_block SET last_update=1270555094 WHERE id='b14bce6df3252d8060829932f04bf4d8'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='b14bce6df3252d8060829932f04bf4d8'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='cb5fa920a129bfd02e443b1e63f1f47c'

UPDATE ezm_block SET last_update=1270555094 WHERE id='cb5fa920a129bfd02e443b1e63f1f47c'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='cb5fa920a129bfd02e443b1e63f1f47c'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='d215e5883fa5065fa1d120f46af6ec47'

UPDATE ezm_block SET last_update=1270555094 WHERE id='d215e5883fa5065fa1d120f46af6ec47'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='d215e5883fa5065fa1d120f46af6ec47'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='efe7fdb2023a4b5553ca1653903ffd63'

UPDATE ezm_block SET last_update=1270555094 WHERE id='efe7fdb2023a4b5553ca1653903ffd63'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='efe7fdb2023a4b5553ca1653903ffd63'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=93

SELECT * FROM ezm_block WHERE id='0eb80313afe391fd752c6844ac5af3d2'

UPDATE ezm_block SET last_update=1270555094 WHERE id='0eb80313afe391fd752c6844ac5af3d2'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='0eb80313afe391fd752c6844ac5af3d2'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='2be7939297c25ef7894e654c0605b3a2'

UPDATE ezm_block SET last_update=1270555094 WHERE id='2be7939297c25ef7894e654c0605b3a2'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='2be7939297c25ef7894e654c0605b3a2'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='349147275114fa7bff1745a76472eb59'

UPDATE ezm_block SET last_update=1270555094 WHERE id='349147275114fa7bff1745a76472eb59'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='349147275114fa7bff1745a76472eb59'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='4000a4eec4c32b429c266af93df9e931'

UPDATE ezm_block SET last_update=1270555094 WHERE id='4000a4eec4c32b429c266af93df9e931'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='4000a4eec4c32b429c266af93df9e931'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='4648404535e468519d10305686b426b4'

UPDATE ezm_block SET last_update=1270555094 WHERE id='4648404535e468519d10305686b426b4'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='4648404535e468519d10305686b426b4'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='4f98cab442add917ec02b33f08ba0e38'

UPDATE ezm_block SET last_update=1270555094 WHERE id='4f98cab442add917ec02b33f08ba0e38'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='4f98cab442add917ec02b33f08ba0e38'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='8e2b88ca49039183ae1fa058d44b3602'

UPDATE ezm_block SET last_update=1270555094 WHERE id='8e2b88ca49039183ae1fa058d44b3602'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='8e2b88ca49039183ae1fa058d44b3602'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='9f5eaa9adcd8873ff91adb6144ada158'

UPDATE ezm_block SET last_update=1270555094 WHERE id='9f5eaa9adcd8873ff91adb6144ada158'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='9f5eaa9adcd8873ff91adb6144ada158'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='9f693fa86f4a9203ebac1161d763f980'

UPDATE ezm_block SET last_update=1270555094 WHERE id='9f693fa86f4a9203ebac1161d763f980'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='9f693fa86f4a9203ebac1161d763f980'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='aa05ab2b72939d8dca2dcf37313cb212'

UPDATE ezm_block SET last_update=1270555094 WHERE id='aa05ab2b72939d8dca2dcf37313cb212'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='aa05ab2b72939d8dca2dcf37313cb212'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='ac9e0ce990332e42c15961e1cde433b0'

UPDATE ezm_block SET last_update=1270555094 WHERE id='ac9e0ce990332e42c15961e1cde433b0'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='ac9e0ce990332e42c15961e1cde433b0'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='d6e19cf4942799de9184f3831a963280'

UPDATE ezm_block SET last_update=1270555094 WHERE id='d6e19cf4942799de9184f3831a963280'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='d6e19cf4942799de9184f3831a963280'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='df4109d73f4f7000398c0213ddfdf028'

UPDATE ezm_block SET last_update=1270555094 WHERE id='df4109d73f4f7000398c0213ddfdf028'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='df4109d73f4f7000398c0213ddfdf028'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='e4517d7dce88c235458db92c8ce21e61'

UPDATE ezm_block SET last_update=1270555094 WHERE id='e4517d7dce88c235458db92c8ce21e61'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='e4517d7dce88c235458db92c8ce21e61'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='f0bea4f6ec61642eec421a490781e650'

UPDATE ezm_block SET last_update=1270555094 WHERE id='f0bea4f6ec61642eec421a490781e650'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='f0bea4f6ec61642eec421a490781e650'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=94

SELECT * FROM ezm_block WHERE id='1737731bfb652035baa4d91e24ad2d4f'

UPDATE ezm_block SET last_update=1270555094 WHERE id='1737731bfb652035baa4d91e24ad2d4f'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='1737731bfb652035baa4d91e24ad2d4f'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='5c23c51f28d31c7b5d5348206556c3e5'

UPDATE ezm_block SET last_update=1270555094 WHERE id='5c23c51f28d31c7b5d5348206556c3e5'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='5c23c51f28d31c7b5d5348206556c3e5'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='5de0aa9ad8a79d18dd5d27149385d313'

UPDATE ezm_block SET last_update=1270555094 WHERE id='5de0aa9ad8a79d18dd5d27149385d313'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='5de0aa9ad8a79d18dd5d27149385d313'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='5efa7e7d8d78489d1722373e8f37b2c4'

UPDATE ezm_block SET last_update=1270555094 WHERE id='5efa7e7d8d78489d1722373e8f37b2c4'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='5efa7e7d8d78489d1722373e8f37b2c4'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='62a8edcad301d4ca9869724b89065ad7'

UPDATE ezm_block SET last_update=1270555094 WHERE id='62a8edcad301d4ca9869724b89065ad7'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='62a8edcad301d4ca9869724b89065ad7'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='6d52b28c0f6cbf9102c2a742eea529ed'

UPDATE ezm_block SET last_update=1270555094 WHERE id='6d52b28c0f6cbf9102c2a742eea529ed'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='6d52b28c0f6cbf9102c2a742eea529ed'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='749e6b93daa540403ed2dd0e929539e6'

UPDATE ezm_block SET last_update=1270555094 WHERE id='749e6b93daa540403ed2dd0e929539e6'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='749e6b93daa540403ed2dd0e929539e6'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='97ea175c7db6327044075b90d878b7fd'

UPDATE ezm_block SET last_update=1270555094 WHERE id='97ea175c7db6327044075b90d878b7fd'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='97ea175c7db6327044075b90d878b7fd'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='a0ece849372cc5fa1f5b7a88465c2916'

UPDATE ezm_block SET last_update=1270555094 WHERE id='a0ece849372cc5fa1f5b7a88465c2916'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='a0ece849372cc5fa1f5b7a88465c2916'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='aea40d9e9762acd3d26410a72b72c099'

UPDATE ezm_block SET last_update=1270555094 WHERE id='aea40d9e9762acd3d26410a72b72c099'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='aea40d9e9762acd3d26410a72b72c099'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='b05a35950040478325c77d9d03eb4dfd'

UPDATE ezm_block SET last_update=1270555094 WHERE id='b05a35950040478325c77d9d03eb4dfd'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='b05a35950040478325c77d9d03eb4dfd'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='c3224eca8aa635e359e32d336a2ca9ab'

UPDATE ezm_block SET last_update=1270555094 WHERE id='c3224eca8aa635e359e32d336a2ca9ab'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='c3224eca8aa635e359e32d336a2ca9ab'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='d0b1759fe2520b05235ecec6b747cacf'

UPDATE ezm_block SET last_update=1270555094 WHERE id='d0b1759fe2520b05235ecec6b747cacf'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='d0b1759fe2520b05235ecec6b747cacf'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='ded5915bfe6882a955fe7009103cd23f'

UPDATE ezm_block SET last_update=1270555094 WHERE id='ded5915bfe6882a955fe7009103cd23f'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='ded5915bfe6882a955fe7009103cd23f'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='f9bef4481be0486e46ddc84a6acddf28'

UPDATE ezm_block SET last_update=1270555094 WHERE id='f9bef4481be0486e46ddc84a6acddf28'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='f9bef4481be0486e46ddc84a6acddf28'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=95

SELECT * FROM ezm_block WHERE id='05ca7389ba0830f310b2938c8072a664'

UPDATE ezm_block SET last_update=1270555094 WHERE id='05ca7389ba0830f310b2938c8072a664'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='05ca7389ba0830f310b2938c8072a664'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='1bf31000c74f51fe405e5e85d0469dc2'

UPDATE ezm_block SET last_update=1270555094 WHERE id='1bf31000c74f51fe405e5e85d0469dc2'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='1bf31000c74f51fe405e5e85d0469dc2'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='2adbc4fd494f00d7b9deefb23dd6921e'

UPDATE ezm_block SET last_update=1270555094 WHERE id='2adbc4fd494f00d7b9deefb23dd6921e'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='2adbc4fd494f00d7b9deefb23dd6921e'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='3396127ec07c756760f00b10c409b956'

UPDATE ezm_block SET last_update=1270555094 WHERE id='3396127ec07c756760f00b10c409b956'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='3396127ec07c756760f00b10c409b956'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='420abf81100067fca80a9cf1948b595e'

UPDATE ezm_block SET last_update=1270555094 WHERE id='420abf81100067fca80a9cf1948b595e'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='420abf81100067fca80a9cf1948b595e'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='42ea0699c6d3e08b29b5d1d391bf86e3'

UPDATE ezm_block SET last_update=1270555094 WHERE id='42ea0699c6d3e08b29b5d1d391bf86e3'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='42ea0699c6d3e08b29b5d1d391bf86e3'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='549ae5c6e4fb5bf92c33d69308584e8b'

UPDATE ezm_block SET last_update=1270555094 WHERE id='549ae5c6e4fb5bf92c33d69308584e8b'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='549ae5c6e4fb5bf92c33d69308584e8b'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='69219347709749ba04a1f8e0d3e6c1fb'

UPDATE ezm_block SET last_update=1270555094 WHERE id='69219347709749ba04a1f8e0d3e6c1fb'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='69219347709749ba04a1f8e0d3e6c1fb'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='7a4ab9844be51aeb8bee9c1bcab6a36f'

UPDATE ezm_block SET last_update=1270555094 WHERE id='7a4ab9844be51aeb8bee9c1bcab6a36f'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='7a4ab9844be51aeb8bee9c1bcab6a36f'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='940786578d9c847d5e327e4d943b81ef'

UPDATE ezm_block SET last_update=1270555094 WHERE id='940786578d9c847d5e327e4d943b81ef'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='940786578d9c847d5e327e4d943b81ef'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='98e35b9d5e2492d5184c4d8cc5117c99'

UPDATE ezm_block SET last_update=1270555094 WHERE id='98e35b9d5e2492d5184c4d8cc5117c99'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='98e35b9d5e2492d5184c4d8cc5117c99'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='a9aea94de533a7f991a6426e2bea206d'

UPDATE ezm_block SET last_update=1270555094 WHERE id='a9aea94de533a7f991a6426e2bea206d'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='a9aea94de533a7f991a6426e2bea206d'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='b0d9353f60bf39a55847c74f51c64899'

UPDATE ezm_block SET last_update=1270555094 WHERE id='b0d9353f60bf39a55847c74f51c64899'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='b0d9353f60bf39a55847c74f51c64899'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='b44b74a6bd3c1cfa897a27e906b1feed'

UPDATE ezm_block SET last_update=1270555094 WHERE id='b44b74a6bd3c1cfa897a27e906b1feed'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='b44b74a6bd3c1cfa897a27e906b1feed'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='cd86267afe185156506bd2a0495ba599'

UPDATE ezm_block SET last_update=1270555094 WHERE id='cd86267afe185156506bd2a0495ba599'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='cd86267afe185156506bd2a0495ba599'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='d2bef4acaa205b4f0ee13e9cd02dee3b'

UPDATE ezm_block SET last_update=1270555094 WHERE id='d2bef4acaa205b4f0ee13e9cd02dee3b'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='d2bef4acaa205b4f0ee13e9cd02dee3b'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='e01e1d8dc3ae707ea91aef48a6c6145f'

UPDATE ezm_block SET last_update=1270555094 WHERE id='e01e1d8dc3ae707ea91aef48a6c6145f'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='e01e1d8dc3ae707ea91aef48a6c6145f'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='eeff5c5558c1d11dd2973247dca2e701'

UPDATE ezm_block SET last_update=1270555094 WHERE id='eeff5c5558c1d11dd2973247dca2e701'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='eeff5c5558c1d11dd2973247dca2e701'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='f0422036ad705aaff67439462723091c'

UPDATE ezm_block SET last_update=1270555094 WHERE id='f0422036ad705aaff67439462723091c'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='f0422036ad705aaff67439462723091c'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='fb247b97dfa6611191a6c0e96b12191c'

UPDATE ezm_block SET last_update=1270555094 WHERE id='fb247b97dfa6611191a6c0e96b12191c'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='fb247b97dfa6611191a6c0e96b12191c'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=96

SELECT * FROM ezm_block WHERE id='0823b494eced59050c0bda1a4464bae9'

UPDATE ezm_block SET last_update=1270555094 WHERE id='0823b494eced59050c0bda1a4464bae9'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='0823b494eced59050c0bda1a4464bae9'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='0de8ecc13c218adf456f7a243a93b7ec'

UPDATE ezm_block SET last_update=1270555094 WHERE id='0de8ecc13c218adf456f7a243a93b7ec'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='0de8ecc13c218adf456f7a243a93b7ec'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='298bbc8a0581081f75c8074ef1c69281'

UPDATE ezm_block SET last_update=1270555094 WHERE id='298bbc8a0581081f75c8074ef1c69281'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='298bbc8a0581081f75c8074ef1c69281'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='2d2f2337a7373e2e3e0dfdbd23b8fe20'

UPDATE ezm_block SET last_update=1270555094 WHERE id='2d2f2337a7373e2e3e0dfdbd23b8fe20'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='2d2f2337a7373e2e3e0dfdbd23b8fe20'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='377abcc7bb8faf1626fe0b76409887da'

UPDATE ezm_block SET last_update=1270555094 WHERE id='377abcc7bb8faf1626fe0b76409887da'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='377abcc7bb8faf1626fe0b76409887da'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='3a18b12042ff1b06cac9a2892b2866e0'

UPDATE ezm_block SET last_update=1270555094 WHERE id='3a18b12042ff1b06cac9a2892b2866e0'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='3a18b12042ff1b06cac9a2892b2866e0'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='3ea379390fbd61724e7f5b88ba44b0e7'

UPDATE ezm_block SET last_update=1270555094 WHERE id='3ea379390fbd61724e7f5b88ba44b0e7'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='3ea379390fbd61724e7f5b88ba44b0e7'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='79a3cf67b1505050c3bb7c5a7addb728'

UPDATE ezm_block SET last_update=1270555094 WHERE id='79a3cf67b1505050c3bb7c5a7addb728'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='79a3cf67b1505050c3bb7c5a7addb728'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='936c1c01f7f19710588a38fc7d3f7cee'

UPDATE ezm_block SET last_update=1270555094 WHERE id='936c1c01f7f19710588a38fc7d3f7cee'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='936c1c01f7f19710588a38fc7d3f7cee'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='aa1278c7baa8c6db5889b0b796bd6aa9'

UPDATE ezm_block SET last_update=1270555094 WHERE id='aa1278c7baa8c6db5889b0b796bd6aa9'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='aa1278c7baa8c6db5889b0b796bd6aa9'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='b4bc74211a29729d5fd4f08ca52f4c60'

UPDATE ezm_block SET last_update=1270555094 WHERE id='b4bc74211a29729d5fd4f08ca52f4c60'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='b4bc74211a29729d5fd4f08ca52f4c60'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='c8d63e8f00190d33ed547986ec05936c'

UPDATE ezm_block SET last_update=1270555094 WHERE id='c8d63e8f00190d33ed547986ec05936c'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='c8d63e8f00190d33ed547986ec05936c'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='f66893e90dc3c4bc0a029c350193b7c2'

UPDATE ezm_block SET last_update=1270555094 WHERE id='f66893e90dc3c4bc0a029c350193b7c2'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='f66893e90dc3c4bc0a029c350193b7c2'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=100

SELECT * FROM ezm_block WHERE id='058639f66e6c59201af6aafbe0a6aeeb'

UPDATE ezm_block SET last_update=1270555094 WHERE id='058639f66e6c59201af6aafbe0a6aeeb'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='058639f66e6c59201af6aafbe0a6aeeb'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='08ee67bb392f0e3fa0994e8b9c8d4cb9'

UPDATE ezm_block SET last_update=1270555094 WHERE id='08ee67bb392f0e3fa0994e8b9c8d4cb9'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='08ee67bb392f0e3fa0994e8b9c8d4cb9'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='2675a7007e1da967a1ba6afbbb74d51e'

UPDATE ezm_block SET last_update=1270555094 WHERE id='2675a7007e1da967a1ba6afbbb74d51e'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='2675a7007e1da967a1ba6afbbb74d51e'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='2ac8920deb9b4499b7e476750e3bf812'

UPDATE ezm_block SET last_update=1270555094 WHERE id='2ac8920deb9b4499b7e476750e3bf812'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='2ac8920deb9b4499b7e476750e3bf812'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='2c6a3ee8ea46bf4e58b69bfd35752f23'

UPDATE ezm_block SET last_update=1270555094 WHERE id='2c6a3ee8ea46bf4e58b69bfd35752f23'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='2c6a3ee8ea46bf4e58b69bfd35752f23'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='6c770f3312efdb00354244e49362be4b'

UPDATE ezm_block SET last_update=1270555094 WHERE id='6c770f3312efdb00354244e49362be4b'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='6c770f3312efdb00354244e49362be4b'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='84afaa2c476ec928a4e489ccb0a7e116'

UPDATE ezm_block SET last_update=1270555094 WHERE id='84afaa2c476ec928a4e489ccb0a7e116'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='84afaa2c476ec928a4e489ccb0a7e116'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='84fe0c046a50501538ce612b09bac598'

UPDATE ezm_block SET last_update=1270555094 WHERE id='84fe0c046a50501538ce612b09bac598'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='84fe0c046a50501538ce612b09bac598'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='b8932877ee824605f56c96fc445b5b47'

UPDATE ezm_block SET last_update=1270555094 WHERE id='b8932877ee824605f56c96fc445b5b47'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='b8932877ee824605f56c96fc445b5b47'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='c6cdfcb4148a2af7b2ef8b0feb5e354d'

UPDATE ezm_block SET last_update=1270555094 WHERE id='c6cdfcb4148a2af7b2ef8b0feb5e354d'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='c6cdfcb4148a2af7b2ef8b0feb5e354d'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=159

SELECT * FROM ezm_block WHERE id='1e0f9e403fdca43b4e7a2a89913d99e1'

UPDATE ezm_block SET last_update=1270555094 WHERE id='1e0f9e403fdca43b4e7a2a89913d99e1'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='1e0f9e403fdca43b4e7a2a89913d99e1'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='41a2bdb70727b8743e1585733243c99a'

UPDATE ezm_block SET last_update=1270555094 WHERE id='41a2bdb70727b8743e1585733243c99a'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='41a2bdb70727b8743e1585733243c99a'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='eb5de3c2c968f5106aec83ad85705b68'

UPDATE ezm_block SET last_update=1270555094 WHERE id='eb5de3c2c968f5106aec83ad85705b68'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='eb5de3c2c968f5106aec83ad85705b68'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=179

SELECT * FROM ezm_block WHERE id='73191ba0075be7b774a4591831a1e573'

UPDATE ezm_block SET last_update=1270555094 WHERE id='73191ba0075be7b774a4591831a1e573'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='73191ba0075be7b774a4591831a1e573'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='f1c84085df0010f623ab97e521aa598b'

UPDATE ezm_block SET last_update=1270555094 WHERE id='f1c84085df0010f623ab97e521aa598b'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='f1c84085df0010f623ab97e521aa598b'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=567

SELECT * FROM ezm_block WHERE id='11bbbb4451a73778be229982c13e7548'

UPDATE ezm_block SET last_update=1270555094 WHERE id='11bbbb4451a73778be229982c13e7548'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='11bbbb4451a73778be229982c13e7548'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='701c9f294c01f13a640ab762edaf7bf5'

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 = 6277 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 )
 )

UPDATE ezm_block SET last_update=1270555094 WHERE id='701c9f294c01f13a640ab762edaf7bf5'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='701c9f294c01f13a640ab762edaf7bf5'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='8e96f48049b80928782816b99c508925'

UPDATE ezm_block SET last_update=1270555094 WHERE id='8e96f48049b80928782816b99c508925'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='8e96f48049b80928782816b99c508925'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='9645e62d2cb02019dc04674c5b7383eb'

UPDATE ezm_block SET last_update=1270555094 WHERE id='9645e62d2cb02019dc04674c5b7383eb'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='9645e62d2cb02019dc04674c5b7383eb'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='c7168a6085dfd9d8800f25a064646f71'

UPDATE ezm_block SET last_update=1270555094 WHERE id='c7168a6085dfd9d8800f25a064646f71'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='c7168a6085dfd9d8800f25a064646f71'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='e32afdc14970e99c6ba066c298a82a42'

UPDATE ezm_block SET last_update=1270555094 WHERE id='e32afdc14970e99c6ba066c298a82a42'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='e32afdc14970e99c6ba066c298a82a42'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=568

SELECT * FROM ezm_block WHERE id='ff342d6be8c8b50ff9461eb79711d9a9'

UPDATE ezm_block SET last_update=1270555094 WHERE id='ff342d6be8c8b50ff9461eb79711d9a9'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='ff342d6be8c8b50ff9461eb79711d9a9'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=570

SELECT * FROM ezm_block WHERE id='68f627303a51a350faabfd90d72e31df'

UPDATE ezm_block SET last_update=1270555094 WHERE id='68f627303a51a350faabfd90d72e31df'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='68f627303a51a350faabfd90d72e31df'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='6f2d5fc531f317b4ae5eda98ea0df5fd'

UPDATE ezm_block SET last_update=1270555094 WHERE id='6f2d5fc531f317b4ae5eda98ea0df5fd'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='6f2d5fc531f317b4ae5eda98ea0df5fd'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='951dff390250a6b437ea465fee313aa5'

UPDATE ezm_block SET last_update=1270555094 WHERE id='951dff390250a6b437ea465fee313aa5'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='951dff390250a6b437ea465fee313aa5'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='ba86b323626f4f964a82bd03ba188fad'

UPDATE ezm_block SET last_update=1270555094 WHERE id='ba86b323626f4f964a82bd03ba188fad'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='ba86b323626f4f964a82bd03ba188fad'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='e2a10ffd924830327de58d9635b0c292'

UPDATE ezm_block SET last_update=1270555094 WHERE id='e2a10ffd924830327de58d9635b0c292'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='e2a10ffd924830327de58d9635b0c292'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT * FROM ezm_block WHERE id='e815cbdcf92ea87c88594025cecfa6e2'

UPDATE ezm_block SET last_update=1270555094 WHERE id='e815cbdcf92ea87c88594025cecfa6e2'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='e815cbdcf92ea87c88594025cecfa6e2'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=583

SELECT * FROM ezm_block WHERE id='909a497961775a931830ff25378751b5'

UPDATE ezm_block SET last_update=1270555094 WHERE id='909a497961775a931830ff25378751b5'

SELECT object_id
                                             FROM ezm_pool
                                             WHERE block_id='909a497961775a931830ff25378751b5'
                                               AND ts_visible=0
                                               AND ts_hidden=0
                                               AND ts_publication<=1270555094
                                             ORDER BY ts_publication ASC, priority ASC

SELECT *
                                FROM ezm_block
                                WHERE node_id=584