600A - Old Reynella Interchange / Marion Centre Interchange to Aberfoyle Hub

Script start

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.action AS e1_action, e1.alias_redirects AS e1_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1 WHERE e0.parent = 0 AND (e0.lang_mask & 9 > 0) AND e0.text_md5 =  MD5( 'routes' )  AND e1.parent = e0.link AND (e1.lang_mask & 9 > 0) AND e1.text_md5 =  MD5( '600a' ) 
LIMIT 0, 1

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.action AS e1_action, e1.alias_redirects AS e1_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1 WHERE e0.parent = 0 AND (e0.lang_mask & 9 > 0) AND e0.text_md5 =  MD5( 'routes' )  AND e1.parent = e0.link AND (e1.lang_mask & 9 > 0) AND e1.text_md5 =  MD5( '600a' ) 
LIMIT 0, 1

Module start 'content'

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 = 42663 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, name, navigation_part_identifier, locale, identifier
                    FROM   ezsection WHERE  id='9'

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:42663' ) AND is_original = 1 AND is_alias=0

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, 298, 42663 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

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

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

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 = 298 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, version, serialized_name_list, serialized_description_list, identifier, contentobject_name, url_alias_name,       creator_id, modifier_id, created, remote_id, modified, is_container, always_available,       language_mask, initial_language_id, sort_field, sort_order
                    FROM   ezcontentclass WHERE  id='1' AND version='0' ORDER BY version ASC
LIMIT 0, 2

SELECT ezcontentobject.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, 298 ) 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 ) 
 ORDER BY path_string

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

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, 298 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '457174'
                       AND content_version = '246'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '457174'
                       AND content_version = '246'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

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

SELECT id, contentobject_id, creator_id, version, status, created, modified,       workflow_event_pos, user_id, language_mask, initial_language_id
                    FROM   ezcontentobject_version WHERE  version='246' AND contentobject_id='457174' ORDER BY version ASC

Only variables should be assigned by reference in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/modules/routes/routesfunctioncollection.php on line 288

Only variables should be assigned by reference in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/modules/routes/routesfunctioncollection.php on line 298

SELECT route_id, RouteGroup FROM ROUTES WHERE route_id = '600A'

SELECT route_id FROM ROUTES WHERE route_id IN ('600','600K','600P','600A','600B','600C','600G','600H','600J','600M','600U','600F','600X','600T','600S','600N','600R','600L','600W','600V','601','601K','601P','601A','601B','601C','601G','601H','601J','601M','601U','601F','601X','601T','601S','601N','601R','601L','601W','601V','605','605K','605P','605A','605B','605C','605G','605H','605J','605M','605U','605F','605X','605T','605S','605N','605R','605L','605W','605V') ORDER BY route_id ASC

SELECT route_id, RouteGroup FROM ROUTES WHERE route_id = '600A'

SELECT ROUTE_DIRECTION_HEADER.timetable_header, ROUTES.route_type
                    FROM ROUTE_DIRECTION_HEADER 
                    JOIN ROUTES ON ROUTES.route_id = ROUTE_DIRECTION_HEADER.route_id
                    WHERE ROUTE_DIRECTION_HEADER.route_id = '600' 
                    ORDER BY ROUTE_DIRECTION_HEADER.direction_id ASC LIMIT 0,1

SELECT ROUTE_DIRECTION_HEADER.timetable_header, ROUTES.route_type
                    FROM ROUTE_DIRECTION_HEADER 
                    JOIN ROUTES ON ROUTES.route_id = ROUTE_DIRECTION_HEADER.route_id
                    WHERE ROUTE_DIRECTION_HEADER.route_id = '601' 
                    ORDER BY ROUTE_DIRECTION_HEADER.direction_id ASC LIMIT 0,1

SELECT ROUTE_DIRECTION_HEADER.timetable_header, ROUTES.route_type
                    FROM ROUTE_DIRECTION_HEADER 
                    JOIN ROUTES ON ROUTES.route_id = ROUTE_DIRECTION_HEADER.route_id
                    WHERE ROUTE_DIRECTION_HEADER.route_id = '605' 
                    ORDER BY ROUTE_DIRECTION_HEADER.direction_id ASC LIMIT 0,1

SELECT ROUTE_DIRECTION_HEADER.timetable_header, ROUTES.route_type
                    FROM ROUTE_DIRECTION_HEADER 
                    JOIN ROUTES ON ROUTES.route_id = ROUTE_DIRECTION_HEADER.route_id
                    WHERE ROUTE_DIRECTION_HEADER.route_id = 'G30F' 
                    ORDER BY ROUTE_DIRECTION_HEADER.direction_id ASC LIMIT 0,1

