|
|
Script start |
Extension 'youtube' does not exist, looked for directory 'extension/youtube' |
SET NAMES 'utf8' |
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.action AS e3_action, e3.alias_redirects AS e3_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1, ezurlalias_ml e2, ezurlalias_ml e3 WHERE e0.parent = 0 AND (e0.lang_mask & 3 > 0) AND e0.text_md5 = MD5( 'content' ) AND e1.parent = e0.link AND (e1.lang_mask & 3 > 0) AND e1.text_md5 = MD5( 'view' ) AND e2.parent = e1.link AND (e2.lang_mask & 3 > 0) AND e2.text_md5 = MD5( 'full' ) AND e3.parent = e2.link AND (e3.lang_mask & 3 > 0) AND e3.text_md5 = MD5( '52136' )
LIMIT 0, 1 |
SELECT id, source_url, destination_url, type
FROM ezurlwildcard
LIMIT 0, 100 |
SELECT id, source_url, destination_url, type
FROM ezurlwildcard
LIMIT 100, 100 |
SELECT * FROM ezcobj_state_group, ezcobj_state_group_language WHERE identifier NOT LIKE 'ez%' AND ezcobj_state_group_language.contentobject_state_group_id=ezcobj_state_group.id AND
ezcobj_state_group.language_mask & 3 > 0
AND
( ezcobj_state_group_language.language_id & ezcobj_state_group.language_mask > 0 AND
( ( ezcobj_state_group.language_mask - ( ezcobj_state_group.language_mask & ezcobj_state_group_language.language_id ) ) & 1 )
+ ( ( ( ezcobj_state_group.language_mask - ( ezcobj_state_group.language_mask & ezcobj_state_group_language.language_id ) ) & 2 ) )
<
( ezcobj_state_group_language.language_id & 1 )
+ ( ( ezcobj_state_group_language.language_id & 2 ) )
) |
Module start 'content' |
SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser WHERE contentobject_id='10' |
SELECT c.contentobject_id as id,c.path_string
FROM ezcontentobject_tree b,
ezcontentobject_tree c
WHERE b.contentobject_id='10' AND
b.parent_node_id = c.node_id
ORDER BY c.contentobject_id |
SELECT DISTINCT ezrole.id,
ezrole.name,
ezuser_role.limit_identifier,
ezuser_role.limit_value,
ezuser_role.id as user_role_id
FROM ezrole,
ezuser_role
WHERE ezuser_role.contentobject_id IN ( 4, 10 ) AND
ezuser_role.role_id = ezrole.id |
SELECT id, role_id, module_name, function_name
FROM ezpolicy WHERE role_id='17' ORDER BY id ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='404' ORDER BY id ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='3177' ORDER BY id ASC |
SELECT id, limitation_id, value
FROM ezpolicy_limitation_value WHERE limitation_id='3977' ORDER BY value ASC |
SELECT id, limitation_id, value
FROM ezpolicy_limitation_value WHERE limitation_id='3978' ORDER BY value ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='3178' ORDER BY id ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='3179' ORDER BY id ASC |
SELECT id, limitation_id, value
FROM ezpolicy_limitation_value WHERE limitation_id='3979' ORDER BY value ASC |
SELECT id, limitation_id, value
FROM ezpolicy_limitation_value WHERE limitation_id='3980' ORDER BY value ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='3180' ORDER BY id ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='3181' ORDER BY id ASC |
SELECT id, limitation_id, value
FROM ezpolicy_limitation_value WHERE limitation_id='3981' ORDER BY value ASC |
SELECT id, limitation_id, value
FROM ezpolicy_limitation_value WHERE limitation_id='3982' ORDER BY value ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='3182' ORDER BY id ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='3183' ORDER BY id ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='3184' ORDER BY id ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='3185' ORDER BY id ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='3186' ORDER BY id ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='3187' ORDER BY id ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='3188' ORDER BY id ASC |
SELECT id, limitation_id, value
FROM ezpolicy_limitation_value WHERE limitation_id='3983' ORDER BY value ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='3189' ORDER BY id ASC |
SELECT id, role_id, module_name, function_name
FROM ezpolicy WHERE role_id='673' ORDER BY id ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='2575' ORDER BY id ASC |
SELECT id, limitation_id, value
FROM ezpolicy_limitation_value WHERE limitation_id='-1' ORDER BY value ASC |
SELECT id, role_id, module_name, function_name
FROM ezpolicy WHERE role_id='673' ORDER BY id ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='2575' ORDER BY id ASC |
SELECT id, limitation_id, value
FROM ezpolicy_limitation_value WHERE limitation_id='-1' ORDER BY value ASC |
SELECT id, role_id, module_name, function_name
FROM ezpolicy WHERE role_id='673' ORDER BY id ASC |
SELECT id, policy_id, identifier
FROM ezpolicy_limitation WHERE policy_id='2575' ORDER BY id ASC |
SELECT id, limitation_id, value
FROM ezpolicy_limitation_value WHERE limitation_id='-1' ORDER BY value ASC |
SELECT * FROM ezcobj_state_group, ezcobj_state_group_language WHERE ezcobj_state_group.identifier='ez_lock' AND ezcobj_state_group_language.contentobject_state_group_id=ezcobj_state_group.id AND
ezcobj_state_group.language_mask & 3 > 0
AND
( ezcobj_state_group_language.language_id & ezcobj_state_group.language_mask > 0 AND
( ( ezcobj_state_group.language_mask - ( ezcobj_state_group.language_mask & ezcobj_state_group_language.language_id ) ) & 1 )
+ ( ( ( ezcobj_state_group.language_mask - ( ezcobj_state_group.language_mask & ezcobj_state_group_language.language_id ) ) & 2 ) )
<
( ezcobj_state_group_language.language_id & 1 )
+ ( ( ezcobj_state_group_language.language_id & 2 ) )
)
LIMIT 0, 1 |
SELECT ezcobj_state.*, ezcobj_state_language.* FROM ezcobj_state, ezcobj_state_group, ezcobj_state_language WHERE ezcobj_state_group.id=1 AND ezcobj_state.group_id=ezcobj_state_group.id AND ezcobj_state_language.contentobject_state_id=ezcobj_state.id AND
ezcobj_state.language_mask & 3 > 0
AND
( ezcobj_state_language.language_id & ezcobj_state.language_mask > 0 AND
( ( ezcobj_state.language_mask - ( ezcobj_state.language_mask & ezcobj_state_language.language_id ) ) & 1 )
+ ( ( ( ezcobj_state.language_mask - ( ezcobj_state.language_mask & ezcobj_state_language.language_id ) ) & 2 ) )
<
( ezcobj_state_language.language_id & 1 )
+ ( ( ezcobj_state_language.language_id & 2 ) )
)
ORDER BY ezcobj_state.priority |
No source name found, skipping message |
DOMDocument::relaxNGValidate() [<a href='domdocument.relaxngvalidate'>domdocument.relaxngvalidate</a>]: Expecting an element , got nothing in /home/irc/public_html/ezpublish/lib/ezi18n/classes/eztstranslator.php on line 361 |
XML text for file extension/ezoe/translations/esl-ES/translation.ts did not validate |
share/translations/esl-ES/utf-8/translation.ts
share/translations/esl-ES/translation.ts
extension/templates/translations/esl-ES/utf-8/translation.ts
extension/templates/translations/esl-ES/translation.ts
extension/ezoe/translations/esl-ES/utf-8/translation.ts
extension/ezoe/translations/esl-ES/translation.ts
extension/ezfind/translations/esl-ES/utf-8/translation.ts
extension/ezfind/translations/esl-ES/translation.ts |
share/translations/esl-ES/translation.ts
extension/templates/translations/esl-ES/translation.ts
extension/ezfind/translations/esl-ES/translation.ts |
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 = 52136 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE contentobject_id=148147 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
ORDER BY path_string |
SELECT id, name, navigation_part_identifier, locale
FROM ezsection WHERE id='17' |
SELECT remote_id FROM ezcontentobject WHERE id = '148147' |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:17369', 'eznode:52136' ) AND is_original = 1 AND is_alias=0 |
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=148147 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=148147 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 17369 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT id, version, serialized_name_list, serialized_description_list, identifier, contentobject_name, url_alias_name, creator_id, modifier_id, created, remote_id, modified, is_container, always_available, language_mask, initial_language_id, sort_field, sort_order
FROM ezcontentclass WHERE id='1' AND version='0' ORDER BY version ASC
LIMIT 0, 2 |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id IN ( 1, 2, 3734, 17368, 17369 ) and
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
ORDER BY path_string |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:17369' ) AND is_original = 1 AND is_alias=0 |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '148147'
AND content_version = '3'
AND ( content_translation = 'eng-GB' OR language_id = '2' ) |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '148147'
AND content_version = '3'
AND ( content_translation = 'eng-GB' OR language_id = '2' ) |
SELECT id, version, serialized_name_list, serialized_description_list, identifier, contentobject_name, url_alias_name, creator_id, modifier_id, created, remote_id, modified, is_container, always_available, language_mask, initial_language_id, sort_field, sort_order
FROM ezcontentclass WHERE id='2' AND version='0' ORDER BY version ASC
LIMIT 0, 2 |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE contentclass_id='2' AND version='0' ORDER BY placement ASC |
SELECT id, contentobject_id, creator_id, version, status, created, modified, workflow_event_pos, user_id, language_mask, initial_language_id
FROM ezcontentobject_version WHERE version='3' AND contentobject_id='148147' ORDER BY version ASC |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as classattribute_identifier,
ezcontentclass_attribute.can_translate, ezcontentclass_attribute.serialized_name_list as attribute_serialized_name_list
FROM ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_attribute.version = '3' AND
ezcontentobject_attribute.contentobject_id = '148147' AND
ezcontentobject_version.contentobject_id = '148147' AND
ezcontentobject_version.version = '3' AND ezcontentobject_attribute.language_code = 'eng-GB' ORDER by
ezcontentclass_attribute.placement ASC |
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='148147' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE contentclass_id='2' AND version='0' ORDER BY placement ASC |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE contentclass_id='2' AND version='0' ORDER BY placement ASC |
SELECT * FROM ezurl WHERE id IN ( 5012 ) |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE contentclass_id='2' AND version='0' ORDER BY placement ASC |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE contentclass_id='2' AND version='0' ORDER BY placement ASC |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE contentclass_id='2' AND version='0' ORDER BY placement ASC |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE contentclass_id='2' AND version='0' ORDER BY placement ASC |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE contentclass_id='2' AND version='0' ORDER BY placement ASC |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE contentclass_id='2' AND version='0' ORDER BY placement ASC |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE contentclass_id='2' AND version='0' ORDER BY placement ASC |
SELECT
COUNT( outer_object.id ) AS count
FROM
ezcontentobject outer_object, ezcontentobject inner_object, ezcontentobject_link outer_link
INNER JOIN
ezcontentobject_link inner_link ON outer_link.id = inner_link.id
WHERE
outer_object.id = outer_link.to_contentobject_id
AND outer_object.status = 1
AND inner_object.id = inner_link.from_contentobject_id
AND inner_object.status = 1
AND inner_link.op_code = 0
AND inner_link.from_contentobject_id = 148147
AND inner_link.from_contentobject_version = 3
AND ( inner_link.relation_type & 7 ) <> 0 |
SELECT DISTINCT
ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE
ezcontentobject_tree.parent_node_id = 52136 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject.contentclass_id IN ( 12 ) 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 0
ORDER BY path_string ASC
LIMIT 0, 99 |
SELECT
count( DISTINCT ezcontentobject_tree.node_id ) as count
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE ezcontentobject_tree.parent_node_id = 52136 and
ezcontentobject.contentclass_id IN ( 12 ) AND
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 0 |
SELECT id, identifier FROM ezcontentclass where version=0 |
SELECT DISTINCT
ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE
ezcontentobject_tree.parent_node_id = 52136 and
( ezcontentobject_tree.priority < '99999' ) AND
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject.contentclass_id NOT IN ( 12, 13, 5 ) 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 0
ORDER BY path_string ASC
LIMIT 0, 20 |
SELECT
count( DISTINCT ezcontentobject_tree.node_id ) as count
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE ezcontentobject_tree.parent_node_id = 52136 and
ezcontentobject.contentclass_id NOT IN ( 12, 13, 5 ) AND
( ezcontentobject_tree.priority < '99999' ) AND
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 0 |
Attribute node-object-cached of variable $resourceData was not found but variable node eZTemplate::TYPE_OPTIMIZED_NODE is still present. This should not happen |
Undefined variable: nod_64160a1ebe9776d03324a68eeff17a3e in /home/irc/public_html/ezpublish/var/irc/cache/template/compiled/giverating-07caa52af5c437d6b2f55c1b1c51eb03.php on line 19 |
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 = '148147' AND
ezcontentobject_version.version = '3' AND
ezcontentobject_attribute.contentobject_id = '148147' AND ezcontentobject_attribute.version = '3' AND ezcontentobject_attribute.language_code = 'eng-GB'
ORDER BY
ezcontentclass_attribute.placement ASC,
ezcontentobject_attribute.language_code ASC |
Missing translation for message in context: 'design/standard/layout'. The untranslated message is: 'Give your comments' |
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=148147 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 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=148147 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 DISTINCT
ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE
ezcontentobject_tree.parent_node_id = 52136 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject.contentclass_id IN ( 13 ) 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 0
ORDER BY ezcontentobject.published ASC |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:17369', 'eznode:52136' ) AND is_original = 1 AND is_alias=0 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=148147 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
Module end 'content' |
Missing translation for message in context: 'kernel/navigationpart' with comment: 'Navigation part'. The untranslated message is: 'eZFind' |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE contentclass_id='2' AND version='0' ORDER BY placement ASC |
Checking cache: 52136 |
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 = 52136 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
cache_id changed: d17369 |
SELECT COUNT(*) AS nr
FROM ezcontentobject_tree AS tree
LEFT JOIN ezcontentobject AS obj
ON tree.contentobject_id=obj.id
LEFT JOIN ezcontentclass AS class
ON obj.contentclass_id=class.id
WHERE class.version=0
AND class.identifier='image'
AND parent_node_id=36760 |
SELECT tree.*, obj.*, class.identifier AS class_name
FROM ezcontentobject_tree AS tree
LEFT JOIN ezcontentobject AS obj
ON tree.contentobject_id=obj.id
LEFT JOIN ezcontentclass AS class
ON obj.contentclass_id=class.id
WHERE class.version=0
AND class.identifier='image'
AND parent_node_id=36760 LIMIT 25, 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
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 52136 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT COUNT(*) AS nr
FROM ezcontentobject_tree AS tree
LEFT JOIN ezcontentobject AS obj
ON tree.contentobject_id=obj.id
LEFT JOIN ezcontentclass AS class
ON obj.contentclass_id=class.id
WHERE class.version=0
AND class.identifier='image'
AND parent_node_id=36760 |
SELECT tree.*, obj.*, class.identifier AS class_name
FROM ezcontentobject_tree AS tree
LEFT JOIN ezcontentobject AS obj
ON tree.contentobject_id=obj.id
LEFT JOIN ezcontentclass AS class
ON obj.contentclass_id=class.id
WHERE class.version=0
AND class.identifier='image'
AND parent_node_id=36760 LIMIT 0, 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 ezcontentobject_tree.contentobject_id=148147 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, contentobject_id, creator_id, version, status, created, modified, workflow_event_pos, user_id, language_mask, initial_language_id
FROM ezcontentobject_version WHERE version='3' AND contentobject_id='148147' ORDER BY version ASC |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as classattribute_identifier,
ezcontentclass_attribute.can_translate, ezcontentclass_attribute.serialized_name_list as attribute_serialized_name_list
FROM ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_attribute.version = '3' AND
ezcontentobject_attribute.contentobject_id = '148147' AND
ezcontentobject_version.contentobject_id = '148147' AND
ezcontentobject_version.version = '3' AND ezcontentobject_attribute.language_code = 'eng-GB' ORDER by
ezcontentclass_attribute.placement ASC |
SELECT id, node_id, title, url, site_access, modified, modifier_id, created, creator_id, description, image_id, rss_version, active, status, access_url, number_of_objects, main_node_only
FROM ezrss_export WHERE status='1' ORDER BY title ASC |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 6304 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT DISTINCT
ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE
ezcontentobject_tree.parent_node_id = 6304 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject.contentclass_id IN ( 1, 2, 6, 8, 11, 14, 18, 33, 50 ) 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 0
ORDER BY ezcontentobject_tree.priority ASC |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
( ( ezcontentobject_attribute.version = '15' AND
ezcontentobject_attribute.contentobject_id = '6413' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '10' AND
ezcontentobject_attribute.contentobject_id = '6609' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) )
ORDER BY
ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=6413 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=6413 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:23770', 'eznode:8324', 'eznode:6304', 'eznode:6308' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '6413' |
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 = 6304 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE contentclass_id='2' AND version='0' ORDER BY placement ASC |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=6609 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=6609 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:23770', 'eznode:8324', 'eznode:6304', 'eznode:6309' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '6609' |
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 = 6304 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE contentclass_id='2' AND version='0' ORDER BY placement ASC |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 23776 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT DISTINCT
ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE
ezcontentobject_tree.parent_node_id = 23776 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject.contentclass_id IN ( 1, 2, 6, 8, 11, 14, 18, 25, 33, 50 ) 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 0
ORDER BY ezcontentobject_tree.priority ASC |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
( ( ezcontentobject_attribute.version = '5' AND
ezcontentobject_attribute.contentobject_id = '16082' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND
ezcontentobject_attribute.contentobject_id = '20077' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND
ezcontentobject_attribute.contentobject_id = '20362' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '6' AND
ezcontentobject_attribute.contentobject_id = '20363' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) )
ORDER BY
ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 17368 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT DISTINCT
ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE
ezcontentobject_tree.parent_node_id = 17368 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject.contentclass_id IN ( 1, 2, 6, 8, 11, 14, 18, 25, 33, 50 ) 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 0
ORDER BY ezcontentobject.published DESC |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
( ( ezcontentobject_attribute.version = '2' AND
ezcontentobject_attribute.contentobject_id = '145271' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '133210' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '4' AND
ezcontentobject_attribute.contentobject_id = '20370' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '2' AND
ezcontentobject_attribute.contentobject_id = '20368' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND
ezcontentobject_attribute.contentobject_id = '20366' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND
ezcontentobject_attribute.contentobject_id = '20151' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '4' AND
ezcontentobject_attribute.contentobject_id = '16083' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) )
ORDER BY
ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement 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=145271 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
count( DISTINCT ezcontentobject_tree.node_id ) as count
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE ezcontentobject_tree.parent_node_id = 49995 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 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
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE ezcontentobject_tree.contentobject_id=133210 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
count( DISTINCT ezcontentobject_tree.node_id ) as count
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE ezcontentobject_tree.parent_node_id = 40090 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 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
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE ezcontentobject_tree.contentobject_id=20370 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
count( DISTINCT ezcontentobject_tree.node_id ) as count
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE ezcontentobject_tree.parent_node_id = 24311 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 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
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE ezcontentobject_tree.contentobject_id=20368 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
count( DISTINCT ezcontentobject_tree.node_id ) as count
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE ezcontentobject_tree.parent_node_id = 24309 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 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
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE ezcontentobject_tree.contentobject_id=20366 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
count( DISTINCT ezcontentobject_tree.node_id ) as count
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE ezcontentobject_tree.parent_node_id = 24307 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 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
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE ezcontentobject_tree.contentobject_id=20151 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
count( DISTINCT ezcontentobject_tree.node_id ) as count
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE ezcontentobject_tree.parent_node_id = 24100 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 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
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE ezcontentobject_tree.contentobject_id=16083 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
count( DISTINCT ezcontentobject_tree.node_id ) as count
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE ezcontentobject_tree.parent_node_id = 17369 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 0 |
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=16082 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=16082 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:23770', 'eznode:23773', 'eznode:23776', 'eznode:23781' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '16082' |
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 = 23776 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=145271 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=145271 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:49995' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '145271' |
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 = 17368 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=133210 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=133210 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:40090' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '133210' |
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 = 17368 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=20370 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=20370 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:24311' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '20370' |
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 = 17368 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=20368 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=20368 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:24309' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '20368' |
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 = 17368 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=20366 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=20366 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:24307' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '20366' |
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 = 17368 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=20151 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=20151 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:24100' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '20151' |
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 = 17368 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=16083 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=16083 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:17369' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '16083' |
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 = 17368 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=20077 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=20077 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:23770', 'eznode:23773', 'eznode:23776', 'eznode:24098' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '20077' |
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 = 23776 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=20362 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=20362 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:23770', 'eznode:23773', 'eznode:23776', 'eznode:24575' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '20362' |
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 = 23776 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=20363 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=20363 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:23770', 'eznode:23773', 'eznode:23776', 'eznode:24577' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '20363' |
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 = 23776 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
Missing translation for message in context: 'design/admin/user/login'. The untranslated message is: 'Log in' |
Missing translation for message in context: 'design/standard/node/view'. The untranslated message is: 'Keep me updated' |
SELECT logo.*
FROM ezcontentobject_tree AS node
LEFT JOIN ezcontentobject_tree AS tree
ON node.path_string LIKE CONCAT( tree.path_string, '%' )
LEFT JOIN ezcontentobject AS folder
ON tree.contentobject_id=folder.id
LEFT JOIN ezcontentclass AS folderclass
ON folder.contentclass_id=folderclass.id
LEFT JOIN ezcontentobject_link AS link
ON link.from_contentobject_id=folder.id
AND link.from_contentobject_version=folder.current_version
LEFT JOIN ezcontentobject AS logo
ON logo.id=link.to_contentobject_id
LEFT JOIN ezcontentclass AS logoclass
ON logo.contentclass_id=logoclass.id
WHERE node.node_id=52136
AND folderclass.identifier='folder'
AND logoclass.identifier='logo'
ORDER BY tree.path_string DESC
LIMIT 1 |
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='127339' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
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=127339 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=127339 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:43', 'eznode:552', 'eznode:36760', 'eznode:36761' ) 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 = 36760 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_version.contentobject_id = '127339' AND
ezcontentobject_version.version = '1' AND
ezcontentobject_attribute.contentobject_id = '127339' AND ezcontentobject_attribute.version = '1' AND
( ezcontentobject_attribute.language_id & ezcontentobject_version.language_mask > 0 AND
( ( ezcontentobject_version.language_mask - ( ezcontentobject_version.language_mask & ezcontentobject_attribute.language_id ) ) & 1 )
+ ( ( ( ezcontentobject_version.language_mask - ( ezcontentobject_version.language_mask & ezcontentobject_attribute.language_id ) ) & 2 ) )
<
( ezcontentobject_attribute.language_id & 1 )
+ ( ( ezcontentobject_attribute.language_id & 2 ) )
)
ORDER BY
ezcontentclass_attribute.placement ASC,
ezcontentobject_attribute.language_code ASC |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE id='118' AND version='0' |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE contentclass_id='2' AND version='0' ORDER BY placement ASC |
SELECT id, version, serialized_name_list, serialized_description_list, identifier, contentobject_name, url_alias_name, creator_id, modifier_id, created, remote_id, modified, is_container, always_available, language_mask, initial_language_id, sort_field, sort_order
FROM ezcontentclass WHERE id='5' AND version='0' ORDER BY version ASC
LIMIT 0, 2 |
Missing translation for message in context: 'design/standard/layout'. The untranslated message is: 'Overview' |
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 = 17369 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT DISTINCT
ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE
ezcontentobject_tree.parent_node_id = 17369 and
( ezcontentobject_tree.priority < '99999' ) AND
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject.contentclass_id NOT IN ( 12, 13, 5 ) 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 0
ORDER BY ezcontentobject_tree.priority ASC
LIMIT 0, 20 |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
( ( ezcontentobject_attribute.version = '4' AND
ezcontentobject_attribute.contentobject_id = '16084' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND
ezcontentobject_attribute.contentobject_id = '16085' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND
ezcontentobject_attribute.contentobject_id = '16086' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND
ezcontentobject_attribute.contentobject_id = '16087' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '6' AND
ezcontentobject_attribute.contentobject_id = '140672' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '140674' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '141707' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '146609' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) OR ( ezcontentobject_attribute.version = '3' AND
ezcontentobject_attribute.contentobject_id = '148147' AND
ezcontentobject_attribute.language_code = 'eng-GB' ) )
ORDER BY
ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC |
SELECT
count( DISTINCT ezcontentobject_tree.node_id ) as count
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE ezcontentobject_tree.parent_node_id = 17369 and
ezcontentobject.contentclass_id NOT IN ( 12, 13, 5 ) AND
( ezcontentobject_tree.priority < '99999' ) AND
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 0 |
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=16084 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=16084 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:17369', 'eznode:17370' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '16084' |
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 = 17369 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=16085 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=16085 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:17369', 'eznode:17371' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '16085' |
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 = 17369 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=16086 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=16086 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:17369', 'eznode:17372' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '16086' |
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 = 17369 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=16087 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=16087 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:17369', 'eznode:17373' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '16087' |
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 = 17369 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=140672 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=140672 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:17369', 'eznode:46642' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '140672' |
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 = 17369 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=140674 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=140674 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:17369', 'eznode:46643' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '140674' |
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 = 17369 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=141707 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=141707 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:17369', 'eznode:47470' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '141707' |
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 = 17369 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=146609 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=146609 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:17369', 'eznode:51007' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '146609' |
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 = 17369 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 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='1' AND contentobject_id='146609' ORDER BY version ASC |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as classattribute_identifier,
ezcontentclass_attribute.can_translate, ezcontentclass_attribute.serialized_name_list as attribute_serialized_name_list
FROM ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '146609' AND
ezcontentobject_version.contentobject_id = '146609' AND
ezcontentobject_version.version = '1' AND ezcontentobject_attribute.language_code = 'eng-GB' ORDER by
ezcontentclass_attribute.placement ASC |
SELECT url, is_valid FROM ezurl WHERE id='34025' |
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=148147 |
SELECT l.contentobject_state_id, s.identifier AS state_identifier, g.identifier AS state_group_identifier
FROM ezcobj_state_link l, ezcobj_state s, ezcobj_state_group g
WHERE l.contentobject_id=148147 AND
s.id=l.contentobject_state_id AND
g.id=s.group_id |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:3734', 'eznode:17368', 'eznode:17369', 'eznode:52136' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '148147' |
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 = 17369 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 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 & 7 ) <> 0
AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
ezcontentobject_link.from_contentobject_id='148147' AND
ezcontentobject_link.from_contentobject_version='3'
AND ezcontentobject.id = ezcontentobject_name.contentobject_id AND
ezcontentobject.current_version = ezcontentobject_name.content_version AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT id FROM ezsection WHERE name LIKE 'Extranet' |
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 = 52136 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
) |
SELECT DISTINCT
ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE
ezcontentobject_tree.path_string like '/1/2/3734/17368/17369/52136/%' and
( ezcontentobject.section_id <> '19' ) AND
ezcontentclass.version=0 AND
ezcontentobject_tree.node_id != 52136 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject.contentclass_id IN ( 2, 6, 11, 12, 30, 57 ) 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 ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1, 14, 15, 17, 3, 9) AND ( ( ezcontentobject_tree.path_string like '/1/2/1006/%' OR ezcontentobject_tree.path_string like '/1/2/104/%' OR ezcontentobject_tree.path_string like '/1/2/108/%' OR ezcontentobject_tree.path_string like '/1/2/23770/%' OR ezcontentobject_tree.path_string like '/1/2/3734/%' OR ezcontentobject_tree.path_string like '/1/2/3736/%' OR ezcontentobject_tree.path_string like '/1/43/%' ) )) OR (( ( ezcontentobject_tree.path_string like '/1/5/7832/%' ) )) OR (ezcontentobject_tree.path_string like '/1/2/104/102/119/17780/16973/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/36956/36958/17544/%') OR (ezcontentobject_tree.path_string like '/1/2/104/102/17346/24533/%'))
AND
ezcontentobject.language_mask & 3 > 0
ORDER BY ezcontentobject.published DESC
LIMIT 0, 50 |
SELECT DISTINCT node_id, path_string
FROM ezrss_import
LEFT JOIN ezcontentobject_tree ON destination_node_id=node_id WHERE active=1 |
array_slice() expects parameter 1 to be array, null given in /home/irc/public_html/ezpublish/var/irc/cache/template/compiled/page_copyright-73ccf3d9fac742fc949f4e2aba66b5c2.php on line 56 |
End |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE contentclass_id='2' AND version='0' ORDER BY placement ASC |
Timing points:| Checkpoint | Elapsed | Rel. Elapsed | Memory | Rel. Memory |
|---|
| Script start |
0.0000 sec | 0.3463 sec |
1,625.2656 KB | 3,055.7578 KB | | Module start 'content' |
0.3463 sec | 2.8309 sec |
4,681.0234 KB | 17,207.6250 KB | | Module end 'content' |
3.1772 sec | 3.0009 sec |
21,888.6484 KB | 5,020.3750 KB | | End |
6.1781 sec | |
26,909.0234 KB | | | Total runtime: | 6.6694 sec | | | Peak memory usage: | 29,675.2070 KB |
Time accumulators:| Accumulator | Elapsed | Percent | Count | Average |
|---|
| ini_load | | | | | | Load cache | 0.2291 sec | 3.1789% | 21 | 0.0109 sec | | FindInputFiles | 0.0249 sec | 0.3458% | 21 | 0.0012 sec | | Parse | 0.1840 sec | 2.5534% | 18 | 0.0102 sec | | Save Cache | 0.0109 sec | 0.1519% | 18 | 0.0006 sec | | Mysql Total | | | | | | Mysql_queries | 2.2416 sec | 31.1054% | 251 | 0.0089 sec | | Looping result | 0.0077 sec | 0.1075% | 226 | 0.0000 sec | | TS translator | | | | | | TS init | 1.5667 sec | 21.7403% | 1 | 1.5667 sec | | TS load | 1.1383 sec | 15.7959% | 3 | 0.3794 sec | | TS store cache | 0.3171 sec | 4.4004% | 1 | 0.3171 sec | | Template Total | 4.0375 sec | 56.0% | 3 | 1.3458 sec | | Template load | 0.2845 sec | 3.9483% | 3 | 0.0948 sec | | String conversion in template resource | 0.0061 sec | 0.0845% | 178 | 0.0000 sec | | Template parser: create text elements | 0.0410 sec | 0.5683% | 50 | 0.0008 sec | | Template parser: remove whitespace | 0.0090 sec | 0.1245% | 50 | 0.0002 sec | | Template parser: construct tree | 0.1919 sec | 2.6623% | 50 | 0.0038 sec | | Template load and register function | 0.0170 sec | 0.2354% | 11 | 0.0015 sec | | Template processing | 3.7528 sec | 52.0739% | 3 | 1.2509 sec | | states | | | | | | state_id_array | 0.1213 sec | 1.6830% | 24 | 0.0051 sec | | state_identifier_array | 0.0114 sec | 0.1575% | 25 | 0.0005 sec | | override | | | | | | Cache load | 0.0751 sec | 1.0424% | 79 | 0.0010 sec | | Sytem overhead | | | | | | Fetch class attribute name | 0.0009 sec | 0.0127% | 3 | 0.0003 sec | | Fetch class attribute can translate value | 0.0000 sec | 0.0005% | 1 | 0.0000 sec | | class_abstraction | | | | | | Instantiating content class attribute | 0.0000 sec | 0.0006% | 3 | 0.0000 sec | | Debug-Accumulator | | | | | | menutop | 0.0639 sec | 0.8869% | 1 | 0.0639 sec | | menulooptop | 0.0328 sec | 0.4549% | 1 | 0.0328 sec | | menumain | 0.5343 sec | 7.4140% | 1 | 0.5343 sec | | menuloopmain | 0.2863 sec | 3.9724% | 1 | 0.2863 sec | | visual | 0.4502 sec | 6.2465% | 1 | 0.4502 sec | | toc | 1.3144 sec | 18.2393% | 1 | 1.3144 sec | | related | 0.0395 sec | 0.5478% | 1 | 0.0395 sec | | latest | 0.1023 sec | 1.4202% | 1 | 0.1023 sec | | XML | | | | | | Image XML parsing | 0.0902 sec | 1.2510% | 1 | 0.0902 sec | | General | | | | | | String conversion | 0.1601 sec | 2.2221% | 20460 | 0.0000 sec | | INI string conversion | 0.0080 sec | 0.1115% | 81 | 0.0001 sec | | String conversion w/ mbstring | 0.0051 sec | 0.0713% | 47 | 0.0001 sec | | dbfile | 0.0902 sec | 1.2522% | 24 | 0.0038 sec | | Total script time: | 7.2066 sec | |
Templates used to render the page: |
