|
|
Script start |
Module start 'content' |
SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM ezuser WHERE contentobject_id='10' |
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 = 73 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, name, navigation_part_identifier, locale
FROM ezsection WHERE id='1' |
SELECT remote_id FROM ezcontentobject WHERE id = '71' |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:73' ) 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=71 |
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=71 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 = 2 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, 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 ) and
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
)
ORDER BY path_string |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '71'
AND content_version = '7'
AND ( content_translation = 'fre-FR' OR language_id = '2' ) |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '71'
AND content_version = '7'
AND ( content_translation = 'fre-FR' OR language_id = '2' ) |
eZTemplate: Loading template "node/view/full.tpl" with resource "design" |
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
, a0.sort_key_int
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
, ezcontentobject_attribute a0
, ezcontentobject_attribute a1 , ezcontentobject_attribute a2
WHERE
ezcontentobject_tree.parent_node_id = 175 and
a0.contentobject_id = ezcontentobject.id AND
a0.contentclassattribute_id = 419 AND
a0.version = ezcontentobject_name.content_version AND
( a0.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 2 ) << 1 )
<
( a0.language_id & 1 )
+ ( ( a0.language_id & 4 ) >> 1 )
+ ( ( a0.language_id & 2 ) << 1 )
)
AND
a1.contentobject_id = ezcontentobject.id AND
a1.contentclassattribute_id = 419 AND
a1.version = ezcontentobject_name.content_version AND
( a1.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a1.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a1.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a1.language_id ) ) & 2 ) << 1 )
<
( a1.language_id & 1 )
+ ( ( a1.language_id & 4 ) >> 1 )
+ ( ( a1.language_id & 2 ) << 1 )
)
AND
a2.contentobject_id = ezcontentobject.id AND
a2.contentclassattribute_id = 417 AND
a2.version = ezcontentobject_name.content_version AND
( a2.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a2.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a2.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a2.language_id ) ) & 2 ) << 1 )
<
( a2.language_id & 1 )
+ ( ( a2.language_id & 4 ) >> 1 )
+ ( ( a2.language_id & 2 ) << 1 )
)
AND ( a1.sort_key_int <= '1328854091' AND a2.sort_key_string > '0' ) 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 ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3)))
AND
ezcontentobject.language_mask & 7 > 0
ORDER BY a0.sort_key_int DESC
LIMIT 0, 1 |
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 = '1' AND
ezcontentobject_attribute.contentobject_id = '700292' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) )
ORDER BY
ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:173', 'eznode:175', 'eznode:699838' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:73' ) AND is_original = 1 AND is_alias=0 |
SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='700274' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_version.contentobject_id = '700274' AND
ezcontentobject_version.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700274' AND ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.language_code = 'fre-FR'
ORDER BY
ezcontentclass_attribute.placement ASC,
ezcontentobject_attribute.language_code 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='700294' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_version.contentobject_id = '700294' AND
ezcontentobject_version.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700294' AND ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.language_code = 'fre-FR'
ORDER BY
ezcontentclass_attribute.placement ASC,
ezcontentobject_attribute.language_code 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='573794' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '573794'
AND content_version = '1'
AND ( content_translation = 'fre-FR' OR 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=700292 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
ORDER BY path_string |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 175 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 173 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 175 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:173', 'eznode:175' ) 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 = 175 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 177 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 173 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 177 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:173', 'eznode:177' ) 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 = 177 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 183 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 173 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 183 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:173', 'eznode:183' ) 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 = 183 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 699815 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 35439 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 35441 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 2 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject.*,
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='700292' 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 id='426' AND version='0' |
eZTemplate: Loading template "content/datatype/view/ezsrrating.tpl" with resource "design" |
SELECT contentobject_id, contentobject_attribute_id, rating_average, rating_count
FROM ezstarrating WHERE contentobject_id='700292' AND contentobject_attribute_id='6736896' |
SELECT DISTINCT e0.id AS e0_id, e0.parent AS e0_parent, e0.lang_mask AS e0_lang_mask, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.action AS e0_action, e0.link AS e0_link FROM ezurlalias_ml e0 WHERE e0.parent = 0 AND (e0.lang_mask & 7 > 0) AND e0.text_md5 = MD5( 'reunions' ) |
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 = 35439 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT DISTINCT
ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
, a0.sort_key_int
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
, ezcontentobject_attribute a0
, ezcontentobject_attribute a1
WHERE
ezcontentobject_tree.parent_node_id = 35439 and
a0.contentobject_id = ezcontentobject.id AND
a0.contentclassattribute_id = 358 AND
a0.version = ezcontentobject_name.content_version AND
( a0.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 2 ) << 1 )
<
( a0.language_id & 1 )
+ ( ( a0.language_id & 4 ) >> 1 )
+ ( ( a0.language_id & 2 ) << 1 )
)
AND
a1.contentobject_id = ezcontentobject.id AND
a1.contentclassattribute_id = 355 AND
a1.version = ezcontentobject_name.content_version AND
( a1.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a1.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a1.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a1.language_id ) ) & 2 ) << 1 )
<
( a1.language_id & 1 )
+ ( ( a1.language_id & 4 ) >> 1 )
+ ( ( a1.language_id & 2 ) << 1 )
)
AND ( a1.sort_key_int = '1328828400' ) AND
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject.contentclass_id IN ( 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 ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3)))
AND
ezcontentobject.language_mask & 7 > 0
ORDER BY a0.sort_key_int 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 = '1' AND
ezcontentobject_attribute.contentobject_id = '700866' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700789' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) )
ORDER BY
ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC |
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
, a0.sort_key_int
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
, ezcontentobject_attribute a0
WHERE
ezcontentobject_tree.parent_node_id = 700336 and
a0.contentobject_id = ezcontentobject.id AND
a0.contentclassattribute_id = 361 AND
a0.version = ezcontentobject_name.content_version AND
( a0.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 2 ) << 1 )
<
( a0.language_id & 1 )
+ ( ( a0.language_id & 4 ) >> 1 )
+ ( ( a0.language_id & 2 ) << 1 )
)
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 ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3)))
AND
ezcontentobject.language_mask & 7 > 0
ORDER BY a0.sort_key_int 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 = '1' AND
ezcontentobject_attribute.contentobject_id = '700867' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700887' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700900' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700913' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700932' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700948' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700964' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700981' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) )
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=700867 |
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=700867 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 & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700338' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '700867' |
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 = 700336 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject.*,
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='700866' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700338' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700338' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700338' ) AND is_original = 1 AND is_alias=0 |
SELECT id, serialized_name_list, serialized_description_list, version, contentclass_id, identifier, placement, is_searchable, is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3, data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2, data_text3, data_text4, data_text5, serialized_data_text, category
FROM ezcontentclass_attribute WHERE id='398' AND 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=700887 |
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=700887 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 & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700361' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '700887' |
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 = 700336 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700361' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700361' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700361' ) 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=700900 |
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=700900 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 & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700376' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '700900' |
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 = 700336 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700376' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700376' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700376' ) 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=700913 |
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=700913 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 & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700391' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '700913' |
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 = 700336 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700391' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700391' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700391' ) 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=700932 |
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=700932 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 & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700413' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '700932' |
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 = 700336 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700413' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700413' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700413' ) 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=700948 |
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=700948 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 & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700432' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '700948' |
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 = 700336 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700432' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700432' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700432' ) 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=700964 |
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=700964 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 & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700451' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '700964' |
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 = 700336 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700451' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700451' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700451' ) 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=700981 |
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=700981 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 & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700471' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '700981' |
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 = 700336 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700471' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700471' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700336', 'eznode:700471' ) AND is_original = 1 AND is_alias=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 = 700247 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 ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3)))
AND
ezcontentobject.language_mask & 7 > 0
ORDER BY path_string 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 = '1' AND
ezcontentobject_attribute.contentobject_id = '700790' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700797' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700808' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700820' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700832' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700843' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '700854' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) )
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=700790 |
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=700790 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 & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700249' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '700790' |
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 = 700247 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject.*,
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='700789' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700249' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700249' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700249' ) 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=700797 |
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=700797 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 & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700258' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '700797' |
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 = 700247 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700258' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700258' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700258' ) 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=700808 |
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=700808 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 & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700271' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '700808' |
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 = 700247 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700271' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700271' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700271' ) 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=700820 |
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=700820 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 & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700284' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '700820' |
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 = 700247 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700284' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700284' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700284' ) 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=700832 |
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=700832 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 & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700298' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '700832' |
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 = 700247 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700298' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700298' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700298' ) 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=700843 |
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=700843 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 & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700311' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '700843' |
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 = 700247 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700311' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700311' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700311' ) 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=700854 |
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=700854 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 & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700324' ) AND is_original = 1 AND is_alias=0 |
SELECT remote_id FROM ezcontentobject WHERE id = '700854' |
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 = 700247 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700324' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700324' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:35439', 'eznode:700247', 'eznode:700324' ) AND is_original = 1 AND is_alias=0 |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:73' ) 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=71 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' |
Missing translation for message in context: 'kernel/navigationpart' with comment: 'Navigation part'. The untranslated message is: 'eqshop' |
Missing translation for message in context: 'kernel/navigationpart' with comment: 'Navigation part'. The untranslated message is: 'crm' |
eZTemplate: Loading template "pagelayout.tpl" with resource "design" |
SELECT id, section_id, owner_id, contentclass_id, name, is_published, published, modified, current_version, status, remote_id, language_mask, initial_language_id
FROM ezcontentobject WHERE contentclass_id='15' ORDER BY id ASC
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
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 73 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject_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 = '71' AND
ezcontentobject_version.version = '7' AND
ezcontentobject_attribute.contentobject_id = '71' AND ezcontentobject_attribute.version = '7' AND ezcontentobject_attribute.language_code = 'fre-FR'
ORDER BY
ezcontentclass_attribute.placement ASC,
ezcontentobject_attribute.language_code 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='71' 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 id='238' AND version='0' |
eZTemplate: Loading template "content/datatype/view/ezkeyword.tpl" with resource "design" |
SELECT ezkeyword.keyword FROM ezkeyword_attribute_link, ezkeyword
WHERE ezkeyword_attribute_link.keyword_id=ezkeyword.id AND
ezkeyword_attribute_link.objectattribute_id='309' |
SELECT id FROM ezcontentobject WHERE remote_id='bc441cff6f1d52aad231f4c8ba7d9403' |
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=71 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, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:73' ) AND is_original = 1 AND is_alias=0 |
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_version.contentobject_id = '54' AND
ezcontentobject_version.version = '1' AND
ezcontentobject_attribute.contentobject_id = '54' AND ezcontentobject_attribute.version = '1' AND ezcontentobject_attribute.language_code = 'fre-FR'
ORDER BY
ezcontentclass_attribute.placement ASC,
ezcontentobject_attribute.language_code ASC |
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 = 73 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject.contentclass_id IN ( 59 ) AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3)))
AND
ezcontentobject.language_mask & 7 > 0
ORDER BY path_string 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 = '84' AND
ezcontentobject_attribute.contentobject_id = '161969' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '8' AND
ezcontentobject_attribute.contentobject_id = '162336' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) )
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 = 34649 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:34649' ) 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 = 51940 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:51940' ) 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 = 2 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT ezcontentobject_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 = '117' AND
ezcontentobject_version.version = '9' AND
ezcontentobject_attribute.contentobject_id = '117' AND ezcontentobject_attribute.version = '9' AND ezcontentobject_attribute.language_code = 'fre-FR'
ORDER BY
ezcontentclass_attribute.placement ASC,
ezcontentobject_attribute.language_code ASC |
Unknown session variable 'custom_path' |
Unknown session variable 'custom_path_html' |
Variable 'lang_code' is already defined. |
SELECT DISTINCT e0.id AS e0_id, e0.parent AS e0_parent, e0.lang_mask AS e0_lang_mask, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.action AS e0_action, e0.link AS e0_link FROM ezurlalias_ml e0 WHERE e0.parent = 0 AND (e0.lang_mask & 7 > 0) AND e0.text_md5 = MD5( 'news' ) |
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 = 67 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
) |
SELECT DISTINCT
ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE
ezcontentobject_tree.parent_node_id = 173 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 ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
)
AND ezcontentobject_tree.is_invisible = 0
AND ((ezcontentobject.section_id in (1)) OR (ezcontentobject.contentclass_id in (29, 33, 35, 36, 37, 45) AND ezcontentobject.section_id in (3)))
AND
ezcontentobject.language_mask & 7 > 0
ORDER BY path_string 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 = '4' AND
ezcontentobject_attribute.contentobject_id = '152' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '2' AND
ezcontentobject_attribute.contentobject_id = '153' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '4' AND
ezcontentobject_attribute.contentobject_id = '154' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '3' AND
ezcontentobject_attribute.contentobject_id = '155' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '5' AND
ezcontentobject_attribute.contentobject_id = '156' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '5' AND
ezcontentobject_attribute.contentobject_id = '157' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '4' AND
ezcontentobject_attribute.contentobject_id = '158' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) )
ORDER BY
ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:173', 'eznode:175' ) AND is_original = 1 AND is_alias=0 |
Variable 'theme_html' is already defined. |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:173', 'eznode:177' ) AND is_original = 1 AND is_alias=0 |
Variable 'theme_html' is already defined. |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:173', 'eznode:179' ) AND is_original = 1 AND is_alias=0 |
Variable 'theme_html' is already defined. |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:173', 'eznode:181' ) AND is_original = 1 AND is_alias=0 |
Variable 'theme_html' is already defined. |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:173', 'eznode:183' ) AND is_original = 1 AND is_alias=0 |
Variable 'theme_html' is already defined. |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:173', 'eznode:185' ) AND is_original = 1 AND is_alias=0 |
Variable 'theme_html' is already defined. |
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 7 > 0 ) AND action in ( 'eznode:2', 'eznode:173', 'eznode:187' ) AND is_original = 1 AND is_alias=0 |
End |
eZTemplate: Loading template "setup/debug_toolbar.tpl" with resource "design" |
Timing points:| Checkpoint | Elapsed | Rel. Elapsed | Memory | Rel. Memory |
|---|
| Script start |
0.0000 sec | 0.0725 sec |
2,695.0938 KB | 4,437.0391 KB | | Module start 'content' |
0.0725 sec | 0.8491 sec |
7,132.1328 KB | 16,141.4844 KB | | Module end 'content' |
0.9216 sec | 0.1613 sec |
23,273.6172 KB | 1,739.6797 KB | | End |
1.0829 sec | |
25,013.2969 KB | | | Total runtime: | 1.1059 sec | | | Peak memory usage: | 28,727.9375 KB |
Time accumulators:| Accumulator | Elapsed | Percent | Count | Average |
|---|
| ini_load | | | | | | Load cache | 0.0299 sec | 2.5873% | 17 | 0.0018 sec | | FindInputFiles | 0.0157 sec | 1.3531% | 17 | 0.0009 sec | | Mysql Total | | | | | | Mysqli_queries | 0.4448 sec | 38.4498% | 207 | 0.0021 sec | | Looping result | 0.0087 sec | 0.7487% | 206 | 0.0000 sec | | TS translator | | | | | | TS init | 0.0143 sec | 1.2405% | 6 | 0.0024 sec | | TS cache load | 0.0076 sec | 0.6586% | 6 | 0.0013 sec | | TS context load | 0.0060 sec | 0.5165% | 6 | 0.0010 sec | | Template Total | 0.9131 sec | 78.9% | 3 | 0.3044 sec | | Template load | 0.0282 sec | 2.4338% | 3 | 0.0094 sec | | Template processing | 0.8847 sec | 76.4838% | 3 | 0.2949 sec | | Template load and register function | 0.0031 sec | 0.2683% | 1 | 0.0031 sec | | states | | | | | | state_id_array | 0.0199 sec | 1.7198% | 16 | 0.0012 sec | | state_identifier_array | 0.0206 sec | 1.7800% | 17 | 0.0012 sec | | override | | | | | | Cache load | 0.0122 sec | 1.0568% | 5 | 0.0024 sec | | Sytem overhead | | | | | | Fetch class attribute name | 0.0032 sec | 0.2792% | 2 | 0.0016 sec | | class_abstraction | | | | | | Instantiating content class attribute | 0.0000 sec | 0.0031% | 2 | 0.0000 sec | | General | | | | | | String conversion | 0.0000 sec | 0.0023% | 2 | 0.0000 sec | | dbfile | 0.0011 sec | 0.0965% | 23 | 0.0000 sec | | Total script time: | 1.1567 sec | |
Templates used to render the page:| Usage count | Requested template | Template | Template loaded | Edit | Override |
|---|
| 1 | node/view/full.tpl | content/home_equidia.tpl | extension/equidia/design/equidia/override/templates/content/home_equidia.tpl |  |  | | 1 | content/datatype/view/ezsrrating.tpl | <No override> | extension/equidia/design/equidia/templates/content/datatype/view/ezsrrating.tpl | | | | 1 | pagelayout.tpl | <No override> | extension/equidia/design/equidia/templates/pagelayout.tpl | | | | 1 | content/datatype/view/ezkeyword.tpl | <No override> | design/standard/templates/content/datatype/view/ezkeyword.tpl | | | | 1 | setup/debug_toolbar.tpl | <No override> | design/standard/templates/setup/debug_toolbar.tpl | | | | | | | | | | Number of times templates used: 5
Number of unique templates used: 5 | | Time used to render template usage: 0.0003 secs |
|
