SELECT e0.id AS e0_id, e0.link AS e0_link, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.is_alias AS e0_is_alias, e0.alias_redirects AS e0_alias_redirects, e1.id AS e1_id, e1.link AS e1_link, e1.text AS e1_text, e1.text_md5 AS e1_text_md5, e1.is_alias AS e1_is_alias, e1.alias_redirects AS e1_alias_redirects, e2.id AS e2_id, e2.link AS e2_link, e2.text AS e2_text, e2.text_md5 AS e2_text_md5, e2.is_alias AS e2_is_alias, e2.action AS e2_action, e2.alias_redirects AS e2_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1, ezurlalias_ml e2 WHERE e0.parent = 0 AND (e0.lang_mask & 3 > 0) AND e0.text_md5 =  MD5( 'forums' )  AND e1.parent = e0.link AND (e1.lang_mask & 3 > 0) AND e1.text_md5 =  MD5( 'developer' )  AND e2.parent = e1.link AND (e2.lang_mask & 3 > 0) AND e2.text_md5 =  MD5( 'how-to-change-the-user-register-form-to-a-get-method' ) 
LIMIT 0, 1

<hr>
SELECT e0.id AS e0_id, e0.link AS e0_link, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.is_alias AS e0_is_alias, e0.alias_redirects AS e0_alias_redirects, e1.id AS e1_id, e1.link AS e1_link, e1.text AS e1_text, e1.text_md5 AS e1_text_md5, e1.is_alias AS e1_is_alias, e1.alias_redirects AS e1_alias_redirects, e2.id AS e2_id, e2.link AS e2_link, e2.text AS e2_text, e2.text_md5 AS e2_text_md5, e2.is_alias AS e2_is_alias, e2.action AS e2_action, e2.alias_redirects AS e2_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1, ezurlalias_ml e2 WHERE e0.parent = 0 AND (e0.lang_mask & 3 > 0) AND e0.text_md5 =  MD5( 'forums' )  AND e1.parent = e0.link AND (e1.lang_mask & 3 > 0) AND e1.text_md5 =  MD5( 'developer' )  AND e2.parent = e1.link AND (e2.lang_mask & 3 > 0) AND e2.text_md5 =  MD5( 'how-to-change-the-user-register-form-to-a-get-method' ) 
LIMIT 0, 1

<hr>

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

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222', 'eznode:75851' ) AND is_original = 1 AND is_alias=0

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

<hr>
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=75947

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

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

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

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

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

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '75947'
                       AND content_version = '2'
                       AND ( content_translation = 'eng-GB' OR language_id = '2' )

<hr>
SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '75947'
                       AND content_version = '2'
                       AND ( content_translation = 'eng-GB' OR language_id = '2' )

<hr>
SELECT
                        count( DISTINCT ezcontentobject_tree.node_id ) as count
                  FROM
                       ezcontentobject_tree
                       INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id)
                       INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id)
                       INNER JOIN ezcontentobject_name ON (
                           ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND
                           ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version
                       )
                       
                       
                       
                  WHERE ezcontentobject_tree.parent_node_id = 75851 and
                        
                        
                        
                        
                        ezcontentclass.version=0 AND
                        
                        
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 

                        AND ezcontentobject_tree.is_invisible = 0
                         AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) 
                        
                         AND 
 ezcontentobject.language_mask & 3 > 0

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

<hr>
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )     WHERE  ezcontentobject_tree.path_string like '/1/2/63/222/%' and                                 ( ezcontentobject_tree.modified_subnode < '1757276529'  ) AND  ezcontentobject_tree.node_id != 222 AND     ezcontentobject.contentclass_id  IN  ( 20 ) AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2)))   AND 
 ezcontentobject.language_mask & 3 > 0 
  ORDER BY modified_subnode DESC, ezcontentobject_tree.node_id DESC
LIMIT 0, 1

<hr>
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
                    ezcontentobject_attribute, ezcontentclass_attribute
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ( ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '75936' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

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

<hr>
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )     WHERE  ezcontentobject_tree.path_string like '/1/2/63/222/%' and                                 ( ezcontentobject_tree.modified_subnode > '1757276529'  ) AND  ezcontentobject_tree.node_id != 222 AND     ezcontentobject.contentclass_id  IN  ( 20 ) AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2)))   AND 
 ezcontentobject.language_mask & 3 > 0 
  ORDER BY modified_subnode ASC, ezcontentobject_tree.node_id ASC
LIMIT 0, 1

<hr>
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
                    ezcontentobject_attribute, ezcontentclass_attribute
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ( ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '75940' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222', 'eznode:75840' ) AND is_original = 1 AND is_alias=0

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

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222', 'eznode:75844' ) AND is_original = 1 AND is_alias=0

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

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

<hr>
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 = '8021' AND
                    ezcontentobject_version.version = '5' AND
                    ezcontentobject_attribute.contentobject_id = '8021' AND                    ezcontentobject_attribute.version = '5' AND                    ezcontentobject_attribute.language_code = 'eng-GB' 
                  
                  ORDER BY
                    ezcontentclass_attribute.placement ASC,
                    ezcontentobject_attribute.language_code ASC

<hr>
SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '8021'
                       AND content_version = '5'
                       AND ( content_translation = 'eng-GB' OR language_id = '3' )

<hr>
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='180' AND version='0'

<hr>
SELECT DISTINCT ezuser.contentobject_id, ezuser.login, ezuser.email, ezuser.password_hash, ezuser.password_hash_type
                                       FROM ezcontentobject_version, ezuser where ezcontentobject_version.contentobject_id='75947'
                                       AND ezcontentobject_version.creator_id=ezuser.contentobject_id

<hr>
SELECT node_id
                  FROM ezcontentobject_tree
                  WHERE contentobject_id=75947 AND
                  main_node_id = node_id

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

<hr>
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 = '75947' AND
                    ezcontentobject_version.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '75947' AND                    ezcontentobject_attribute.version = '2' AND                    ezcontentobject_attribute.language_code = 'eng-GB' 
                  
                  ORDER BY
                    ezcontentclass_attribute.placement ASC,
                    ezcontentobject_attribute.language_code ASC

<hr>
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='250' AND version='0'

<hr>
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )     WHERE ezcontentobject_tree.parent_node_id = 75851 and       
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2)))   AND 
 ezcontentobject.language_mask & 3 > 0 
  ORDER BY ezcontentobject.published ASC
LIMIT 0, 19

<hr>
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 = '3' AND
                    ezcontentobject_attribute.contentobject_id = '75948' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '75949' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '75950' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '75951' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '75952' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

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

<hr>
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 = '8973' AND
                    ezcontentobject_version.version = '5' AND
                    ezcontentobject_attribute.contentobject_id = '8973' AND                    ezcontentobject_attribute.version = '5' AND                    ezcontentobject_attribute.language_code = 'eng-GB' 
                  
                  ORDER BY
                    ezcontentclass_attribute.placement ASC,
                    ezcontentobject_attribute.language_code ASC

<hr>
SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '8973'
                       AND content_version = '5'
                       AND ( content_translation = 'eng-GB' OR language_id = '3' )

<hr>
SELECT DISTINCT ezuser.contentobject_id, ezuser.login, ezuser.email, ezuser.password_hash, ezuser.password_hash_type
                                       FROM ezcontentobject_version, ezuser where ezcontentobject_version.contentobject_id='75948'
                                       AND ezcontentobject_version.creator_id=ezuser.contentobject_id

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

<hr>
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='249' AND version='0'

<hr>
SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '8021'
                       AND content_version = '5'
                       AND ( content_translation = 'eng-GB' OR language_id = '3' )

<hr>
SELECT DISTINCT ezuser.contentobject_id, ezuser.login, ezuser.email, ezuser.password_hash, ezuser.password_hash_type
                                       FROM ezcontentobject_version, ezuser where ezcontentobject_version.contentobject_id='75949'
                                       AND ezcontentobject_version.creator_id=ezuser.contentobject_id

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

<hr>
SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '8973'
                       AND content_version = '5'
                       AND ( content_translation = 'eng-GB' OR language_id = '3' )

<hr>
SELECT DISTINCT ezuser.contentobject_id, ezuser.login, ezuser.email, ezuser.password_hash, ezuser.password_hash_type
                                       FROM ezcontentobject_version, ezuser where ezcontentobject_version.contentobject_id='75950'
                                       AND ezcontentobject_version.creator_id=ezuser.contentobject_id

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

<hr>
SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '8021'
                       AND content_version = '5'
                       AND ( content_translation = 'eng-GB' OR language_id = '3' )

<hr>
SELECT DISTINCT ezuser.contentobject_id, ezuser.login, ezuser.email, ezuser.password_hash, ezuser.password_hash_type
                                       FROM ezcontentobject_version, ezuser where ezcontentobject_version.contentobject_id='75951'
                                       AND ezcontentobject_version.creator_id=ezuser.contentobject_id

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