SELECT *
                         FROM StopListXML
                         WHERE 
                         ROUTE_ID = '600A' 
                         AND
                         BOUND = 0

Only variables should be assigned by reference in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/modules/routes/routesfunctioncollection.php on line 288

Only variables should be assigned by reference in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/modules/routes/routesfunctioncollection.php on line 298

SELECT route_id, RouteGroup FROM ROUTES WHERE route_id = '600A'

SELECT route_id FROM ROUTES WHERE route_id IN ('600','600K','600P','600A','600B','600C','600G','600H','600J','600M','600U','600F','600X','600T','600S','600N','600R','600L','600W','600V','601','601K','601P','601A','601B','601C','601G','601H','601J','601M','601U','601F','601X','601T','601S','601N','601R','601L','601W','601V','605','605K','605P','605A','605B','605C','605G','605H','605J','605M','605U','605F','605X','605T','605S','605N','605R','605L','605W','605V') ORDER BY route_id ASC

SELECT route_id, RouteGroup FROM ROUTES WHERE route_id = '600A'

SELECT ROUTE_DIRECTION_HEADER.timetable_header, ROUTES.route_type
                    FROM ROUTE_DIRECTION_HEADER 
                    JOIN ROUTES ON ROUTES.route_id = ROUTE_DIRECTION_HEADER.route_id
                    WHERE ROUTE_DIRECTION_HEADER.route_id = '600' 
                    ORDER BY ROUTE_DIRECTION_HEADER.direction_id ASC LIMIT 0,1

SELECT ROUTE_DIRECTION_HEADER.timetable_header, ROUTES.route_type
                    FROM ROUTE_DIRECTION_HEADER 
                    JOIN ROUTES ON ROUTES.route_id = ROUTE_DIRECTION_HEADER.route_id
                    WHERE ROUTE_DIRECTION_HEADER.route_id = '601' 
                    ORDER BY ROUTE_DIRECTION_HEADER.direction_id ASC LIMIT 0,1

SELECT ROUTE_DIRECTION_HEADER.timetable_header, ROUTES.route_type
                    FROM ROUTE_DIRECTION_HEADER 
                    JOIN ROUTES ON ROUTES.route_id = ROUTE_DIRECTION_HEADER.route_id
                    WHERE ROUTE_DIRECTION_HEADER.route_id = '605' 
                    ORDER BY ROUTE_DIRECTION_HEADER.direction_id ASC LIMIT 0,1

SELECT ROUTE_DIRECTION_HEADER.timetable_header, ROUTES.route_type
                    FROM ROUTE_DIRECTION_HEADER 
                    JOIN ROUTES ON ROUTES.route_id = ROUTE_DIRECTION_HEADER.route_id
                    WHERE ROUTE_DIRECTION_HEADER.route_id = 'G30F' 
                    ORDER BY ROUTE_DIRECTION_HEADER.direction_id ASC LIMIT 0,1

SELECT *
                         FROM StopListXML
                         WHERE 
                         ROUTE_ID = '600A' 
                         AND
                         BOUND = 1

SELECT value FROM ezsite_data WHERE name='ezfind_site_id'

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

array_key_exists() expects parameter 2 to be array, null given in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/ezfind/classes/ezfezpsolrquerybuilder.php on line 389

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 IN ( 42663, 726, 727, 728, 382, 483, 593, 660, 664, 665 ) AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

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 = 42663 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:42663' ) AND is_original = 1 AND is_alias=0

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, 298, 42663 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

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 = 726 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:726' ) AND is_original = 1 AND is_alias=0

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, 298, 726 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

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 = 727 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:727' ) AND is_original = 1 AND is_alias=0

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, 298, 727 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

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 = 728 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:728' ) AND is_original = 1 AND is_alias=0

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, 298, 728 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

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 = 382 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:382' ) AND is_original = 1 AND is_alias=0

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, 298, 382 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

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 = 483 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:483' ) AND is_original = 1 AND is_alias=0

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, 298, 483 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

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 = 593 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:593' ) AND is_original = 1 AND is_alias=0

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, 298, 593 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

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 = 660 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:660' ) AND is_original = 1 AND is_alias=0

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, 298, 660 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

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 = 664 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:664' ) AND is_original = 1 AND is_alias=0

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, 298, 664 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

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 = 665 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:665' ) AND is_original = 1 AND is_alias=0

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, 298, 665 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

