Stop 50 Perseverance Rd - North West side

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.alias_redirects AS e1_alias_redirects, e2.id AS e2_id, e2.link AS e2_link, e2.text AS e2_text, e2.text_md5 AS e2_text_md5, e2.is_alias AS e2_is_alias, e2.action AS e2_action, e2.alias_redirects AS e2_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1, ezurlalias_ml e2 WHERE e0.parent = 0 AND (e0.lang_mask & 9 > 0) AND e0.text_md5 =  MD5( 'stops' )  AND e1.parent = e0.link AND (e1.lang_mask & 9 > 0) AND e1.text_md5 =  MD5( 'view' )  AND e2.parent = e1.link AND (e2.lang_mask & 9 > 0) AND e2.text_md5 =  MD5( '11187' ) 
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.alias_redirects AS e1_alias_redirects, e2.id AS e2_id, e2.link AS e2_link, e2.text AS e2_text, e2.text_md5 AS e2_text_md5, e2.is_alias AS e2_is_alias, e2.action AS e2_action, e2.alias_redirects AS e2_alias_redirects FROM ezurlalias_ml e0, ezurlalias_ml e1, ezurlalias_ml e2 WHERE e0.parent = 0 AND (e0.lang_mask & 9 > 0) AND e0.text_md5 =  MD5( 'stops' )  AND e1.parent = e0.link AND (e1.lang_mask & 9 > 0) AND e1.text_md5 =  MD5( 'view' )  AND e2.parent = e1.link AND (e2.lang_mask & 9 > 0) AND e2.text_md5 =  MD5( '11187' ) 
LIMIT 0, 1

Module start 'stops'

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

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

SELECT STOPS.stop_id, STOPS.stop_code, STOPS.stop_name, STOPS.stop_desc
				FROM STOPS
				WHERE STOPS.stop_code = '11187'
				ORDER BY STOPS.stop_code ASC

Undefined variable: return_trips in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/modules/stops/view.php on line 144

Undefined variable: query in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/modules/stops/view.php on line 144

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

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

SELECT
                    ST.stop_id,
                    ST.stop_name,
                    ST.stop_code,
                    ST.stop_lat,
                    ST.stop_lon,
                    ST.stop_desc,
                    ST.stop_suburb,
                    ST.parent_station,
                    (SELECT DISTINCT SUB.stop_code FROM STOPS SUB WHERE ST.parent_station != '' AND ST.parent_station = SUB.parent_station AND  ST.stop_code != SUB.stop_code) as oposite_direction_code
                FROM
                    STOPS ST
				WHERE
				    ST.stop_code = 11187
                LIMIT 1

SELECT STOP_TIMES.arrival_time, STOP_TIMES.trip_id FROM STOP_TIMES
    				WHERE
    				stop_id = 1232
    				ORDER BY STOP_TIMES.arrival_time

SELECT TRIPS.route_id, TRIPS.trip_id
                                    FROM STOP_TIMES, TRIPS, ROUTES
    				WHERE
    				STOP_TIMES.trip_id = TRIPS.trip_id
    				AND
    				STOP_TIMES.stop_id = 1232
                                    AND TRIPS.route_id = ROUTES.route_id 
    				GROUP BY TRIPS.route_id

SELECT TRIPS.route_id, TRIPS.trip_id
                                    FROM STOP_TIMES, TRIPS, ROUTES
    				WHERE
    				STOP_TIMES.trip_id = TRIPS.trip_id
    				AND
    				STOP_TIMES.stop_id = 1232
                                    AND TRIPS.route_id = ROUTES.route_id 
    				GROUP BY TRIPS.route_id

SELECT TRIPS.route_id, TRIPS.trip_id
                                    FROM STOP_TIMES, TRIPS, ROUTES
    				WHERE
    				STOP_TIMES.trip_id = TRIPS.trip_id
    				AND
    				STOP_TIMES.stop_id = 1232
                                    AND TRIPS.route_id = ROUTES.route_id 
    				GROUP BY TRIPS.route_id

SELECT route_type FROM ROUTES
                                WHERE 
                                route_id = '557'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '557' AND TRIPS.direction_id = 1
                                    AND
                                    TRIPS.service_id = CALENDAR.service_id
				    AND
				    CALENDAR.start_date <= Now()
                                    AND
                                    CALENDAR.end_date >= Now() 
                                    ORDER BY TRIPS.trip_id ASC

