Stop 31 Old Mt Barker Rd - South 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( '14632' ) 
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( '14632' ) 
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 = '14632'
				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 = 14632
                LIMIT 1

SELECT STOP_TIMES.arrival_time, STOP_TIMES.trip_id FROM STOP_TIMES
    				WHERE
    				stop_id = 4765
    				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 = 4765
                                    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 = 4765
                                    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 = 4765
                                    AND TRIPS.route_id = ROUTES.route_id 
    				GROUP BY TRIPS.route_id

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

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '822' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '865'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '865' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '865C'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '865C' 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

Undefined variable: route_gp in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/classes/api.php on line 384

Invalid argument supplied for foreach() in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/classes/api.php on line 384

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

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '866' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '866A'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '866A' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '871'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '871' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '875T'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '875T' 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 = '403510' AND TRIPS.direction_id = 1
                                                    AND
                                                    TRIPS.route_id = '875T'
                                                    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

Undefined offset: 0 in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/classes/api.php on line 417

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

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '822' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '865'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '865' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '865C'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '865C' 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

Undefined variable: route_gp in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/classes/api.php on line 384

Invalid argument supplied for foreach() in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/classes/api.php on line 384

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

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '866' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '866A'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '866A' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '871'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '871' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '875T'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '875T' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '822'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '822' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '865'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '865' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '865C'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '865C' 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

Undefined variable: route_gp in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/classes/api.php on line 384

Invalid argument supplied for foreach() in /home/ptsadmin/www.adelaidemetro.com.au/ezpublish_54-201611-017/ezpublish_legacy/extension/adelaidemetro/classes/api.php on line 384

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

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '866' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '866A'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '866A' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '871'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '871' 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 route_type FROM ROUTES
                                WHERE 
                                route_id = '875T'
                                LIMIT 1

SELECT TRIPS.trip_id, CALENDAR.* FROM TRIPS, CALENDAR
                                    WHERE 
                                    TRIPS.route_id = '875T' 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

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 = '4765'
					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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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:197390' ) 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, 197390 ) 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 = '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 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 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 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 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 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 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:197745' ) 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, 197745 ) 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 = '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 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 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 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 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 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 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 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 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' )