SELECT contentobject_attribute_id, version, filename, original_filename, mime_type, download_count
                    FROM   ezbinaryfile WHERE  contentobject_attribute_id='2419678' AND version='246'

SELECT contentobject_attribute_id, version, filename, original_filename, mime_type, download_count
                    FROM   ezbinaryfile WHERE  contentobject_attribute_id='2419681' AND version='246'

SELECT contentobject_attribute_id, version, filename, original_filename, mime_type, download_count
                    FROM   ezbinaryfile WHERE  contentobject_attribute_id='2419682' AND version='246'

SELECT contentobject_attribute_id, version, filename, original_filename, mime_type, download_count
                    FROM   ezbinaryfile WHERE  contentobject_attribute_id='2419679' AND version='246'

Only variables should be assigned by reference in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/modules/routes/routesfunctioncollection.php on line 646

Only variables should be assigned by reference in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/modules/routes/routesfunctioncollection.php on line 655

SELECT ROUTES.route_id, ROUTES.RouteGroup
                      FROM ROUTES
                      WHERE ROUTES.route_id = '600A'

array_key_exists() expects parameter 2 to be array, null given in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/ezfind/classes/ezfezpsolrquerybuilder.php on line 389

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 IN ( 726, 727, 728, 42663 ) AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

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 = 726 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:726' ) AND is_original = 1 AND is_alias=0

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, 298, 726 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

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 = 727 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:727' ) AND is_original = 1 AND is_alias=0

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, 298, 727 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

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 = 728 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:728' ) AND is_original = 1 AND is_alias=0

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, 298, 728 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

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 = 42663 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:42663' ) AND is_original = 1 AND is_alias=0

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, 298, 42663 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
                    ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ezcontentobject_version.contentobject_id = '742' AND
                    ezcontentobject_version.version = '328' AND
                    ezcontentobject_attribute.contentobject_id = '742' AND                    ezcontentobject_attribute.version = '328' AND                    ezcontentobject_attribute.language_code = 'eng-AU' 
                  
                  ORDER BY
                    ezcontentclass_attribute.placement ASC,
                    ezcontentobject_attribute.language_code ASC

SELECT contentobject_attribute_id, version, filename, original_filename, mime_type, download_count
                    FROM   ezbinaryfile WHERE  contentobject_attribute_id='6977' AND version='328'

SELECT contentobject_attribute_id, version, filename, original_filename, mime_type, download_count
                    FROM   ezbinaryfile WHERE  contentobject_attribute_id='10699' AND version='328'

SELECT contentobject_attribute_id, version, filename, original_filename, mime_type, download_count
                    FROM   ezbinaryfile WHERE  contentobject_attribute_id='444355' AND version='328'

SELECT contentobject_attribute_id, version, filename, original_filename, mime_type, download_count
                    FROM   ezbinaryfile WHERE  contentobject_attribute_id='57302' AND version='328'

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

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

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

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

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

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

Unknown get variable 'dir'

Cannot open log file 'var/log/error.log' for writing
The web server must be allowed to modify the file.
File logging for 'var/log/error.log' is disabled.

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

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

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

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:298', 'eznode:42663' ) AND is_original = 1 AND is_alias=0

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, 298, 42663 ) 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 ) ) & 8 ) >> 2 )
   <
     ( con.language_id & 1 )
   + ( ( con.language_id & 8 ) >> 2 )
 )

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

Module end 'content'

Missing translation for message in context: 'kernel/navigationpart' with comment: 'Navigation part'. The untranslated message is: 'eZFind'

Missing translation for message in context: 'kernel/navigationpart' with comment: 'Navigation part'. The untranslated message is: 'Service portal'

Missing translation for message in context: 'kernel/navigationpart' with comment: 'Navigation part'. The untranslated message is: 'AdelaideMetro'