SELECT TRIPS.trip_headsign, ROUTES.route_long_name, ROUTE_DIRECTION_HEADER.timetable_header
                                                    FROM TRIPS, ROUTES, ROUTE_DIRECTION_HEADER
                                                    WHERE 
                                                    TRIPS.trip_id = '463245' AND TRIPS.direction_id = 1
                                                    AND
                                                    TRIPS.route_id = '557'
                                                    AND
                                                    TRIPS.route_id = ROUTE_DIRECTION_HEADER.route_id
                                                    AND
                                                    TRIPS.route_id = ROUTES.route_id
                                                    AND
                                                    ROUTE_DIRECTION_HEADER.day_type = 0 
                                                    AND 
                                                    ROUTE_DIRECTION_HEADER.direction_id = 1
                                                    LIMIT 1

SELECT route_type FROM ROUTES
                                WHERE 
                                route_id = '557S'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '557S' AND TRIPS.direction_id = 1
                                    AND
                                    TRIPS.service_id = CALENDAR.service_id
				    AND
				    CALENDAR.start_date <= Now()
                                    AND
                                    CALENDAR.end_date >= Now() 
                                    ORDER BY TRIPS.trip_id ASC

SELECT TRIPS.trip_headsign, ROUTES.route_long_name, ROUTE_DIRECTION_HEADER.timetable_header
                                                    FROM TRIPS, ROUTES, ROUTE_DIRECTION_HEADER
                                                    WHERE 
                                                    TRIPS.trip_id = '463321' AND TRIPS.direction_id = 1
                                                    AND
                                                    TRIPS.route_id = '557S'
                                                    AND
                                                    TRIPS.route_id = ROUTE_DIRECTION_HEADER.route_id
                                                    AND
                                                    TRIPS.route_id = ROUTES.route_id
                                                    AND
                                                    ROUTE_DIRECTION_HEADER.day_type = 0 
                                                    AND 
                                                    ROUTE_DIRECTION_HEADER.direction_id = 1
                                                    LIMIT 1

SELECT route_type FROM ROUTES
                                WHERE 
                                route_id = '557'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '557' AND TRIPS.direction_id = 1
                                    AND
                                    TRIPS.service_id = CALENDAR.service_id
				    AND
				    CALENDAR.start_date <= Now()
                                    AND
                                    CALENDAR.end_date >= Now() 
                                    ORDER BY TRIPS.trip_id ASC

SELECT TRIPS.trip_headsign, ROUTES.route_long_name, ROUTE_DIRECTION_HEADER.timetable_header
                                                    FROM TRIPS, ROUTES, ROUTE_DIRECTION_HEADER
                                                    WHERE 
                                                    TRIPS.trip_id = '467656' AND TRIPS.direction_id = 1
                                                    AND
                                                    TRIPS.route_id = '557'
                                                    AND
                                                    TRIPS.route_id = ROUTE_DIRECTION_HEADER.route_id
                                                    AND
                                                    TRIPS.route_id = ROUTES.route_id
                                                    AND 
                                                    ROUTE_DIRECTION_HEADER.direction_id = 1
                                                    LIMIT 1

SELECT route_type FROM ROUTES
                                WHERE 
                                route_id = '557S'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '557S' AND TRIPS.direction_id = 1
                                    AND
                                    TRIPS.service_id = CALENDAR.service_id
				    AND
				    CALENDAR.start_date <= Now()
                                    AND
                                    CALENDAR.end_date >= Now() 
                                    ORDER BY TRIPS.trip_id ASC

SELECT TRIPS.trip_headsign, ROUTES.route_long_name, ROUTE_DIRECTION_HEADER.timetable_header
                                                    FROM TRIPS, ROUTES, ROUTE_DIRECTION_HEADER
                                                    WHERE 
                                                    TRIPS.trip_id = '467690' AND TRIPS.direction_id = 1
                                                    AND
                                                    TRIPS.route_id = '557S'
                                                    AND
                                                    TRIPS.route_id = ROUTE_DIRECTION_HEADER.route_id
                                                    AND
                                                    TRIPS.route_id = ROUTES.route_id
                                                    AND 
                                                    ROUTE_DIRECTION_HEADER.direction_id = 1
                                                    LIMIT 1