<hr>
SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '8973'
                       AND content_version = '5'
                       AND ( content_translation = 'eng-GB' OR language_id = '3' )

<hr>
SELECT DISTINCT ezuser.contentobject_id, ezuser.login, ezuser.email, ezuser.password_hash, ezuser.password_hash_type
                                       FROM ezcontentobject_version, ezuser where ezcontentobject_version.contentobject_id='75952'
                                       AND ezcontentobject_version.creator_id=ezuser.contentobject_id

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222', 'eznode:75851' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222', 'eznode:75851' ) AND is_original = 1 AND is_alias=0

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

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

<hr>
SELECT id, session_id, productcollection_id, order_id
                    FROM   ezbasket WHERE  session_id=''

<hr>
SELECT id, productcollection_id, contentobject_id, item_count, price, is_vat_inc, vat_value,       discount, name
                    FROM   ezproductcollection_item WHERE  productcollection_id='0' ORDER BY contentobject_id DESC

<hr>
SELECT id, section_id, owner_id, contentclass_id, name, 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

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

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

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

<hr>
SELECT
                        count( DISTINCT ezcontentobject_tree.node_id ) as count
                  FROM
                       ezcontentobject_tree
                       INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id)
                       INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id)
                       INNER JOIN ezcontentobject_name ON (
                           ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND
                           ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version
                       )
                       
                       
                       
                  WHERE  ezcontentobject_tree.path_string like '/1/2/63/222/75851/%' and  
                        
                        
                        
                        
                        ezcontentclass.version=0 AND
                        ezcontentobject_tree.node_id != 75851 AND
                        
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 

                        
                         AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) 
                        
                         AND 
 ezcontentobject.language_mask & 3 > 0

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

<hr>
SELECT
                        count( DISTINCT ezcontentobject_tree.node_id ) as count
                  FROM
                       ezcontentobject_tree
                       INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id)
                       INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id)
                       INNER JOIN ezcontentobject_name ON (
                           ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND
                           ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version
                       )
                       
                       
                       
                  WHERE  ezcontentobject_tree.path_string like '/1/2/63/222/75851/%' and  
                        
                        
                          
                        
                        ezcontentclass.version=0 AND
                        ezcontentobject_tree.node_id != 75851 AND
                        
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 

                        
                         AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) 
                        
                         AND 
 ezcontentobject.language_mask & 3 > 0

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222', 'eznode:75851' ) AND is_original = 1 AND is_alias=0

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

<hr>
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 = '5' AND
                    ezcontentobject_attribute.contentobject_id = '54' AND                    ezcontentobject_attribute.version = '5' AND                    ezcontentobject_attribute.language_code = 'eng-GB' 
                  
                  ORDER BY
                    ezcontentclass_attribute.placement ASC,
                    ezcontentobject_attribute.language_code ASC

<hr>
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='174' AND version='0'

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

<hr>
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )     WHERE ezcontentobject_tree.parent_node_id = 2 and         ezcontentobject.contentclass_id  IN  ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2)))   AND 
 ezcontentobject.language_mask & 3 > 0 
  ORDER BY ezcontentobject_tree.priority DESC

<hr>
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
                    ezcontentobject_attribute, ezcontentclass_attribute
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ( ( ezcontentobject_attribute.version = '55' AND
                    ezcontentobject_attribute.contentobject_id = '217' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '118923' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '192' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '5' AND
                    ezcontentobject_attribute.contentobject_id = '88' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '156' AND
                    ezcontentobject_attribute.contentobject_id = '97561' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '7' AND
                    ezcontentobject_attribute.contentobject_id = '63' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '8' AND
                    ezcontentobject_attribute.contentobject_id = '114854' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '6980' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '118478' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

<hr>
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )     WHERE ezcontentobject_tree.parent_node_id = 110423 and         ezcontentobject.contentclass_id  IN  ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2)))   AND 
 ezcontentobject.language_mask & 3 > 0 
  ORDER BY ezcontentobject_tree.priority DESC
LIMIT 0, 14

<hr>
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 = '22' AND
                    ezcontentobject_attribute.contentobject_id = '113536' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '27' AND
                    ezcontentobject_attribute.contentobject_id = '113537' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '4' AND
                    ezcontentobject_attribute.contentobject_id = '113538' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '4' AND
                    ezcontentobject_attribute.contentobject_id = '113539' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '9' AND
                    ezcontentobject_attribute.contentobject_id = '113540' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '5' AND
                    ezcontentobject_attribute.contentobject_id = '113543' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

<hr>
SELECT
                        count( DISTINCT ezcontentobject_tree.node_id ) as count
                  FROM
                       ezcontentobject_tree
                       INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id)
                       INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id)
                       INNER JOIN ezcontentobject_name ON (
                           ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND
                           ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version
                       )
                       
                       
                       
                  WHERE ezcontentobject_tree.parent_node_id = 110423 and
                        
                        
                        
                        
                        ezcontentclass.version=0 AND
                        
                        
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 

                        AND ezcontentobject_tree.is_invisible = 0
                         AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) 
                        
                         AND 
 ezcontentobject.language_mask & 3 > 0

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

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:110423', 'eznode:110425' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:110423', 'eznode:110426' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:110423', 'eznode:110427' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:110423', 'eznode:110428' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:110423', 'eznode:110429' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:110423', 'eznode:110431' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )     WHERE ezcontentobject_tree.parent_node_id = 114049 and         ezcontentobject.contentclass_id  IN  ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2)))   AND 
 ezcontentobject.language_mask & 3 > 0 
  ORDER BY ezcontentobject_tree.priority DESC
LIMIT 0, 14

<hr>
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
                    ezcontentobject_attribute, ezcontentclass_attribute
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ( ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '119003' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '192409' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '191595' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '191598' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '191597' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '176867' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '176865' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '4' AND
                    ezcontentobject_attribute.contentobject_id = '119002' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '192453' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '192413' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '192414' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '89833' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '192374' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '192454' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

<hr>
SELECT
                        count( DISTINCT ezcontentobject_tree.node_id ) as count
                  FROM
                       ezcontentobject_tree
                       INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id)
                       INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id)
                       INNER JOIN ezcontentobject_name ON (
                           ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND
                           ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version
                       )
                       
                       
                       
                  WHERE ezcontentobject_tree.parent_node_id = 114049 and
                        
                        
                        
                        
                        ezcontentclass.version=0 AND
                        
                        
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 

                        AND ezcontentobject_tree.is_invisible = 0
                         AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) 
                        
                         AND 
 ezcontentobject.language_mask & 3 > 0

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7185'

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7195'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114080' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7251'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114208' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7196'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114179' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7197'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114181' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7198'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114180' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7190'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114150' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7199'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114149' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7200'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114079' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7308'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114221' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7255'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114209' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7256'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114210' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:89419' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114196' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7310'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:114049', 'eznode:114222' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )     WHERE ezcontentobject_tree.parent_node_id = 66 and         ezcontentobject.contentclass_id  IN  ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2)))   AND 
 ezcontentobject.language_mask & 3 > 0 
  ORDER BY ezcontentobject_tree.priority DESC
LIMIT 0, 14

<hr>
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
                    ezcontentobject_attribute, ezcontentclass_attribute
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ( ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '118409' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '113154' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '88498' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '118938' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '114821' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '103420' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '86806' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '88622' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '110335' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '98118' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '98121' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '103201' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '103206' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '103211' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

<hr>
SELECT
                        count( DISTINCT ezcontentobject_tree.node_id ) as count
                  FROM
                       ezcontentobject_tree
                       INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id)
                       INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id)
                       INNER JOIN ezcontentobject_name ON (
                           ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND
                           ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version
                       )
                       
                       
                       
                  WHERE ezcontentobject_tree.parent_node_id = 66 and
                        
                        
                        
                        
                        ezcontentclass.version=0 AND
                        
                        
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 

                        AND ezcontentobject_tree.is_invisible = 0
                         AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) 
                        
                         AND 
 ezcontentobject.language_mask & 3 > 0

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

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:113930' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:110086' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:88232' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:114052' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:111486' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:101828' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:86692' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:88330' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:107637' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:96848' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:96850' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:101628' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:101632' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:66', 'eznode:101636' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )     WHERE ezcontentobject_tree.parent_node_id = 63 and         ezcontentobject.contentclass_id  IN  ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2)))   AND 
 ezcontentobject.language_mask & 3 > 0 
  ORDER BY ezcontentobject_tree.priority DESC
LIMIT 0, 14

<hr>
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 = '3' AND
                    ezcontentobject_attribute.contentobject_id = '247' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '245' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '243' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '66' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '242' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '4' AND
                    ezcontentobject_attribute.contentobject_id = '68' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '91826' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '118549' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '118968' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '246' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '93288' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '86790' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '190046' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