Missing translation for message in context: 'kernel/navigationpart' with comment: 'Navigation part'. The untranslated message is: 'Connect SA'

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

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 = 42663 and
                        
                        
                           ezcontentobject.contentclass_id  IN  ( 25 ) 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 ) 

                        AND ezcontentobject_tree.is_invisible = 0
                         AND ((ezcontentobject.contentclass_id in (28, 29, 30, 32, 33, 34, 42) AND ezcontentobject.section_id in (3)) OR (ezcontentobject.section_id in (1, 9))) 
                        
                         AND 
 ezcontentobject.language_mask & 9 > 0

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

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 = 42663 and
                        
                        
                           ezcontentobject.contentclass_id  IN  ( 25 ) 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 ) 

                        AND ezcontentobject_tree.is_invisible = 0
                         AND ((ezcontentobject.contentclass_id in (28, 29, 30, 32, 33, 34, 42) AND ezcontentobject.section_id in (3)) OR (ezcontentobject.section_id in (1, 9))) 
                        
                         AND 
 ezcontentobject.language_mask & 9 > 0

Variable 'pagedata' is already defined.

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

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 = 42663 and
                        
                        
                           ezcontentobject.contentclass_id  IN  ( 25 ) 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 ) 

                        AND ezcontentobject_tree.is_invisible = 0
                         AND ((ezcontentobject.contentclass_id in (28, 29, 30, 32, 33, 34, 42) AND ezcontentobject.section_id in (3)) OR (ezcontentobject.section_id in (1, 9))) 
                        
                         AND 
 ezcontentobject.language_mask & 9 > 0

No case match and no default case

SELECT DISTINCT e0.id AS e0_id, e0.parent AS e0_parent, e0.lang_mask AS e0_lang_mask, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.action AS e0_action, e0.link AS e0_link FROM ezurlalias_ml e0 WHERE e0.parent = 0 AND (e0.lang_mask & 9 > 0) AND e0.text_md5 =  MD5( 'timetables2' )

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 = 358 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

Variable 'sub_menu_parent_id' is already defined.

SELECT DISTINCT e0.id AS e0_id, e0.parent AS e0_parent, e0.lang_mask AS e0_lang_mask, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.action AS e0_action, e0.link AS e0_link FROM ezurlalias_ml e0 WHERE e0.parent = 0 AND (e0.lang_mask & 9 > 0) AND e0.text_md5 =  MD5( 'maps2' )

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 = 199453 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

Variable 'sub_menu_parent_node' is already defined.

Variable 'sub_menu_parent_id' is already defined.

SELECT DISTINCT e0.id AS e0_id, e0.parent AS e0_parent, e0.lang_mask AS e0_lang_mask, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.action AS e0_action, e0.link AS e0_link FROM ezurlalias_ml e0 WHERE e0.parent = 0 AND (e0.lang_mask & 9 > 0) AND e0.text_md5 =  MD5( 'tickets-fares' )

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 = 427 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

Variable 'sub_menu_parent_node' is already defined.

Variable 'sub_menu_parent_id' is already defined.

SELECT DISTINCT e0.id AS e0_id, e0.parent AS e0_parent, e0.lang_mask AS e0_lang_mask, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.action AS e0_action, e0.link AS e0_link FROM ezurlalias_ml e0 WHERE e0.parent = 0 AND (e0.lang_mask & 9 > 0) AND e0.text_md5 =  MD5( 'announcements' )

SELECT id, parent, lang_mask, text, link FROM ezurlalias_ml WHERE id=291

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 = 296 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

Variable 'sub_menu_parent_node' is already defined.

Variable 'sub_menu_parent_id' is already defined.

SELECT DISTINCT e0.id AS e0_id, e0.parent AS e0_parent, e0.lang_mask AS e0_lang_mask, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.action AS e0_action, e0.link AS e0_link FROM ezurlalias_ml e0 WHERE e0.parent = 0 AND (e0.lang_mask & 9 > 0) AND e0.text_md5 =  MD5( 'using-adelaide-metro' )

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 = 397 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

Variable 'sub_menu_parent_node' is already defined.

Variable 'sub_menu_parent_id' is already defined.

SELECT DISTINCT e0.id AS e0_id, e0.parent AS e0_parent, e0.lang_mask AS e0_lang_mask, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.action AS e0_action, e0.link AS e0_link FROM ezurlalias_ml e0 WHERE e0.parent = 0 AND (e0.lang_mask & 9 > 0) AND e0.text_md5 =  MD5( 'about-us' )

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 = 390 AND  ezcontentclass.version = 0  AND 
 ezcontentobject.language_mask & 9 > 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 ) ) & 8 ) >> 2 )
   <
     ( ezcontentobject_name.language_id & 1 )
   + ( ( ezcontentobject_name.language_id & 8 ) >> 2 )
 )

Variable 'sub_menu_parent_node' is already defined.

Variable 'sub_menu_parent_id' is already defined.

Script end