SELECT route_type FROM ROUTES
                                WHERE 
                                route_id = '557'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '557' AND TRIPS.direction_id = 1
                                    AND
                                    TRIPS.service_id = CALENDAR.service_id
				    AND
				    CALENDAR.start_date <= Now()
                                    AND
                                    CALENDAR.end_date >= Now() 
                                    ORDER BY TRIPS.trip_id ASC

SELECT TRIPS.trip_headsign, ROUTES.route_long_name, ROUTE_DIRECTION_HEADER.timetable_header 
                                                    FROM TRIPS, ROUTES, ROUTE_DIRECTION_HEADER
                                                    WHERE 
                                                    TRIPS.trip_id = '470480' AND TRIPS.direction_id = 1
                                                    AND
                                                    TRIPS.route_id = '557'
                                                    AND
                                                    TRIPS.route_id = ROUTE_DIRECTION_HEADER.route_id    
                                                    AND
                                                    TRIPS.route_id = ROUTES.route_id
                                                    AND 
                                                    ROUTE_DIRECTION_HEADER.direction_id = 1
                                                    LIMIT 1

SELECT route_type FROM ROUTES
                                WHERE 
                                route_id = '557S'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '557S' AND TRIPS.direction_id = 1
                                    AND
                                    TRIPS.service_id = CALENDAR.service_id
				    AND
				    CALENDAR.start_date <= Now()
                                    AND
                                    CALENDAR.end_date >= Now() 
                                    ORDER BY TRIPS.trip_id ASC

SELECT TRIPS.trip_headsign, ROUTES.route_long_name, ROUTE_DIRECTION_HEADER.timetable_header 
                                                    FROM TRIPS, ROUTES, ROUTE_DIRECTION_HEADER
                                                    WHERE 
                                                    TRIPS.trip_id = '470508' AND TRIPS.direction_id = 1
                                                    AND
                                                    TRIPS.route_id = '557S'
                                                    AND
                                                    TRIPS.route_id = ROUTE_DIRECTION_HEADER.route_id    
                                                    AND
                                                    TRIPS.route_id = ROUTES.route_id
                                                    AND 
                                                    ROUTE_DIRECTION_HEADER.direction_id = 1
                                                    LIMIT 1

Undefined variable: route_mode_id in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/modules/stops/stopsfunctioncollection.php on line 178

Undefined variable: route_mode_id in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/modules/stops/stopsfunctioncollection.php on line 181

Undefined variable: route_mode_id in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/modules/stops/stopsfunctioncollection.php on line 184

SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )     WHERE ezcontentobject_tree.parent_node_id = 964 and         ezcontentobject.contentclass_id  IN  ( 71 ) 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

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

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

SELECT TRIPS.route_id, ROUTES.route_type FROM TRIPS
					JOIN STOP_TIMES ON STOP_TIMES.trip_id = TRIPS.trip_id
					JOIN ROUTES ON ROUTES.route_id = TRIPS.route_id
					JOIN CALENDAR C ON (C.service_id = TRIPS.service_id) AND (C.start_date <= NOW() AND C.end_date >= NOW())
					WHERE STOP_TIMES.stop_id = '1232'
					GROUP BY TRIPS.route_id
					ORDER BY TRIPS.route_id ASC

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