<hr>
SELECT
                        count( DISTINCT ezcontentobject_tree.node_id ) as count
                  FROM
                       ezcontentobject_tree
                       INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id)
                       INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id)
                       INNER JOIN ezcontentobject_name ON (
                           ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND
                           ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version
                       )
                       
                       
                       
                  WHERE ezcontentobject_tree.parent_node_id = 63 and
                        
                        
                        
                        
                        ezcontentclass.version=0 AND
                        
                        
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 

                        AND ezcontentobject_tree.is_invisible = 0
                         AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) 
                        
                         AND 
 ezcontentobject.language_mask & 3 > 0

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

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:226' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:224' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:222' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:67' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:221' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:68' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:91174' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:113988' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:114072' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:225' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:92511' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:86676' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:63', 'eznode:114168' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )     WHERE ezcontentobject_tree.parent_node_id = 64 and         ezcontentobject.contentclass_id  IN  ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2)))   AND 
 ezcontentobject.language_mask & 3 > 0 
  ORDER BY ezcontentobject_tree.priority DESC
LIMIT 0, 14

<hr>
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 = '21' AND
                    ezcontentobject_attribute.contentobject_id = '94995' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '4' AND
                    ezcontentobject_attribute.contentobject_id = '226' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '118956' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '118955' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '104227' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '118893' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '118952' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '118954' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '4' AND
                    ezcontentobject_attribute.contentobject_id = '170717' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

<hr>
SELECT
                        count( DISTINCT ezcontentobject_tree.node_id ) as count
                  FROM
                       ezcontentobject_tree
                       INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id)
                       INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id)
                       INNER JOIN ezcontentobject_name ON (
                           ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND
                           ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version
                       )
                       
                       
                       
                  WHERE ezcontentobject_tree.parent_node_id = 64 and
                        
                        
                        
                        
                        ezcontentclass.version=0 AND
                        
                        
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 

                        AND ezcontentobject_tree.is_invisible = 0
                         AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) 
                        
                         AND 
 ezcontentobject.language_mask & 3 > 0

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

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:94016' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:205' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7202'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:114069' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7195'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:114068' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:102515' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:114044' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:114065' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7200'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:114067' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:64', 'eznode:114121' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )     WHERE ezcontentobject_tree.parent_node_id = 111516 and         ezcontentobject.contentclass_id  IN  ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2)))   AND 
 ezcontentobject.language_mask & 3 > 0 
  ORDER BY ezcontentobject_tree.priority DESC
LIMIT 0, 14

<hr>
SELECT
                        count( DISTINCT ezcontentobject_tree.node_id ) as count
                  FROM
                       ezcontentobject_tree
                       INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id)
                       INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id)
                       INNER JOIN ezcontentobject_name ON (
                           ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND
                           ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version
                       )
                       
                       
                       
                  WHERE ezcontentobject_tree.parent_node_id = 111516 and
                        
                        
                        
                        
                        ezcontentclass.version=0 AND
                        
                        
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 

                        AND ezcontentobject_tree.is_invisible = 0
                         AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) 
                        
                         AND 
 ezcontentobject.language_mask & 3 > 0

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

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

<hr>
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )     WHERE ezcontentobject_tree.parent_node_id = 6913 and         ezcontentobject.contentclass_id  IN  ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2)))   AND 
 ezcontentobject.language_mask & 3 > 0 
  ORDER BY ezcontentobject_tree.priority DESC
LIMIT 0, 14

<hr>
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
                    ezcontentobject_attribute, ezcontentclass_attribute
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ( ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '6982' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '21' AND
                    ezcontentobject_attribute.contentobject_id = '118947' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '6981' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '192324' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

<hr>
SELECT
                        count( DISTINCT ezcontentobject_tree.node_id ) as count
                  FROM
                       ezcontentobject_tree
                       INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id)
                       INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id)
                       INNER JOIN ezcontentobject_name ON (
                           ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND
                           ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version
                       )
                       
                       
                       
                  WHERE ezcontentobject_tree.parent_node_id = 6913 and
                        
                        
                        
                        
                        ezcontentclass.version=0 AND
                        
                        
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 

                        AND ezcontentobject_tree.is_invisible = 0
                         AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) 
                        
                         AND 
 ezcontentobject.language_mask & 3 > 0

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

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:6913', 'eznode:6915' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:6913', 'eznode:114060' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:6913', 'eznode:6914' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:6913', 'eznode:114191' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )     WHERE ezcontentobject_tree.parent_node_id = 113961 and         ezcontentobject.contentclass_id  IN  ( 1, 43, 56, 19, 43, 44, 56, 2, 11, 31, 30, 1, 43, 56, 19, 45, 25, 62, 47, 11, 22, 44 ) AND 
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 
 AND ezcontentobject_tree.is_invisible = 0  AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2)))   AND 
 ezcontentobject.language_mask & 3 > 0 
  ORDER BY ezcontentobject_tree.priority DESC
LIMIT 0, 14

<hr>
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 = '118415' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '190602' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '118392' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '118996' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '118496' AND
                    ezcontentobject_attribute.language_code = 'eng-GB' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

<hr>
SELECT
                        count( DISTINCT ezcontentobject_tree.node_id ) as count
                  FROM
                       ezcontentobject_tree
                       INNER JOIN ezcontentobject ON (ezcontentobject.id = ezcontentobject_tree.contentobject_id)
                       INNER JOIN ezcontentclass ON (ezcontentclass.id = ezcontentobject.contentclass_id)
                       INNER JOIN ezcontentobject_name ON (
                           ezcontentobject_name.contentobject_id = ezcontentobject_tree.contentobject_id AND
                           ezcontentobject_name.content_version = ezcontentobject_tree.contentobject_version
                       )
                       
                       
                       
                  WHERE ezcontentobject_tree.parent_node_id = 113961 and
                        
                        
                        
                        
                        ezcontentclass.version=0 AND
                        
                        
 ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
     ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
   + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 2 ) )
 ) 

                        AND ezcontentobject_tree.is_invisible = 0
                         AND ((ezcontentobject.section_id in (1, 11, 8, 9)) OR (ezcontentobject.contentclass_id in (85) AND ezcontentobject.section_id in (12)) OR (ezcontentobject.contentclass_id in (4) AND ezcontentobject.section_id in (2))) 
                        
                         AND 
 ezcontentobject.language_mask & 3 > 0

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

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='7106'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:113961', 'eznode:114176' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='6642'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:113961', 'eznode:113913' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='6842'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:113961', 'eznode:114075' ) AND is_original = 1 AND is_alias=0

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

<hr>
SELECT url, is_valid FROM ezurl WHERE id='6672'

<hr>
SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 3 > 0 ) AND action in ( 'eznode:2', 'eznode:113961', 'eznode:113970' ) AND is_original = 1 AND is_alias=0

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

<hr><!DOCTYPE html>
<html lang="en-GB">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
<style type="text/css">
.limitdisplay-user { display: none; }.limitdisplay-user-10 { display: inline; }.limitdisplay-user-block-10 { display: block; }</style>    
                                      
    <title>How to change the User Register Form to a GET method / Developer / Forums - Share Exponential! The Exponential Community</title>

    <meta property="og:title" content="How to change the User Register Form to a GET method / Developer / Forums - Share Exponential! The Exponential Community">
    <meta name="twitter:title" content="How to change the User Register Form to a GET method / Developer / Forums - Share Exponential! The Exponential Community">
    <meta name="description" content="Share is the gateway to the Exponential Community which powers our Enterprise Content Management System. Share delivers high quality information to help end users of the Exponential CMS.">
    <meta property="og:description" content="Share is the gateway to the Exponential Community which powers our Enterprise Content Management System. Share delivers high quality information to help end users of the Exponential CMS.">
    <meta name="twitter:description" content="Share is the gateway to the Exponential Community which powers our Enterprise Content Management System. Share delivers high quality information to help end users of the Exponential CMS.">
    <meta property="og:type" content="website">
    <meta property="og:url" content="https://share.exponential.se7enx.com/forums/developer/how-to-change-the-user-register-form-to-a-get-method">
    <meta property="og:image" content="https://share.exponential.se7enx.com/extension/sevenx/design/simple/images/favicon-share/favicon-banner.png">
    <meta property="og:site_name" content="Share Exponential! The Exponential Community">
    <meta property="twitter:image" content="https://share.exponential.se7enx.com/extension/sevenx/design/simple/images/favicon-share/favicon-banner.png">    
    

    <meta name="author" content="7x">
    <meta name="copyright" content="7x">
    <meta name="description" content="Share is the gateway to the Exponential Community which powers our Enterprise Content Management System. Share delivers high quality information to help end users of Exponential.">
    <meta name="keywords" content="exponential, Exponential, CMS, ecms, e-commerce, web, application, development, design, cms, training, support, Enterprise, Content, Management, Service">
    <meta name="MSSmartTagsPreventParsing" content="TRUE">
    <meta name="generator" content="Exponential">