SELECT DISTINCT ezcontentobject.contentclass_id, ezcontentobject.current_version, ezcontentobject.id, ezcontentobject.initial_language_id, ezcontentobject.language_mask, ezcontentobject.modified, ezcontentobject.owner_id, ezcontentobject.published, ezcontentobject.remote_id AS object_remote_id, ezcontentobject.section_id, ezcontentobject.status, ezcontentobject_tree.contentobject_is_published, ezcontentobject_tree.contentobject_version, ezcontentobject_tree.depth, ezcontentobject_tree.is_hidden, ezcontentobject_tree.is_invisible, ezcontentobject_tree.main_node_id, ezcontentobject_tree.modified_subnode, ezcontentobject_tree.node_id, ezcontentobject_tree.parent_node_id, ezcontentobject_tree.path_identification_string, ezcontentobject_tree.path_string, ezcontentobject_tree.priority, ezcontentobject_tree.remote_id, ezcontentobject_tree.sort_field, ezcontentobject_tree.sort_order, ezcontentclass.serialized_name_list as class_serialized_name_list, ezcontentclass.identifier as class_identifier, ezcontentclass.is_container as is_container , ezcontentobject_name.name, ezcontentobject_name.real_translation   FROM ezcontentobject_tree INNER JOIN ezcontentobject ON (ezcontentobject_tree.contentobject_id = ezcontentobject.id) INNER JOIN ezcontentclass ON (ezcontentclass.version = 0 AND ezcontentclass.id = ezcontentobject.contentclass_id) INNER JOIN ezcontentobject_name ON (     ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id AND     ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version )     WHERE  ezcontentobject_tree.path_string like '/1/2/296/%' and  ezcontentobject_tree.depth <= 4  and      ezcontentobject_tree.node_id != 296 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 ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
                    ezcontentobject_attribute, ezcontentclass_attribute
                  WHERE
                    ezcontentclass_attribute.version = '0' AND
                    ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
                    ( ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '367' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '9' AND
                    ezcontentobject_attribute.contentobject_id = '277644' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '6' AND
                    ezcontentobject_attribute.contentobject_id = '363' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '485367' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '12' AND
                    ezcontentobject_attribute.contentobject_id = '367033' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '756814' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '939725' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '1034239' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '21' AND
                    ezcontentobject_attribute.contentobject_id = '1131002' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '1164027' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '11' AND
                    ezcontentobject_attribute.contentobject_id = '1166825' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '1223194' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1244973' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '1246854' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1254299' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1263297' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '1285142' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '1286147' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1292778' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1299728' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1306825' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1312461' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '5' AND
                    ezcontentobject_attribute.contentobject_id = '1314744' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '1317284' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '8' AND
                    ezcontentobject_attribute.contentobject_id = '1321123' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1323235' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '1324067' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '52' AND
                    ezcontentobject_attribute.contentobject_id = '1334433' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '4' AND
                    ezcontentobject_attribute.contentobject_id = '1339424' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '4' AND
                    ezcontentobject_attribute.contentobject_id = '1340600' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '6' AND
                    ezcontentobject_attribute.contentobject_id = '1341746' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '16' AND
                    ezcontentobject_attribute.contentobject_id = '1342728' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '1343278' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '1343499' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '7' AND
                    ezcontentobject_attribute.contentobject_id = '1342487' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1346645' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1348903' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '1351896' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1352496' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '1353043' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1357639' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1359827' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '6' AND
                    ezcontentobject_attribute.contentobject_id = '1360578' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '1364997' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1367323' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '1359112' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '1372598' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1374814' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1375858' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1389042' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1389114' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1390157' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1388386' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1390316' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '1389386' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '4' AND
                    ezcontentobject_attribute.contentobject_id = '1390484' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1390652' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1391253' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '1383216' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1394763' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1395735' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '2' AND
                    ezcontentobject_attribute.contentobject_id = '1397351' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '3' AND
                    ezcontentobject_attribute.contentobject_id = '1397936' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1398140' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1398271' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1398317' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  OR ( ezcontentobject_attribute.version = '1' AND
                    ezcontentobject_attribute.contentobject_id = '1398455' AND
                    ezcontentobject_attribute.language_code = 'eng-AU' )  )
                  ORDER BY
                    ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='939725' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='939725' AND
                                                                      ezcontentobject_link.from_contentobject_version='3' 
                         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 name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '390'
                       AND content_version = '331'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1034239' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1034239' AND
                                                                      ezcontentobject_link.from_contentobject_version='3' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

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

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

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1131002' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1131002' AND
                                                                      ezcontentobject_link.from_contentobject_version='21' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1166825' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1166825' AND
                                                                      ezcontentobject_link.from_contentobject_version='11' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1223194' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1223194' AND
                                                                      ezcontentobject_link.from_contentobject_version='2' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1244973' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1244973' AND
                                                                      ezcontentobject_link.from_contentobject_version='1' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

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

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

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1246854' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1246854' AND
                                                                      ezcontentobject_link.from_contentobject_version='3' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1254299' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1254299' AND
                                                                      ezcontentobject_link.from_contentobject_version='1' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1263297' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1263297' AND
                                                                      ezcontentobject_link.from_contentobject_version='1' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1285142' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1285142' AND
                                                                      ezcontentobject_link.from_contentobject_version='3' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:296', 'eznode:35132', 'eznode:196021' ) 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, 296, 35132, 196021 ) 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 = '1343656'
                       AND content_version = '1'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1292778' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1292778' AND
                                                                      ezcontentobject_link.from_contentobject_version='1' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1299728' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1299728' AND
                                                                      ezcontentobject_link.from_contentobject_version='1' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

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

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

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

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

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1306825' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1306825' AND
                                                                      ezcontentobject_link.from_contentobject_version='1' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1312461' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1312461' AND
                                                                      ezcontentobject_link.from_contentobject_version='1' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1314744' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1314744' AND
                                                                      ezcontentobject_link.from_contentobject_version='5' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1317284' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1317284' AND
                                                                      ezcontentobject_link.from_contentobject_version='3' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1321123' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1321123' AND
                                                                      ezcontentobject_link.from_contentobject_version='8' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1323235' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1323235' AND
                                                                      ezcontentobject_link.from_contentobject_version='1' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

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

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

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

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

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1324067' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1324067' AND
                                                                      ezcontentobject_link.from_contentobject_version='3' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1334433' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1334433' AND
                                                                      ezcontentobject_link.from_contentobject_version='52' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1340600' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1340600' AND
                                                                      ezcontentobject_link.from_contentobject_version='4' 
                         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 )
 )

Variable 'related_routes' is already defined.

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1341746' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1341746' AND
                                                                      ezcontentobject_link.from_contentobject_version='6' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:296', 'eznode:35132', 'eznode:198650' ) 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, 296, 35132, 198650 ) 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 = '1341655'
                       AND content_version = '1'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1342728' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1342728' AND
                                                                      ezcontentobject_link.from_contentobject_version='16' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT id, parent, lang_mask, text, action FROM ezurlalias_ml WHERE ( ezurlalias_ml.lang_mask & 9 > 0 ) AND action in ( 'eznode:2', 'eznode:296', 'eznode:35132', 'eznode:198692' ) 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, 296, 35132, 198692 ) 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 = '310'
                       AND content_version = '356'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1343278' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1343278' AND
                                                                      ezcontentobject_link.from_contentobject_version='3' 
                         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 )
 )

Variable 'related_routes' is already defined.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '601'
                       AND content_version = '324'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '773'
                       AND content_version = '299'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '1007330'
                       AND content_version = '76'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '644'
                       AND content_version = '332'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '647'
                       AND content_version = '324'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '651'
                       AND content_version = '326'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '144623'
                       AND content_version = '304'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '1007333'
                       AND content_version = '75'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '314'
                       AND content_version = '342'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '309'
                       AND content_version = '347'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '748'
                       AND content_version = '313'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '592'
                       AND content_version = '311'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '595'
                       AND content_version = '324'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '601'
                       AND content_version = '324'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '765'
                       AND content_version = '319'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '1007330'
                       AND content_version = '76'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '644'
                       AND content_version = '332'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '647'
                       AND content_version = '324'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '651'
                       AND content_version = '326'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '144623'
                       AND content_version = '304'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1343499' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1343499' AND
                                                                      ezcontentobject_link.from_contentobject_version='3' 
                         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 )
 )

Variable 'related_routes' is already defined.

SELECT ezcontentobject.*,
                               ezcontentclass.serialized_name_list as serialized_name_list,
                               ezcontentclass.identifier as contentclass_identifier,
                               ezcontentclass.is_container as is_container
                           FROM
                               ezcontentobject,
                               ezcontentclass
                           WHERE
                               ezcontentobject.id='1342487' AND
                               ezcontentclass.id = ezcontentobject.contentclass_id AND
                               ezcontentclass.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.to_contentobject_id AND
                                                                      ezcontentobject_link.from_contentobject_id='1342487' AND
                                                                      ezcontentobject_link.from_contentobject_version='7' 
                         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 )
 )

Variable 'related_routes' is already defined.

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '1341655'
                       AND content_version = '1'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '166099'
                       AND content_version = '287'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '166106'
                       AND content_version = '270'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '166096'
                       AND content_version = '279'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '856'
                       AND content_version = '296'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '664'
                       AND content_version = '284'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )

SELECT name, content_translation
                 FROM ezcontentobject_name
                 WHERE contentobject_id = '884'
                       AND content_version = '276'
                       AND ( content_translation = 'eng-AU' OR language_id = '8' )