<link rel="Home" href="/" title="Share Exponential! The Exponential Community front page">
<link rel="Index" href="/">
<link rel="Top"  href="/" title="How to change the User Register Form to a GET method / Developer / Forums - Share Exponential! The Exponential Community">
<link rel="Search" href="/content/advancedsearch" title="Search Share Exponential! The Exponential Community">
<!-- favicon-share: START -->
<link rel="apple-touch-icon" sizes="57x57" href="/extension/sevenx/design/simple/images/favicon-share/apple-icon-57x57.png">
<link rel="apple-touch-icon" sizes="60x60" href="/extension/sevenx/design/simple/images/favicon-share/apple-icon-60x60.png">
<link rel="apple-touch-icon" sizes="72x72" href="/extension/sevenx/design/simple/images/favicon-share/apple-icon-72x72.png">
<link rel="apple-touch-icon" sizes="76x76" href="/extension/sevenx/design/simple/images/favicon-share/apple-icon-76x76.png">
<link rel="apple-touch-icon" sizes="114x114" href="/extension/sevenx/design/simple/images/favicon-share/apple-icon-114x114.png">
<link rel="apple-touch-icon" sizes="120x120" href="/extension/sevenx/design/simple/images/favicon-share/apple-icon-120x120.png">
<link rel="apple-touch-icon" sizes="144x144" href="/extension/sevenx/design/simple/images/favicon-share/apple-icon-144x144.png">
<link rel="apple-touch-icon" sizes="152x152" href="/extension/sevenx/design/simple/images/favicon-share/apple-icon-152x152.png">
<link rel="apple-touch-icon" sizes="180x180" href="/extension/sevenx/design/simple/images/favicon-share/apple-icon-180x180.png">
<link rel="icon" type="image/png" sizes="32x32" href="/extension/sevenx/design/simple/images/favicon-share/favicon-32x32.png">
<link rel="icon" type="image/png" sizes="16x16" href="/extension/sevenx/design/simple/images/favicon-share/favicon-16x16.png">
<link rel="manifest" href="/extension/sevenx/design/simple/images/favicon-share/site.webmanifest.json">
<link rel="mask-icon" href="/extension/sevenx/design/simple/images/favicon-share/safari-pinned-tab.svg" color="#5bbad5">
<meta name="msapplication-TileColor" content="#9f00a7">
<meta name="theme-color" content="#ffffff">
<!-- favicon-share: END -->


<link rel="Copyright" href="/ezinfo/copyright">
<link rel="Author" href="/ezinfo/about">
<link rel="Alternate" href="/layout/set/print/forums/developer/how-to-change-the-user-register-form-to-a-get-method" media="print" title="Printable version">    <!-- google fonts  -->
    <link rel="preconnect" href="https://fonts.googleapis.com" >
    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin >
    <link
      href="https://fonts.googleapis.com/css2?family=Inter:wght@400;600;700;800;900&display=swap"
      rel="stylesheet"
    >
    
    <!-- custom styles -->
    

        
  <link rel="stylesheet" type="text/css" href="/extension/community/design/community/stylesheets/ext/jquery.autocomplete.css" >
<link rel="stylesheet" type="text/css" href="/extension/community_design/design/suncana/stylesheets/scrollbars.css" >
<link rel="stylesheet" type="text/css" href="/extension/community_design/design/suncana/stylesheets/tabs.css" >
<link rel="stylesheet" type="text/css" href="/extension/community_design/design/suncana/stylesheets/roadmap.css" >
<link rel="stylesheet" type="text/css" href="/extension/community_design/design/suncana/stylesheets/content.css" >
<link rel="stylesheet" type="text/css" href="/extension/community_design/design/suncana/stylesheets/star-rating.css" >
<link rel="stylesheet" type="text/css" href="/extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css" >
<link rel="stylesheet" type="text/css" href="/extension/community_design/design/suncana/stylesheets/buttons.css" >
<link rel="stylesheet" type="text/css" href="/extension/community_design/design/suncana/stylesheets/tweetbox.css" >
<link rel="stylesheet" type="text/css" href="/extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css" >
<link rel="stylesheet" type="text/css" href="/extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css" >
<link rel="stylesheet" type="text/css" href="/extension/sevenx/design/simple/stylesheets/star_rating.css" >
<link rel="stylesheet" type="text/css" href="/extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css" >
<link rel="stylesheet" type="text/css" href="/extension/sevenx/design/simple/stylesheets/main.v02.css" >
<link rel="stylesheet" type="text/css" href="/extension/sevenx/design/simple/stylesheets/main.v02.res.css" >
    




<script type="text/javascript" src="/extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js" charset="utf-8"></script>
<script type="text/javascript">
var YUI3_config = {"base":"\/extension\/ezjscore\/design\/standard\/lib\/yui\/3.17.2\/build\/","combine":false,"modules":{}};
</script>
<script type="text/javascript">

YUI( YUI3_config ).add('io-ez', function( Y )
{
    var _rootUrl = '/', _serverUrl = _rootUrl + 'ezjscore/', _seperator = '@SEPERATOR$', _configBak,
        _prefUrl = _rootUrl + 'user/preferences';

    // (static) Y.io.ez() uses Y.io()
    //
    // @param string callArgs
    // @param object|undefined c Same format as second parameter of Y.io()
    function _ez( callArgs, c )
    {
        callArgs = callArgs.join !== undefined ? callArgs.join( _seperator ) : callArgs;
        var url = _serverUrl + 'call/';

        // Merge configuration object
        if ( c === undefined )
            c = {on:{}, data: '', headers: {}, method: 'POST'};
        else
            c = Y.merge( {on:{}, data: '', headers: {}, method: 'POST'}, c );

        var _token = '', _tokenNode = document.getElementById('ezxform_token_js');
        if ( _tokenNode ) _token = '&ezxform_token=' + _tokenNode.getAttribute('title');

        // Append function arguments as post param if method is POST
        if ( c.method === 'POST' )
            c.data += ( c.data ? '&' : '' ) + 'ezjscServer_function_arguments=' + callArgs + _token;
        else
            url += encodeURIComponent( callArgs );

        // force json transport
        c.headers.Accept = 'application/json,text/javascript,*/*';

        // backup user success call
        if ( c.on.success !== undefined )
            c.on.successCallback = c.on.success;

        c.on.success = _ioezSuccess;
        _configBak = c;

        return Y.io( url, c );
    }

    function _ioezSuccess( id, o )
    {
        if ( o.responseJSON === undefined )
        {
            // create new object to avoid error in ie6 (and do not use Y.merge since it fails in ff)
            var returnObject = {'responseJSON': Y.JSON.parse( o.responseText ),
                                'readyState': o.readyState,
                                'responseText': o.responseText,
                                'responseXML': o.responseXML,
                                'status': o.status,
                                'statusText': o.statusText
            };
        }
        else
        {
            var returnObject = o;
        }

        var c = _configBak;
        if ( c.on.successCallback !== undefined )
        {
            if ( c.arguments !== undefined )
                c.on.successCallback( id, returnObject, c.arguments );
            else
                c.on.successCallback( id, returnObject, null );
        }
        else if ( window.console !== undefined )
        {
            if ( returnObject.responseJSON.error_text )
                window.console.error( 'Y.ez(): ' + returnObject.responseJSON.error_text );
            else
                window.console.log( 'Y.ez(): ' + returnObject.responseJSON.content );
        }
        _configBak.on.success = _configBak.on.successCallback;
        _configBak.on.successCallback = undefined;
    }

    _ez.url = _serverUrl;
    _ez.root_url = _rootUrl;
    _ez.seperator = _seperator;
    Y.io.ez = _ez;
    Y.io.ez.setPreference = function( name, value )
    {
        var c = {on:{}, data:'', headers: {}, method: 'POST'},
            _tokenNode = document.getElementById( 'ezxform_token_js' );

        c.data = 'Function=set_and_exit&Key=' + encodeURIComponent( name ) + '&Value=' + encodeURIComponent( value );
        if ( _tokenNode )
            c.data += '&ezxform_token=' + _tokenNode.getAttribute( 'title' );
        return Y.io( _prefUrl, c );
    }
}, '3.0.0' ,{requires:['io-base', 'json-parse']});
        
</script>
<script type="text/javascript" src="/extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js" charset="utf-8"></script>
<script type="text/javascript">

(function($) {
    var _rootUrl = '/', _serverUrl = _rootUrl + 'ezjscore/', _seperator = '@SEPERATOR$',
        _prefUrl = _rootUrl + 'user/preferences';

    // FIX: Ajax is broken on IE8 / IE7 on jQuery 1.4.x as it's trying to use the broken window.XMLHttpRequest object
    if ( window.XMLHttpRequest && window.ActiveXObject )
        $.ajaxSettings.xhr = function() { try { return new window.ActiveXObject('Microsoft.XMLHTTP'); } catch(e) {} };

    // (static) jQuery.ez() uses jQuery.post() (Or jQuery.get() if post paramer is false)
    //
    // @param string callArgs
    // @param object|array|string|false post Optional post values, uses get request if false or undefined
    // @param function Optional callBack
    function _ez( callArgs, post, callBack )
    {
        callArgs = callArgs.join !== undefined ? callArgs.join( _seperator ) : callArgs;
        var url = _serverUrl + 'call/';
        if ( post )
        {
            var _token = '', _tokenNode = document.getElementById('ezxform_token_js');
            if ( _tokenNode ) _token = _tokenNode.getAttribute('title');
            if ( post.join !== undefined )// support serializeArray() format
            {
                post.push( { 'name': 'ezjscServer_function_arguments', 'value': callArgs } );
                post.push( { 'name': 'ezxform_token', 'value': _token } );
            }
            else if ( typeof(post) === 'string' )// string
            {
                post += ( post ? '&' : '' ) + 'ezjscServer_function_arguments=' + callArgs + '&ezxform_token=' + _token;
            }
            else // object
            {
                post['ezjscServer_function_arguments'] = callArgs;
                post['ezxform_token'] = _token;
            }
            return $.post( url, post, callBack, 'json' );
        }
        return $.get( url + encodeURIComponent( callArgs ), {}, callBack, 'json' );
    };
    _ez.url = _serverUrl;
    _ez.root_url = _rootUrl;
    _ez.seperator = _seperator;
    $.ez = _ez;

    $.ez.setPreference = function( name, value )
    {
        var param = {'Function': 'set_and_exit', 'Key': name, 'Value': value};
            _tokenNode = document.getElementById( 'ezxform_token_js' );
        if ( _tokenNode )
            param.ezxform_token = _tokenNode.getAttribute( 'title' );

        return $.post( _prefUrl, param );
    };

    // Method version, for loading response into elements
    // NB: Does not use json (not possible with .load), so ezjscore/call will return string
    function _ezLoad( callArgs, post, selector, callBack )
    {
        callArgs = callArgs.join !== undefined ? callArgs.join( _seperator ) : callArgs;
        var url = _serverUrl + 'call/';
        if ( post )
        {
            post['ezjscServer_function_arguments'] = callArgs;
            post['ezxform_token'] = jQuery('#ezxform_token_js').attr('title');
        }
        else
            url += encodeURIComponent( callArgs );

        return this.load( url + ( selector ? ' ' + selector : '' ), post, callBack );
    };
    $.fn.ez = _ezLoad;
})(jQuery);
        
</script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/jquery.ui.core.min.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/jquery.easing.1.3.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/jquery.ui.tabs.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/jquery.popmenu.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/jScrollPane.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/jquery.mousewheel.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/jquery.cycle.all.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/sevenx/design/simple/javascript/jquery.scrollTo.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/jquery.cookie.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/ezstarrating_jquery.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/jquery.initboxes.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/app.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/twitterwidget.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/community.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/roadmap.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/ez.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/community_design/design/suncana/javascript/ezshareevents.js" charset="utf-8"></script>
<script type="text/javascript" src="/extension/sevenx/design/simple/javascript/main.js" charset="utf-8"></script>








</head>

<!--[if lt IE 7 ]><body class="ie6"><![endif]-->
<!--[if IE 7 ]>   <body class="ie7"><![endif]-->
<!--[if IE 8 ]>   <body class="ie8"><![endif]-->
<!--[if (gt IE 8)|!(IE)]><!--><body><!--<![endif]-->

  <!-- Header area: START -->
    
  <!-- Header area: START -->
  <header id="headerMain" class="header-main">
    
    <nav class="navbar-main">
        <div class="container">
            <a href="/" title="Share Exponential! The Exponential Community" class="navbar-brand">
                                    <img src="/var/site/storage/images/design/share-ez-no/172-5-eng-GB/share-ez-no.webp" alt="" width="640" height="203" />
                            </a>
            <button type="button" class="navbar-toggle" data-collapse-menu="#navbarCollapse" aria-label="Menu Icon">
                <span></span>
                <span></span>
                <span></span>
            </button>
            <div id="navbarCollapse" class="navbar-collapse">
                
                
<h2 class="navbar-title">Menu</h2>
<ul class="navbar-nav"><li class="dropdown">
  <div class="dropdown-button">
    <a href="https://share.exponential.earth/get-involved" role="button">Get involved</a>
            <button type="button" class="dropdown-toggle" aria-label="dropdown toggler button"></button>

  </div>
<div class="dropdown-menu">
<div>
<ul class="dropdown-nav">
  
       <li>
<a
href="https://share.exponential.earth/get-involved/develop" class="dropdown-link firstli">Develop</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/get-involved/exchange" class="dropdown-link">Exchange</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/get-involved/learn-teach" class="dropdown-link">Learn &amp; Teach</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/get-involved/localize" class="dropdown-link">Localize</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/get-involved/spread-the-word" class="dropdown-link">Spread the word</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/get-involved/infrastructure" class="dropdown-link">Infrastructure</a>
</li></ul>
 </div>
</div>
</li>
 <li class="dropdown">
  <div class="dropdown-button">
    <a href="https://exponential.earth" role="button">Project</a>
            <button type="button" class="dropdown-toggle" aria-label="dropdown toggler button"></button>

  </div>
<div class="dropdown-menu">
<div>
<ul class="dropdown-nav">
  
       <li id="node_id_114080">
<a href="https://exponential.doc.exponential.earth" title="Documentation"
 role="button" class="dropdown-link firstli" rel=project/documentation>Documentation</a>
  </li>  
    <li id="node_id_114208">
<a href="https://projects.exponential.earth" title="Exponential Projects (Extensions)"
 role="button" class="dropdown-link" rel=project/exponential-projects-extensions>Exponential Projects (Extensions)</a>
  </li>  
    <li id="node_id_114179">
<a href="https://github.com/se7enxweb/exponential/pulls" title="Pull Requests for Exponential"
 role="button" class="dropdown-link" rel=project/pull-requests-for-exponential>Pull Requests for Exponential</a>
  </li>  
    <li id="node_id_114181">
<a href="https://sourceforge.net/projects/exponential/files/latest/download" title="Exponential Download @ SourceForge"
 role="button" class="dropdown-link" rel=project/exponential-download-from-sourceforge>Exponential Download @ SourceForge</a>
  </li>  
    <li id="node_id_114180">
<a href="https://github.com/se7enxweb/exponential/releases" title="Exponential Download @ GitHub"
 role="button" class="dropdown-link" rel=project/exponential-download-from-github>Exponential Download @ GitHub</a>
  </li>  
    <li id="node_id_114150">
<a href="https://github.com/se7enxweb/exponential" title="GitHub Project"
 role="button" class="dropdown-link" rel=project/github-project>GitHub Project</a>
  </li>  
    <li id="node_id_114149">
<a href="https://issues.exponential.earth" title="Issue Tracker"
 role="button" class="dropdown-link" rel=project/issue-tracker>Issue Tracker</a>
  </li>  
    <li id="node_id_114079">
<a href="https://ezpedia.exponential.earth" title="Wiki Documentation"
 role="button" class="dropdown-link" rel=project/wiki-documentation>Wiki Documentation</a>
  </li>  
       <li id="node_id_114221">
<a href="https://discord.gg/jfVxT9x2" title="Exponential Community @ Discord"
 role="button" class="dropdown-link lastli" rel=project/exponential-community-discord>Exponential Community @ Discord</a>
  </li>  
    <li id="node_id_114209">
<a href="https://platform.exponential.earth" title="Exponential Platform"
 role="button" class="dropdown-link" rel=project/exponential-platform>Exponential Platform</a>
  </li>  
    <li id="node_id_114210">
<a href="https://basic.exponential.earth" title="Exponential Basic"
 role="button" class="dropdown-link" rel=project/exponential-basic>Exponential Basic</a>
  </li>  
    <li>
<a
href="https://share.exponential.earth/project/team" class="dropdown-link">Team</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/project/open-funding" class="dropdown-link">Open Funding</a>
</li>  
    <li id="node_id_114222">
<a href="https://www.linkedin.com/groups/14819081/" title="Exponential Group @ LinkedIn"
 role="button" class="dropdown-link" rel=project/exponential-group-linkedin>Exponential Group @ LinkedIn</a>
  </li></ul>
 </div>
</div>
</li>
 <li class="dropdown">
  <div class="dropdown-button">
    <a href="https://share.exponential.earth/blogs" role="button">Blogs</a>
            <button type="button" class="dropdown-toggle" aria-label="dropdown toggler button"></button>

  </div>
<div class="dropdown-menu">
<div>
<ul class="dropdown-nav">
  
       <li>
<a
href="https://share.exponential.earth/blogs/7x" class="dropdown-link firstli">7x</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/blogs/brookins-consulting" class="dropdown-link">Brookins Consulting</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/blogs/share.ezpublish.one-team" class="dropdown-link">share.ezpublish.one team</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/blogs/vincent-opar" class="dropdown-link">Vincent Opar</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/blogs/brandon-chambers" class="dropdown-link">Brandon Chambers</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/blogs/steven-e.-bailey" class="dropdown-link">Steven E. Bailey</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/blogs/ez" class="dropdown-link">eZ</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/blogs/community-changelog" class="dropdown-link">Community Changelog</a>
</li>  
       <li>
<a
href="https://share.exponential.earth/blogs/community-project-board" class="dropdown-link lastli">Community Project Board</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/blogs/bertrand-maugain" class="dropdown-link">Bertrand Maugain</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/blogs/matthieu-severe" class="dropdown-link">Matthieu Sévère</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/blogs/jerome-vieilledent" class="dropdown-link">Jérôme Vieilledent</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/blogs/damien-martin" class="dropdown-link">Damien MARTIN</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/blogs/abdelkader-rhouati" class="dropdown-link">Abdelkader RHOUATI</a>
</li></ul>
 </div>
</div>
</li>
 <li class="dropdown">
  <div class="dropdown-button">
    <a href="https://share.exponential.earth/forums" role="button">Forums</a>
            <button type="button" class="dropdown-toggle" aria-label="dropdown toggler button"></button>

  </div>
<div class="dropdown-menu">
<div>
<ul class="dropdown-nav">
  
       <li>
<a
href="https://share.exponential.earth/forums/general" class="dropdown-link firstli">General</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/forums/extensions" class="dropdown-link">Extensions</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/forums/developer" class="dropdown-link">Developer</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/forums/install-configuration" class="dropdown-link">Install &amp; configuration</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/forums/setup-design" class="dropdown-link">Setup &amp; design</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/forums/discussions" class="dropdown-link">Discussions</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/forums/translation" class="dropdown-link">Translation</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/forums/exponential-platform" class="dropdown-link">Exponential Platform</a>
</li>  
       <li>
<a
href="https://share.exponential.earth/forums/exponential-basic" class="dropdown-link lastli">Exponential Basic</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/forums/suggestions" class="dropdown-link">Suggestions</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/forums/localized-forums" class="dropdown-link">Localized forums</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/forums/feedback-and-ideas-for-this-portal" class="dropdown-link">Feedback and ideas for this portal </a>
</li>  
    <li>
<a
href="https://share.exponential.earth/forums/forum-statistics" class="dropdown-link">Forum Statistics</a>
</li></ul>
 </div>
</div>
</li>
 <li class="dropdown">
  <div class="dropdown-button">
    <a href="https://share.exponential.earth/learn" role="button">Learn</a>
            <button type="button" class="dropdown-toggle" aria-label="dropdown toggler button"></button>

  </div>
<div class="dropdown-menu">
<div>
<ul class="dropdown-nav">
  
       <li>
<a
href="https://share.exponential.earth/learn/write-a-tutorial" class="dropdown-link firstli">Write a tutorial!</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/learn/exponential" class="dropdown-link">Exponential</a>
</li>  
    <li id="node_id_114069">
<a href="https://exponential.earth/book" title="Books"
 role="button" class="dropdown-link" rel=learn/books>Books</a>
  </li>  
    <li id="node_id_114068">
<a href="https://exponential.doc.exponential.earth" title="Exponential 6 Documentation"
 role="button" class="dropdown-link" rel=learn/exponential-6-documentation>Exponential 6 Documentation</a>
  </li>  
    <li>
<a
href="https://share.exponential.earth/learn/zeta-components" class="dropdown-link">Zeta Components</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/learn/exponential-code-standards" class="dropdown-link">Exponential Code Standards</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/learn/exponential-platform" class="dropdown-link">Exponential Platform</a>
</li>  
    <li id="node_id_114067">
<a href="https://ezpedia.exponential.earth" title="eZpedia : eZ Documentation Wiki"
 role="button" class="dropdown-link" rel=learn/ezpedia-ez-documentation-wiki>eZpedia : eZ Documentation Wiki</a>
  </li>  
       <li>
<a
href="https://share.exponential.earth/learn/exponential-basic" class="dropdown-link lastli">Exponential Basic</a>
</li></ul>
 </div>
</div>
</li>
 
<li class="dropdown">
  <a role="button" href="https://share.exponential.earth/roadmap"  class="nav-link" >Roadmap</a>
<li class="dropdown">
  <div class="dropdown-button">
    <a href="https://share.exponential.earth/directory" role="button">Directory</a>
            <button type="button" class="dropdown-toggle" aria-label="dropdown toggler button"></button>

  </div>
<div class="dropdown-menu">
<div>
<ul class="dropdown-nav">
  
       <li>
<a
href="https://share.exponential.earth/directory/companies" class="dropdown-link firstli">Companies</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/directory/community-program-2025" class="dropdown-link">Community Program - 2025</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/directory/people" class="dropdown-link">People</a>
</li>  
    <li>
<a
href="https://share.exponential.earth/directory/companies-ez-5-era" class="dropdown-link">Companies (eZ 5 Era)</a>
</li></ul>
 </div>
</div>
</li>
 <li class="dropdown">
  <div class="dropdown-button">
    <a href="https://share.exponential.earth/profile" role="button"><i class="fa-solid fa-gears"></i></i></a>
        <button type="button" class="dropdown-toggle" aria-label="dropdown toggler button"></button>

  </div>
<div class="dropdown-menu">
<div>
<ul class="dropdown-nav">
  
       <li class="dropdown" id="node_id_113935">
<a 
  href="/user/login"      title="Login"
  class="dropdown-link firstli"  rel=Login>Login</a>
  <a class="dropdown-link firstli" href="/user/register">Sign-Up</a>
  </li>  
    <li id="node_id_114176">
<a href="https://share.ezpublish.one/content/view/sitemap/2" title="Sitemap"
 role="button" class="dropdown-link" rel=profile/sitemap>Sitemap</a>
  </li>  
    <li id="node_id_113913">
<a href="/content/search" title="Search"
 role="button" class="dropdown-link" rel=profile/search>Search</a>
  </li>  
    <li id="node_id_114075">
<a href="/content/view/tagcloud/2" title="Tag Cloud"
 role="button" class="dropdown-link" rel=profile/tagcloud>Tag Cloud</a>
  </li>  
    <li id="node_id_113970">
<a href="https://share.se7enx.com/content/new" title="New Content"
 role="button" class="dropdown-link" rel=profile/new-content>New Content</a>
  </li></ul>
 </div>
</div>
</li>
    </ul>


            </div>
            
    </nav>
  </header>
  <!-- Header area: END -->  <!-- Header area: END -->

<script>
<!--
    var ezpRoot = "";
    var ezpFilesRoot = "";
    var ezpCurrentURL = "/forums/developer/how-to-change-the-user-register-form-to-a-get-method";
    var ezpReturnURL = "https://share.exponential.se7enx.com/forums/developer/how-to-change-the-user-register-form-to-a-get-method";
// -->
</script>

    <!-- main starts -->
  <main class="main-sections">
    <!-- Complete page area: START -->

<!-- Change between "sidemenu"/"nosidemenu" and "extrainfo"/"noextrainfo" to switch display of side columns on or off  -->


  
  
  

 

   

  <!-- Columns area: START -->
  

    

  
    <div class="container">
                                                                                                                                                                                                                                
        <!-- Path area: START -->
        <div id="path">
      <!-- Path content: START -->
    <p>
        <a href="/forums">Forums</a>
      <span class="path-separator">/</span>      <a href="/forums/developer">Developer</a>
      <span class="path-separator">/</span>      <span class="path-text">How to change the User Register Form to a GET method</span>
        </p>
    <!-- Path content: END -->
        </div>
        <!-- Path area: END -->

	<!-- Disclaimer: START -->
	<div id="path" style="padding-bottom: 0.252rem; padding-top: 0.55rem;">"<u>Please Note</u>:
          <ul><li><b>At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.</b></li>
            <li><b>This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa</b>".</li>
          </ul>
        </div>
	<!-- Disclaimer: END -->


    <!-- Main area: START -->
    
          <!-- Main area content: START -->
          

<div class="border-box">
    <div class="border-tl">
        <div class="border-tr">
            <div class="border-tc"></div>
        </div>
    </div>
    <div class="border-ml">
        <div class="border-mr">
            <div class="border-mc float-break">

                <div class="content-view-full">
                    <div class="class-forum-topic">

                        <div class="attribute-header">
                            <h1>How to change the User Register Form to a GET method</h1>
                        </div>

                                                    <div class="content-navigator">
                                                                    <div class="content-navigator-previous">
                                        <div class="content-navigator-arrow">&laquo;&nbsp;</div><a
                                            href="/forums/developer/display-first-100-chars"
                                            title="Display first 100 chars">Previous topic</a>
                                    </div>
                                    
                                                                            <div class="content-navigator-separator">|</div>
                                        
                                                                                <div class="content-navigator-forum-link"><a
                                                href="/forums/developer">Developer</a></div>
                                        
                                                                                    <div class="content-navigator-separator">|</div>
                                            
                                                                                            <div class="content-navigator-next">
                                                    <a href="/forums/developer/can-not-determin-the-name-for-the-custom-tag"
                                                        title="Can not determin the name for the custom tag">Next topic</a>
                                                    <div class="content-navigator-arrow">&nbsp;&raquo;</div>
                                                </div>
                                                                                            </div>

                                                                                    
                                        <div class="overflow-wrap">
                                            <table class="list forum" cellspacing="0">
                                                <tr>
                                                    <th class="author">
                                                        Author
                                                    </th>
                                                    <th class="message">
                                                        Message
                                                    </th>
                                                </tr>
                                                                                                    <tr class="bglight">
                                                        <td class="author">
                                                                                                                        <p class="author"><a
                                                                    href="/community/profile/8021">Luc Chase</a>
                                                                                                                            </p>
                                                            
                                                                                                                        <p>
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    </p>

                                                                                                                        
                                                        </td>
                                                        <td class="message">
                                                            <p class="date">Thursday 05 October 2006 2:33:52 am</p>
                                                            <p>
                                                                
                                                                <p>
I need to temporarly allow the user register form to work using the GET method. But when I change the method in the template, although I can now see the variables in the URL string, it does not actually register the new user. Is there a setting or a line of code I can alter to temporarily allow the GET method?<br />&lt;b&gt;This is for a semi-automated bulk data import from a spreadsheet.&lt;/b&gt; Would create new records with just two mouse clicks per record.</p>                                                            </p>
                                                                                                                            <p class="author-signature">The Web Application Service Provider
                                                                </p>
                                                                                                                    </td>
                                                                                                            </tr>
                                                
                                                                                                                                                        <tr class="bgdark">
                                                        <td class="author">
                                                                                                                        <p class="author"><a
                                                                    href="/community/profile/8973">Łukasz Serwatka</a>
                                                                                                                            </p>

                                                                                                                            <div class="authorimage">
                                                                    
    
        
    
    <a href="/community/profile/8973">            <img src="/var/community/storage/images/users/registered-users/lukasz-serwatka2/79060-2-eng-GB/lukasz-serwatka_small.jpg" width="64" height="64"  style="border: 0px;" alt="" title="" /></a>    
    
    
                                                                    </div>
                                                            
                                                            
                                                                                                                          							                                                                      							                                                                                                                                
                                                                                                                                                                                    

                                                        </td>
                                                        <td class="message">
                                                            <p class="date">Thursday 05 October 2006 2:51:58 am</p>

                                                            <a name="msg75852"></a>
                                                            <p>
                                                                <p>This is not possible with current /user/register module. You will need to hack it (not recommend) or write new one.</p><p>However you can use {$view_parameters.var} and pass some values via url.</p>                                                            </p>

                                                                                                                            <p class="author-signature">Personal website -&gt; <a href="http://serwatka.net" title="http://serwatka.net">http://serwatka.net</a><br />
Blog (about eZ Publish) -&gt; <a href="http://serwatka.net/blog" title="http://serwatka.net/blog">http://serwatka.net/blog</a>
                                                                </p>
                                                                                                                                                                                </td>
                                                    </tr>
                                                                                                    <tr class="bglight">
                                                        <td class="author">
                                                                                                                        <p class="author"><a
                                                                    href="/community/profile/8021">Luc Chase</a>
                                                                                                                            </p>

                                                            
                                                            
                                                                                                                          							                                                                      							                                                                                                                                
                                                                                                                                                                                    

                                                        </td>
                                                        <td class="message">
                                                            <p class="date">Thursday 05 October 2006 3:25:20 am</p>

                                                            <a name="msg75853"></a>
                                                            <p>
                                                                <p>
That sounds like it would help as the fields would be populated with the appropriate value and I would then just need to click the submit button. Also the sequence ID for UserID would be correct each time. But can I somehow use {$view_parameters.var} as the default value in my class definition? <br />
The default template loops through the class attributes ( using attribute_edit_gui) picking up their properties, including default values on the way.<br />
Or maybe in can insert {$view_parameters.var} into the template used by attribute_edit_gui ? Which template is that?<br />Or would it probably be easier to just construct an override template using it? </p>                                                            </p>

                                                                                                                            <p class="author-signature">The Web Application Service Provider
                                                                </p>
                                                                                                                                                                                </td>
                                                    </tr>
                                                                                                    <tr class="bgdark">
                                                        <td class="author">
                                                                                                                        <p class="author"><a
                                                                    href="/community/profile/8973">Łukasz Serwatka</a>
                                                                                                                            </p>

                                                                                                                            <div class="authorimage">
                                                                    
    
        
    
    <a href="/community/profile/8973">            <img src="/var/community/storage/images/users/registered-users/lukasz-serwatka2/79060-2-eng-GB/lukasz-serwatka_small.jpg" width="64" height="64"  style="border: 0px;" alt="" title="" /></a>    
    
    
                                                                    </div>
                                                            
                                                            
                                                                                                                          							                                                                      							                                                                                                                                
                                                                                                                                                                                    

                                                        </td>
                                                        <td class="message">
                                                            <p class="date">Thursday 05 October 2006 3:57:00 am</p>

                                                            <a name="msg75854"></a>
                                                            <p>
                                                                        <pre>
Or would it probably be easier to just construct an override template using it?
</pre>
    <p>Yes, that is the best option. Then you will have full control on the ouput and content class attributes, using edit_view_gui you can display only needed fields rest hide with hidden fields for example.</p>                                                            </p>

                                                                                                                            <p class="author-signature">Personal website -&gt; <a href="http://serwatka.net" title="http://serwatka.net">http://serwatka.net</a><br />
Blog (about eZ Publish) -&gt; <a href="http://serwatka.net/blog" title="http://serwatka.net/blog">http://serwatka.net/blog</a>
                                                                </p>
                                                                                                                                                                                </td>
                                                    </tr>
                                                                                                    <tr class="bglight">
                                                        <td class="author">
                                                                                                                        <p class="author"><a
                                                                    href="/community/profile/8021">Luc Chase</a>
                                                                                                                            </p>

                                                            
                                                            
                                                                                                                          							                                                                      							                                                                                                                                
                                                                                                                                                                                    

                                                        </td>
                                                        <td class="message">
                                                            <p class="date">Thursday 05 October 2006 4:35:09 am</p>

                                                            <a name="msg75855"></a>
                                                            <p>
                                                                <p>Working! Thanks very much!</p>                                                            </p>

                                                                                                                            <p class="author-signature">The Web Application Service Provider
                                                                </p>
                                                                                                                                                                                </td>
                                                    </tr>
                                                                                                    <tr class="bgdark">
                                                        <td class="author">
                                                                                                                        <p class="author"><a
                                                                    href="/community/profile/8973">Łukasz Serwatka</a>
                                                                                                                            </p>

                                                                                                                            <div class="authorimage">
                                                                    
    
        
    
    <a href="/community/profile/8973">            <img src="/var/community/storage/images/users/registered-users/lukasz-serwatka2/79060-2-eng-GB/lukasz-serwatka_small.jpg" width="64" height="64"  style="border: 0px;" alt="" title="" /></a>    
    
    
                                                                    </div>
                                                            
                                                            
                                                                                                                          							                                                                      							                                                                                                                                
                                                                                                                                                                                    

                                                        </td>
                                                        <td class="message">
                                                            <p class="date">Thursday 05 October 2006 5:08:10 am</p>

                                                            <a name="msg75856"></a>
                                                            <p>
                                                                <p>Great! You are welcome, Luc ;)</p>                                                            </p>

                                                                                                                            <p class="author-signature">Personal website -&gt; <a href="http://serwatka.net" title="http://serwatka.net">http://serwatka.net</a><br />
Blog (about eZ Publish) -&gt; <a href="http://serwatka.net/blog" title="http://serwatka.net/blog">http://serwatka.net/blog</a>
                                                                </p>
                                                                                                                                                                                </td>
                                                    </tr>
                                                                                                                                    </table>
                                    </div>


                                      

<div class="pagination  float-break">	
</div> <!-- <div class="pagination float-break"> -->

 
                                </div>
                            </div>

                        </div>
                    </div>
                </div>
                <div class="border-bl">
                    <div class="border-br">
                        <div class="border-bc"></div>
                    </div>
                </div>
            </div>
            
    </div>
    <!-- Main area content: END -->
    <!-- Main area: END -->
  </main>
    <!-- main ends -->
    
    


  <!-- Columns area: END -->

  <!-- Footer area: START -->
   <footer class="footer-main">
    <div class="container">
      <div class="copyright-text">
        
        Copyright &#169; 1998 - 2025 <a href="https://se7enx.com">7x</a>. All rights reserved except where otherwise noted.
       </div>

        <div class="content-view-full">
          <div class="class-folder">
            <div class="content-view-embed social-view-embed">
              <div class="class-image">
                <div class="attribute-image-powered-by">
                  <a href="https://exponential.earth"><img src="https://exponential.earth/var/site/storage/images/media/images/powered-by-banners/powered-by-logo-exponential-png/1072750-1-eng-US/powered-by-logo-exponential-png_large.png" width="339" height="106" style="height: 3rem; width: 10rem; margin-top: 0.21rem; border: 0px;" alt="" title=""></a>
                </div>
              </div>
             </div>
           </div>

      <div class="poweredby-text">
        Powered by <a href="/ezinfo/about" title="Exponential CMS Open Source Web Content Management">Exponential</a> CMS Open Source Web Content Management
      </div>


        <div class="social-footer-toolbar">
           <div class="social-footer-toolbar-item">
               <a href="https://x.com/se7enxweb" title="x.com" class="bg-orange-500 text-white text-lg w-10 h-10 rounded-full inline-flex items-center justify-center transition-all duration-300 hover:bg-orange-600 hover:scale-110"><i class="fa-brands fa-x-twitter fa-2xl"></i></a>
           </div>
           <div class="social-footer-toolbar-item">
               <a href="https://instagram.com/se7enxweb" title="instagram.com" class="bg-orange-500 text-white text-lg w-10 h-10 rounded-full inline-flex items-center justify-center transition-all duration-300 hover:bg-orange-600 hover:scale-110"><i class="fa-brands fa-instagram fa-2xl"></i></a>
           </div>
           <div class="social-footer-toolbar-item">
               <a href="https://www.facebook.com/people/7x/61559920663779/" title="facebook.com" class="bg-orange-500 text-white text-lg w-10 h-10 rounded-full inline-flex items-center justify-center transition-all duration-300 hover:bg-orange-600 hover:scale-110"><i class="fa-brands fa-facebook fa-2xl"></i></a>
           </div>
          <div class="social-footer-toolbar-item">
            <a href="https://github.com/sponsors/se7enxweb" title="github.com/sponsors/se7enxweb" class="bg-orange-500 text-white text-lg w-10 h-10 rounded-full inline-flex items-center justify-center transition-all duration-300 hover:bg-orange-600 hover:scale-110" target="_blank">
              <i class="fa-brands fa-github fa-2xl" style="color: #ffffff;"></i>
            </a>
          </div>
          <div class="social-footer-toolbar-item">
            <a href="https://patreon.com/7xweb" title="patreon.com/7xweb" class="bg-orange-500 text-white text-lg w-10 h-10 rounded-full inline-flex items-center justify-center transition-all duration-300 hover:bg-orange-600 hover:scale-110" target="_blank">
              <i class="fa-brands fa-patreon" style="color: #ffffff;"></i>
            </a>
          </div>
          <div class="social-footer-toolbar-item">
            <a href="https://paypal.me/7xweb" title="paypal.me/7xweb" class="bg-orange-500 text-white text-lg w-10 h-10 rounded-full inline-flex items-center justify-center transition-all duration-300 hover:bg-orange-600 hover:scale-110" target="_blank">
              <i class="fa-brands fa-paypal" style="color: #ffffff;"></i>
            </a>
          </div>
          <div class="social-footer-toolbar-item">
            <a href="https://www.paypal.com/donate/?hosted_button_id=PD8N8357F87NS" title="paypal.com/donate/7xweb" class="bg-orange-500 text-white text-lg w-10 h-10 rounded-full inline-flex items-center justify-center transition-all duration-300 hover:bg-orange-600 hover:scale-110" target="_blank">
              <i class="fa-brands fa-paypal" style="color: #ffffff;"></i>
            </a>
          </div>
        </div>
        <br />
        <div class="social-footer-toolbar">
           <div class="social-footer-toolbar-item">
            <a href="https://github.com/se7enxweb" title="github.com/se7enxweb" class="bg-orange-500 text-white text-lg w-10 h-10 rounded-full inline-flex items-center justify-center transition-all duration-300 hover:bg-orange-600 hover:scale-110" target="_blank">
              <i class="fa-brands fa-github" style="color: #ffffff;"></i>
            </a>
          </div>
           <div class="social-footer-toolbar-item" >
            <a href="https://gitlab.com/se7enx" title="gitlab.com/se7enx" class="bg-orange-500 text-white text-lg w-10 h-10 rounded-full inline-flex items-center justify-center transition-all duration-300 hover:bg-orange-600 hover:scale-110" target="_blank">
              <i class="fa-brands fa-gitlab" style="color: #ffffff;"></i>
            </a>
          </div>
          <div class="social-footer-toolbar-item" >
            <a href="https://youtube.com/@ExponentialCMSInsights" title="youtube.com/@ExponentialCMSInsights" class="bg-orange-500 text-white text-lg w-10 h-10 rounded-full inline-flex items-center justify-center transition-all duration-300 hover:bg-orange-600 hover:scale-110" target="_blank">
              <i class="fa-brands fa-youtube" style="color: #ffffff;"></i>
            </a>
          </div>
          <div class="social-footer-toolbar-item" >
            <a href="https://t.me/exponentialcms" title="Share Exponential! Telegram Group : Community Support" class="bg-orange-500 text-white text-lg w-10 h-10 rounded-full inline-flex items-center justify-center transition-all duration-300 hover:bg-orange-600 hover:scale-110">
              <i class="fa-brands fa-telegram" style="color: #ffffff;"></i>
            </a>
          </div>

          <div class="social-footer-toolbar-item">
            <a href="https://share.exponential.earth/content/view/tagcloud/2" title="Tag Cloud" class="bg-orange-500 text-white text-lg w-10 h-10 rounded-full inline-flex items-center justify-center transition-all duration-300 hover:bg-orange-600 hover:scale-110">
              <i class="fa fa-cloud" style="color: #ffffff;"></i>
            </a>
          </div>
          <div class="social-footer-toolbar-item">
            <a href="https://share.exponential.earth/content/view/sitemap/2" title="Website Sitemap" class="bg-orange-500 text-white text-lg w-10 h-10 rounded-full inline-flex items-center justify-center transition-all duration-300 hover:bg-orange-600 hover:scale-110">
              <i class="fa fa-sitemap" style="color: #ffffff;"></i>
            </a>
          </div>
          <div class="social-footer-toolbar-item">
            <a href="/content/search" title="Website Search" class="bg-orange-500 text-white text-lg w-10 h-10 rounded-full inline-flex items-center justify-center transition-all duration-300 hover:bg-orange-600 hover:scale-110">
              <i class="fas fa-search" style="color: #ffffff;"></i>
            </a>
          </div>
        </div>

        <div class="hosting-sponsor">
          Proudly hosted by
          <br />
          <a href="http://se7enx.com" title="se7enx.com">se7enx.com</a>
          <br />
          <a href="https://se7enx.com" class="footer-logo">
            <img src="/extension/sevenx/design/simple/images/bc-icon.png" alt="Se7enx" border="0" width="65" height="65" style="position:relative;top:3px;padding-right:1px;" />
          </a>
        </div>
    </div>
</footer>
   

    <!-- scroll to top starts -->
    <div class="scroll-to-top-box fixed left-0 bottom-8 xl:bottom-12 w-full pointer-events-none">
      <div class="scroll-to-top-container lg:container mx-auto relative">
        <button
          type="button"
          id="scroll-to-top"
          class="scroll-to-top inline-flex items-center justify-center border border-solid border-orange-500 bg-orange-500 text-base text-white font-medium p-2 transition duration-500 hover:bg-orange-600 hover:text-white w-10 h-10 absolute bottom-0 right-4 z-30 pointer-events-auto"
        >
          <i class="fa-solid fa-arrow-up-long"></i>
        </button>
      </div>
    </div>
    <!-- scroll to top ends -->

    <!-- Google tag (gtag.js) -->
    
<script async src="https://www.googletagmanager.com/gtag/js?id=G-WQ2B33YTFD"></script><script type="text/javascript" language="Javascript">  window.dataLayer = window.dataLayer || [];  function gtag(){dataLayer.push(arguments);}  gtag('js', new Date());  gtag('config', 'G-WQ2B33YTFD', { cookie_flags: 'SameSite=None;Secure' } );</script>
  <!-- Footer area: END -->    
    
  </body>
</html>