Exception Object
(
[message:protected] => Element with key 'online_map' does not exist in hashtable
[string:private] =>
[code:protected] => 0
[file:protected] => /home/waterscape/public_html/waterscape/lib/Waterscape/Util/Hashtable.php
[line:protected] => 85
[trace:private] => Array
(
[0] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Smarty.php
[line] => 254
[function] => get
[class] => Waterscape_Util_Hashtable
[type] => ->
[args] => Array
(
[0] => online_map
)
)
[1] => Array
(
[file] => /home/waterscape/public_html/waterscape/var/smarty/templates_c/%%96^962^96223EEB%%map.tpl.php
[line] => 9
[function] => smartyFunctionComponent
[class] => Waterscape_Smarty
[type] => ->
[args] => Array
(
[0] => Array
(
[name] => online_map
)
[1] => Waterscape_Smarty Object
(
[_is_for_print:private] =>
[_is_text_only:private] =>
[template_dir] => /home/waterscape/public_html/waterscape/var/smarty/templates/
[compile_dir] => /home/waterscape/public_html/waterscape/var/smarty/templates_c/
[config_dir] => /home/waterscape/public_html/waterscape/var/smarty/configs/
[plugins_dir] => Array
(
[0] => plugins
)
[debugging] =>
[error_reporting] =>
[debug_tpl] =>
[debugging_ctrl] => NONE
[compile_check] => 1
[force_compile] =>
[caching] => 0
[cache_dir] => /home/waterscape/public_html/waterscape/var/smarty/cache/
[cache_lifetime] => 3600
[cache_modified_check] =>
[php_handling] => 0
[security] =>
[secure_dir] => Array
(
)
[security_settings] => Array
(
[PHP_HANDLING] =>
[IF_FUNCS] => Array
(
[0] => array
[1] => list
[2] => isset
[3] => empty
[4] => count
[5] => sizeof
[6] => in_array
[7] => is_array
[8] => true
[9] => false
[10] => null
)
[INCLUDE_ANY] =>
[PHP_TAGS] =>
[MODIFIER_FUNCS] => Array
(
[0] => count
)
[ALLOW_CONSTANTS] =>
)
[trusted_dir] => Array
(
)
[left_delimiter] => {
[right_delimiter] => }
[request_vars_order] => EGPCS
[request_use_auto_globals] => 1
[compile_id] =>
[use_sub_dirs] =>
[default_modifiers] => Array
(
)
[default_resource_type] => file
[cache_handler_func] =>
[autoload_filters] => Array
(
)
[config_overwrite] => 1
[config_booleanize] => 1
[config_read_hidden] =>
[config_fix_newlines] => 1
[default_template_handler_func] =>
[compiler_file] => Smarty_Compiler.class.php
[compiler_class] => Smarty_Compiler
[config_class] => Config_File
[_tpl_vars] => Array
(
[page_title] => Map of %LOCATION_NAME% | Maps | Waterscape.com
[page_description] => Map showing the route of %LOCATION_NAME% by Waterscape.com
[page_keywords] => Map of %LOCATION_NAME%, Maps, Waterscape.com
[page_metadata] => Waterscape_Model_Metadata Object
(
[_title:private] => Map of %LOCATION_NAME% | Maps | Waterscape.com
[_description:private] => Map of %LOCATION_NAME%
[_keywords:private] => Map of %LOCATION_NAME%, Maps, Waterscape.com
[_alt_text:private] =>
[_author:private] =>
[_language:private] => en-GB
[_source:private] =>
[_relation:private] =>
[_format:private] =>
[_identifier:private] =>
[_publisher:private] =>
[_coverage:private] =>
[_rights:private] =>
[_contributor:private] =>
[_easting:private] => 0
[_northing:private] => 0
[_created:private] => 2007-10-08 01:08:04
[_updated:private] => 2008-10-21 16:28:23
[_indexed:private] =>
[_geo_data_id:private] =>
[_geo_data_type:private] => point
[_id:protected] => 43450
)
[response] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 114
[page_id] => 712928
[view_name] => map_waterway
[title] => Map of %LOCATION_NAME% | Maps | Waterscape.com
[keywords] =>
[description] =>
[layout_template] => Layouts/twocol_contentright_noimgorsearch.tpl
[template] => Page/locations/map.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Waterways
[path] => /canals-and-rivers/oxford-canal/map
[onload] => mapInit();
[location] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => OX
[_min_easting:private] => 436144
[_max_easting:private] => 454702
[_min_northing:private] => 206379
[_max_northing:private] => 284658
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Oxford Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/oxford-canal
[_standfirst:protected] => The picturesque Oxford Canal meanders slowly through 77 miles of classic scenery, much of which has barely changed in centuries.
[_description:protected] => The Oxford Canal is one of England's most peaceful waterways, running lazily through the countryside from [/in-your-area/oxfordshire/oxford Oxford] to [/in-your-area/warwickshire/coventry Coventry]. It was briefly the principal waterway from [/in-your-area/london London] to the Midlands, but was superseded soon after construction by the more direct Grand Junction Canal - now the [/canals-and-rivers/grand-union-canal Grand Union].
Consequently, the Oxford Canal has escaped large-scale development and few towns have sprung up on its banks. The southern section is particularly charming and remains largely unaltered.
[_id:protected] => 59
[_url_name] => oxford-canal
)
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => OX
[_min_easting:private] => 436144
[_max_easting:private] => 454702
[_min_northing:private] => 206379
[_max_northing:private] => 284658
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Oxford Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/oxford-canal
[_standfirst:protected] => The picturesque Oxford Canal meanders slowly through 77 miles of classic scenery, much of which has barely changed in centuries.
[_description:protected] => The Oxford Canal is one of England's most peaceful waterways, running lazily through the countryside from [/in-your-area/oxfordshire/oxford Oxford] to [/in-your-area/warwickshire/coventry Coventry]. It was briefly the principal waterway from [/in-your-area/london London] to the Midlands, but was superseded soon after construction by the more direct Grand Junction Canal - now the [/canals-and-rivers/grand-union-canal Grand Union].
Consequently, the Oxford Canal has escaped large-scale development and few towns have sprung up on its banks. The southern section is particularly charming and remains largely unaltered.
[_id:protected] => 59
[_url_name] => oxford-canal
)
[_na_office_manager:private] => Waterscape_Service_NavigationAuthorityOfficeManager Object
(
[_navigation_authority_office_dao:private] => Waterscape_Dao_NavigationAuthorityOffice Object
(
[_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_navigation_authority_dao:private] => Waterscape_Dao_NavigationAuthority Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
[_stoppage_manager:private] => Waterscape_Service_StoppageManager Object
(
[_stoppage_dao:private] => Waterscape_Dao_Stoppage Object
(
[_waterway_mgr:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion Object
(
[_db:protected] =>
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType Object
(
[_db:protected] =>
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription Object
(
[_db:protected] =>
)
)
[_criteria:private] => Array
(
)
[_raw_criteria:private] =>
[_sql_strings:private] => Array
(
)
[_sql_values:private] => Array
(
)
[_search_data_by:private] => Array
(
[all] => 0
[stoppage] => s
[restriction] => r
[opening_times] => o
[booking_details] => b
[advice] => a
[towpath_closure_only] => t
)
[_str_types_selected:private] =>
[_stoppage_type:private] =>
[_db:protected] =>
)
)
[_route_manager:private] => Waterscape_Service_RouteManager Object
(
[_route_dao:private] => Waterscape_Dao_Route Object
(
[_route_type_manager:private] => Waterscape_Service_RouteTypeManager Object
(
[_route_type_dao:private] => Waterscape_Dao_RouteType Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
[_waypoint_manager:private] => Waterscape_Service_WaypointManager Object
(
[_waypoint_dao:private] => Waterscape_Dao_Waypoint Object
(
[_metadata_mgr:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_geo_point_mgr:private] =>
[_geo_data_type_manager:private] => Waterscape_Service_GeoDataTypeManager Object
(
[_geo_data_dao:private] => Waterscape_Dao_GeoDataType Object
(
[_db:protected] =>
)
)
[_db:protected] =>
[_geo_point_manager] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] =>
)
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
)
[_media_manager:private] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
[_db:protected] =>
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
)
[_rating_manager:private] => Waterscape_Service_RouteRatingManager Object
(
[_route_rating_dao:private] => Waterscape_Dao_RouteRating Object
(
[_db:protected] =>
)
)
[_metadata_manager:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
)
[_view_manager:private] => Waterscape_Service_ViewManager Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
[_business_manager:private] => Waterscape_Service_BusinessManager Object
(
[_business_dao:private] => Waterscape_Dao_Business Object
(
[_address_manager:protected] => Waterscape_Service_StreetAddressManager Object
(
[_street_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
)
[_metadata_manager:protected] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_attribute_manager:protected] => Waterscape_Service_AttributeManager Object
(
[_attribute_dao:private] => Waterscape_Dao_Attribute Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_category_manager:protected] => Waterscape_Service_CategoryManager Object
(
[_category_dao:private] => Waterscape_Dao_Category Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_section_manager:protected] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_location_manager:protected] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_media_manager:protected] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
[_db:protected] =>
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
)
[_db:protected] =>
)
)
[_menu_id:protected] =>
[_menu_items:protected] =>
[_display_class:protected] =>
[_html_class:protected] =>
[_html_id:protected] =>
[_menu_components:protected] =>
[_page_manager:protected] => Waterscape_Service_PageManager Object
(
[_page_dao:private] => Waterscape_Dao_Page Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_view_manager:private] => Waterscape_Service_ViewManager Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
)
[_location_manager:protected] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_component_id:protected] => 12
[_parent_id:protected] =>
[_template:protected] => Component/LocationNavigationMenu.tpl
[_page_id:protected] =>
[_view_component_id:protected] =>
[_instance_name:protected] =>
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /canals-and-rivers/oxford-canal/map
[_path:private] => /canals-and-rivers/oxford-canal/map
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => canals-and-rivers/oxford-canal/map
[PHPSESSID] => 5ee41218b41e633b17ec3bf742d1c0f0
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] =>
[_dimension_manager] => Waterscape_Service_DimensionManager Object
(
[_dimension_dao:private] => Waterscape_Dao_Dimension Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
)
[PLACEHOLDER_LOCATION_NAME] => Oxford Canal
[PLACEHOLDER_LOCATION_PREPOSITION] =>
[PLACEHOLDER_EXTRAPAGE_NAME] =>
)
[_count:private] => 19
)
[request] => Waterscape_Request Object
(
[_mapping_path:private] => /canals-and-rivers/oxford-canal/map
[_path:private] => /canals-and-rivers/oxford-canal/map
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => canals-and-rivers/oxford-canal/map
[PHPSESSID] => 5ee41218b41e633b17ec3bf742d1c0f0
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[components] => Waterscape_Util_Hashtable Object
(
[_store:private] => Array
(
[google_map] => Waterscape_Component_Map Object
(
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => OX
[_min_easting:private] => 436144
[_max_easting:private] => 454702
[_min_northing:private] => 206379
[_max_northing:private] => 284658
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Oxford Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/oxford-canal
[_standfirst:protected] => The picturesque Oxford Canal meanders slowly through 77 miles of classic scenery, much of which has barely changed in centuries.
[_description:protected] => The Oxford Canal is one of England's most peaceful waterways, running lazily through the countryside from [/in-your-area/oxfordshire/oxford Oxford] to [/in-your-area/warwickshire/coventry Coventry]. It was briefly the principal waterway from [/in-your-area/london London] to the Midlands, but was superseded soon after construction by the more direct Grand Junction Canal - now the [/canals-and-rivers/grand-union-canal Grand Union].
Consequently, the Oxford Canal has escaped large-scale development and few towns have sprung up on its banks. The southern section is particularly charming and remains largely unaltered.
[_id:protected] => 59
[_url_name] => oxford-canal
)
[_geo_point_mgr:private] =>
[_geo_linestring_mgr:private] =>
[_os_ref_obj:private] =>
[_config:private] => Waterscape_Configuration_Config Object
(
[_xml_doc:private] => SimpleXMLElement Object
(
[application-paths] => SimpleXMLElement Object
(
[path] => Array
(
[0] => /home/waterscape/public_html/waterscape/
[1] => lib/
[2] => var/www/
[3] => var/run/log/
[4] => media/
[5] => var/test/
[6] => var/test/cases/
[7] => var/test/resources/
[8] => var/smarty/
[9] => var/smarty/templates/
[10] => /usr/share/misc/file/magic
)
)
[application-properties] => SimpleXMLElement Object
(
[property] => Array
(
[0] => www.waterscape.com
[1] => editor@waterscape.com
[2] => ABQIAAAADBrEc2bNhMboJ0bBJ2wI4xRvp9RyboS0d78StvLqOsTlN5qkjBQCzLGnvMpYqkEl0uAspKjpWLMgPg
)
)
[application-options] => SimpleXMLElement Object
(
[option] => Array
(
[0] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => devmode
)
[property] => 1
)
[1] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => auth
)
[comment] => SimpleXMLElement Object
(
)
[property] => 3600
)
[2] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => xdebug
)
[property] => Array
(
[0] => 0
[1] => 1
[2] => 1
[3] => /home/waterscape/public_html/waterscape/debug/
)
)
[3] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => pdflib
)
[property] => L700102-010000-117599-YFYEG2-WBFDF2
)
)
)
[database] => SimpleXMLElement Object
(
[@attributes] => Array
(
[default-connection] => waterscape
)
[connection] => Array
(
[0] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => waterscape
)
[driver] => mysql
[hostname] => ws-db
[port] => 3306
[dbname] => waterscape_v2
[username] => waterscape_v2
[password] => d3VeloP375
[persistent] => 1
[buffer-queries] => 1
[errormode] => 2
)
[1] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => bwaterways
)
[driver] => mysql
[hostname] => ws-db
[port] => 3306
[dbname] => bwaterways
[username] => ws_reader
[password] => Wsr34d3r
[persistent] => 1
[buffer-queries] => 1
[errormode] => 2
)
[2] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => waterscape-test
)
[driver] => mysql
[hostname] => ws-db
[port] => 3306
[dbname] => waterscape_test
[username] => waterscape_test
[password] => f15hEsEye
[persistent] => 1
[buffer-queries] => 1
[errormode] => 2
)
[3] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => waterscape-test-paul
)
[driver] => ${database.connection.waterscape-test-paul.driver}
[hostname] => ${database.connection.waterscape-test-paul.hostname}
[port] => ${database.connection.waterscape-test-paul.port}
[dbname] => ${database.connection.waterscape-test-paul.dbname}
[username] => ${database.connection.waterscape-test-paul.username}
[password] => ${database.connection.waterscape-test-paul.password}
[persistent] => 0
[buffer-queries] => 1
[errormode] => 2
)
[4] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => waterscape-no-persistence
)
[driver] => mysql
[hostname] => ws-db
[port] => 3306
[dbname] => waterscape_v2
[username] => waterscape_v2
[password] => d3VeloP375
[persistent] => 0
[buffer-queries] => 1
[errormode] => 2
)
[5] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => bw_reader
)
[driver] => mysql
[hostname] => ws-db
[port] => 3306
[dbname] => waterscape_v2
[username] => bw_reader
[password] => bWr34Der
[persistent] => 1
[buffer-queries] => 1
[errormode] => 2
)
[6] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => waterscape_wp
)
[driver] => mysql
[hostname] => ws-db
[port] => 3306
[dbname] => waterscape_wp
[username] => wp_reader
[password] => w0Rdpre55
[persistent] => 1
[buffer-queries] => 1
[errormode] => 2
)
)
)
[channels] => SimpleXMLElement Object
(
[channel] => Array
(
[0] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => locations
)
[tabname] => in your area
[basepath] => /in-your-area
[position] => 1
)
[1] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => waterways
)
[tabname] => canals & rivers
[basepath] => /canals-and-rivers
[position] => 2
)
[2] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => activities
)
[tabname] => things to to
[basepath] => /things-to-do
[position] => 3
)
[3] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => features
)
[tabname] => features & articles
[basepath] => /features-and-articles
[position] => 4
)
)
)
[socialBookmarks] => SimpleXMLElement Object
(
[@attributes] => Array
(
[implements] => links to social networking sites at the bottom of news, events and features
)
[site] => Array
(
[0] => SimpleXMLElement Object
(
[enabled] => 0
[url] => none
[image] => /media/images/social/dopplr.gif
[name] => Dopplr
[height] => 18
[width] => 88
)
[1] => SimpleXMLElement Object
(
[enabled] => 1
[url] => http://del.icio.us/post?url=%URL
[image] => /media/images/social/del_icio_us.gif
[name] => Delicious
[height] => 18
[width] => 18
)
[2] => SimpleXMLElement Object
(
[enabled] => 1
[url] => http://www.facebook.com/sharer.php?u=%URL
[image] => /media/images/social/facebook.gif
[name] => Facebook
[height] => 18
[width] => 18
)
[3] => SimpleXMLElement Object
(
[enabled] => 1
[url] => http://digg.com/submit?url=%URL
[image] => /media/images/social/digg.gif
[name] => Digg
[height] => 18
[width] => 18
)
[4] => SimpleXMLElement Object
(
[enabled] => 1
[url] => http://www.reddit.com/submit?url=%URL
[image] => /media/images/social/reddit.gif
[name] => reddit
[height] => 18
[width] => 18
)
)
)
[dynamicFooter] => SimpleXMLElement Object
(
[use] => 1
[cache] => 1
[class] => Waterscape_Model_Cache_Db
)
[twitter] => SimpleXMLElement Object
(
[username] => waterscape_com
[pass] => Clarendon64
[ttl] => 60
[count] => 5
)
)
)
[_component_id:protected] => 48
[_parent_id:protected] =>
[_template:protected] => Component/Map.tpl
[_page_id:protected] => 712928
[_view_component_id:protected] => 204
[_instance_name:protected] => google_map
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /canals-and-rivers/oxford-canal/map
[_path:private] => /canals-and-rivers/oxford-canal/map
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => canals-and-rivers/oxford-canal/map
[PHPSESSID] => 5ee41218b41e633b17ec3bf742d1c0f0
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 114
[page_id] => 712928
[view_name] => map_waterway
[title] => Map of %LOCATION_NAME% | Maps | Waterscape.com
[keywords] =>
[description] =>
[layout_template] => Layouts/twocol_contentright_noimgorsearch.tpl
[template] => Page/locations/map.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Waterways
[path] => /canals-and-rivers/oxford-canal/map
[onload] => mapInit();
[location] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => OX
[_min_easting:private] => 436144
[_max_easting:private] => 454702
[_min_northing:private] => 206379
[_max_northing:private] => 284658
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Oxford Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/oxford-canal
[_standfirst:protected] => The picturesque Oxford Canal meanders slowly through 77 miles of classic scenery, much of which has barely changed in centuries.
[_description:protected] => The Oxford Canal is one of England's most peaceful waterways, running lazily through the countryside from [/in-your-area/oxfordshire/oxford Oxford] to [/in-your-area/warwickshire/coventry Coventry]. It was briefly the principal waterway from [/in-your-area/london London] to the Midlands, but was superseded soon after construction by the more direct Grand Junction Canal - now the [/canals-and-rivers/grand-union-canal Grand Union].
Consequently, the Oxford Canal has escaped large-scale development and few towns have sprung up on its banks. The southern section is particularly charming and remains largely unaltered.
[_id:protected] => 59
[_url_name] => oxford-canal
)
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => OX
[_min_easting:private] => 436144
[_max_easting:private] => 454702
[_min_northing:private] => 206379
[_max_northing:private] => 284658
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Oxford Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/oxford-canal
[_standfirst:protected] => The picturesque Oxford Canal meanders slowly through 77 miles of classic scenery, much of which has barely changed in centuries.
[_description:protected] => The Oxford Canal is one of England's most peaceful waterways, running lazily through the countryside from [/in-your-area/oxfordshire/oxford Oxford] to [/in-your-area/warwickshire/coventry Coventry]. It was briefly the principal waterway from [/in-your-area/london London] to the Midlands, but was superseded soon after construction by the more direct Grand Junction Canal - now the [/canals-and-rivers/grand-union-canal Grand Union].
Consequently, the Oxford Canal has escaped large-scale development and few towns have sprung up on its banks. The southern section is particularly charming and remains largely unaltered.
[_id:protected] => 59
[_url_name] => oxford-canal
)
[_na_office_manager:private] => Waterscape_Service_NavigationAuthorityOfficeManager Object
(
[_navigation_authority_office_dao:private] => Waterscape_Dao_NavigationAuthorityOffice Object
(
[_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_navigation_authority_dao:private] => Waterscape_Dao_NavigationAuthority Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
[_stoppage_manager:private] => Waterscape_Service_StoppageManager Object
(
[_stoppage_dao:private] => Waterscape_Dao_Stoppage Object
(
[_waterway_mgr:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion Object
(
[_db:protected] =>
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType Object
(
[_db:protected] =>
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription Object
(
[_db:protected] =>
)
)
[_criteria:private] => Array
(
)
[_raw_criteria:private] =>
[_sql_strings:private] => Array
(
)
[_sql_values:private] => Array
(
)
[_search_data_by:private] => Array
(
[all] => 0
[stoppage] => s
[restriction] => r
[opening_times] => o
[booking_details] => b
[advice] => a
[towpath_closure_only] => t
)
[_str_types_selected:private] =>
[_stoppage_type:private] =>
[_db:protected] =>
)
)
[_route_manager:private] => Waterscape_Service_RouteManager Object
(
[_route_dao:private] => Waterscape_Dao_Route Object
(
[_route_type_manager:private] => Waterscape_Service_RouteTypeManager Object
(
[_route_type_dao:private] => Waterscape_Dao_RouteType Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
[_waypoint_manager:private] => Waterscape_Service_WaypointManager Object
(
[_waypoint_dao:private] => Waterscape_Dao_Waypoint Object
(
[_metadata_mgr:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_geo_point_mgr:private] =>
[_geo_data_type_manager:private] => Waterscape_Service_GeoDataTypeManager Object
(
[_geo_data_dao:private] => Waterscape_Dao_GeoDataType Object
(
[_db:protected] =>
)
)
[_db:protected] =>
[_geo_point_manager] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] =>
)
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
)
[_media_manager:private] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
[_db:protected] =>
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
)
[_rating_manager:private] => Waterscape_Service_RouteRatingManager Object
(
[_route_rating_dao:private] => Waterscape_Dao_RouteRating Object
(
[_db:protected] =>
)
)
[_metadata_manager:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
)
[_view_manager:private] => Waterscape_Service_ViewManager Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
[_business_manager:private] => Waterscape_Service_BusinessManager Object
(
[_business_dao:private] => Waterscape_Dao_Business Object
(
[_address_manager:protected] => Waterscape_Service_StreetAddressManager Object
(
[_street_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
)
[_metadata_manager:protected] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_attribute_manager:protected] => Waterscape_Service_AttributeManager Object
(
[_attribute_dao:private] => Waterscape_Dao_Attribute Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_category_manager:protected] => Waterscape_Service_CategoryManager Object
(
[_category_dao:private] => Waterscape_Dao_Category Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_section_manager:protected] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_location_manager:protected] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_media_manager:protected] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
[_db:protected] =>
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
)
[_db:protected] =>
)
)
[_menu_id:protected] =>
[_menu_items:protected] =>
[_display_class:protected] =>
[_html_class:protected] =>
[_html_id:protected] =>
[_menu_components:protected] =>
[_page_manager:protected] => Waterscape_Service_PageManager Object
(
[_page_dao:private] => Waterscape_Dao_Page Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_view_manager:private] => Waterscape_Service_ViewManager Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
)
[_location_manager:protected] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_component_id:protected] => 12
[_parent_id:protected] =>
[_template:protected] => Component/LocationNavigationMenu.tpl
[_page_id:protected] =>
[_view_component_id:protected] =>
[_instance_name:protected] =>
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /canals-and-rivers/oxford-canal/map
[_path:private] => /canals-and-rivers/oxford-canal/map
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => canals-and-rivers/oxford-canal/map
[PHPSESSID] => 5ee41218b41e633b17ec3bf742d1c0f0
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] =>
[_dimension_manager] => Waterscape_Service_DimensionManager Object
(
[_dimension_dao:private] => Waterscape_Dao_Dimension Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
)
[PLACEHOLDER_LOCATION_NAME] => Oxford Canal
[PLACEHOLDER_LOCATION_PREPOSITION] =>
[PLACEHOLDER_EXTRAPAGE_NAME] =>
)
[_count:private] => 19
)
)
[breadcrumbs] => Waterscape_Component_Breadcrumb Object
(
[_view:private] => Waterscape_Model_View Object
(
[_name:private] => map_waterway
[_path:private] => /canals-and-rivers/*/map
[_web_title:private] => Map of %LOCATION_NAME% | Maps | Waterscape.com
[_web_description:private] => Map showing the route of %LOCATION_NAME% by Waterscape.com
[_web_keywords:private] => Map of %LOCATION_NAME%, Maps, Waterscape.com
[_is_published:private] => 1
[_layout_template:private] => Layouts/twocol_contentright_noimgorsearch.tpl
[_template:private] => Page/locations/map.tpl
[_metadata:private] => Waterscape_Model_Metadata Object
(
[_title:private] => Map of %LOCATION_NAME% | Maps | Waterscape.com
[_description:private] => Map of %LOCATION_NAME%
[_keywords:private] => Map of %LOCATION_NAME%, Maps, Waterscape.com
[_alt_text:private] =>
[_author:private] =>
[_language:private] => en-GB
[_source:private] =>
[_relation:private] =>
[_format:private] =>
[_identifier:private] =>
[_publisher:private] =>
[_coverage:private] =>
[_rights:private] =>
[_contributor:private] =>
[_easting:private] => 0
[_northing:private] => 0
[_created:private] => 2007-10-08 01:08:04
[_updated:private] => 2008-10-21 16:28:23
[_indexed:private] =>
[_geo_data_id:private] =>
[_geo_data_type:private] => point
[_id:protected] => 43450
)
[_nav_name:private] =>
[_nav_priority:private] => 0
[_is_application_handler:private] =>
[_request:private] => Waterscape_Request Object
(
[_mapping_path:private] => /canals-and-rivers/oxford-canal/map
[_path:private] => /canals-and-rivers/oxford-canal/map
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => canals-and-rivers/oxford-canal/map
[PHPSESSID] => 5ee41218b41e633b17ec3bf742d1c0f0
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:private] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 114
[page_id] => 712928
[view_name] => map_waterway
[title] => Map of %LOCATION_NAME% | Maps | Waterscape.com
[keywords] =>
[description] =>
[layout_template] => Layouts/twocol_contentright_noimgorsearch.tpl
[template] => Page/locations/map.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Waterways
[path] => /canals-and-rivers/oxford-canal/map
[onload] => mapInit();
[location] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => OX
[_min_easting:private] => 436144
[_max_easting:private] => 454702
[_min_northing:private] => 206379
[_max_northing:private] => 284658
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Oxford Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/oxford-canal
[_standfirst:protected] => The picturesque Oxford Canal meanders slowly through 77 miles of classic scenery, much of which has barely changed in centuries.
[_description:protected] => The Oxford Canal is one of England's most peaceful waterways, running lazily through the countryside from [/in-your-area/oxfordshire/oxford Oxford] to [/in-your-area/warwickshire/coventry Coventry]. It was briefly the principal waterway from [/in-your-area/london London] to the Midlands, but was superseded soon after construction by the more direct Grand Junction Canal - now the [/canals-and-rivers/grand-union-canal Grand Union].
Consequently, the Oxford Canal has escaped large-scale development and few towns have sprung up on its banks. The southern section is particularly charming and remains largely unaltered.
[_id:protected] => 59
[_url_name] => oxford-canal
)
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => OX
[_min_easting:private] => 436144
[_max_easting:private] => 454702
[_min_northing:private] => 206379
[_max_northing:private] => 284658
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Oxford Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/oxford-canal
[_standfirst:protected] => The picturesque Oxford Canal meanders slowly through 77 miles of classic scenery, much of which has barely changed in centuries.
[_description:protected] => The Oxford Canal is one of England's most peaceful waterways, running lazily through the countryside from [/in-your-area/oxfordshire/oxford Oxford] to [/in-your-area/warwickshire/coventry Coventry]. It was briefly the principal waterway from [/in-your-area/london London] to the Midlands, but was superseded soon after construction by the more direct Grand Junction Canal - now the [/canals-and-rivers/grand-union-canal Grand Union].
Consequently, the Oxford Canal has escaped large-scale development and few towns have sprung up on its banks. The southern section is particularly charming and remains largely unaltered.
[_id:protected] => 59
[_url_name] => oxford-canal
)
[_na_office_manager:private] => Waterscape_Service_NavigationAuthorityOfficeManager Object
(
[_navigation_authority_office_dao:private] => Waterscape_Dao_NavigationAuthorityOffice Object
(
[_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_navigation_authority_dao:private] => Waterscape_Dao_NavigationAuthority Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
[_stoppage_manager:private] => Waterscape_Service_StoppageManager Object
(
[_stoppage_dao:private] => Waterscape_Dao_Stoppage Object
(
[_waterway_mgr:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion Object
(
[_db:protected] =>
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType Object
(
[_db:protected] =>
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription Object
(
[_db:protected] =>
)
)
[_criteria:private] => Array
(
)
[_raw_criteria:private] =>
[_sql_strings:private] => Array
(
)
[_sql_values:private] => Array
(
)
[_search_data_by:private] => Array
(
[all] => 0
[stoppage] => s
[restriction] => r
[opening_times] => o
[booking_details] => b
[advice] => a
[towpath_closure_only] => t
)
[_str_types_selected:private] =>
[_stoppage_type:private] =>
[_db:protected] =>
)
)
[_route_manager:private] => Waterscape_Service_RouteManager Object
(
[_route_dao:private] => Waterscape_Dao_Route Object
(
[_route_type_manager:private] => Waterscape_Service_RouteTypeManager Object
(
[_route_type_dao:private] => Waterscape_Dao_RouteType Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
[_waypoint_manager:private] => Waterscape_Service_WaypointManager Object
(
[_waypoint_dao:private] => Waterscape_Dao_Waypoint Object
(
[_metadata_mgr:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_geo_point_mgr:private] =>
[_geo_data_type_manager:private] => Waterscape_Service_GeoDataTypeManager Object
(
[_geo_data_dao:private] => Waterscape_Dao_GeoDataType Object
(
[_db:protected] =>
)
)
[_db:protected] =>
[_geo_point_manager] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] =>
)
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
)
[_media_manager:private] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
[_db:protected] =>
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
)
[_rating_manager:private] => Waterscape_Service_RouteRatingManager Object
(
[_route_rating_dao:private] => Waterscape_Dao_RouteRating Object
(
[_db:protected] =>
)
)
[_metadata_manager:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
)
[_view_manager:private] => Waterscape_Service_ViewManager Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
[_business_manager:private] => Waterscape_Service_BusinessManager Object
(
[_business_dao:private] => Waterscape_Dao_Business Object
(
[_address_manager:protected] => Waterscape_Service_StreetAddressManager Object
(
[_street_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
)
[_metadata_manager:protected] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_attribute_manager:protected] => Waterscape_Service_AttributeManager Object
(
[_attribute_dao:private] => Waterscape_Dao_Attribute Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_category_manager:protected] => Waterscape_Service_CategoryManager Object
(
[_category_dao:private] => Waterscape_Dao_Category Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_section_manager:protected] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_location_manager:protected] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_media_manager:protected] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
[_db:protected] =>
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
)
[_db:protected] =>
)
)
[_menu_id:protected] =>
[_menu_items:protected] =>
[_display_class:protected] =>
[_html_class:protected] =>
[_html_id:protected] =>
[_menu_components:protected] =>
[_page_manager:protected] => Waterscape_Service_PageManager Object
(
[_page_dao:private] => Waterscape_Dao_Page Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_view_manager:private] => Waterscape_Service_ViewManager Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
)
[_location_manager:protected] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[13] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[23] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 29
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_component_id:protected] => 12
[_parent_id:protected] =>
[_template:protected] => Component/LocationNavigationMenu.tpl
[_page_id:protected] =>
[_view_component_id:protected] =>
[_instance_name:protected] =>
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /canals-and-rivers/oxford-canal/map
[_path:private] => /canals-and-rivers/oxford-canal/map
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => canals-and-rivers/oxford-canal/map
[PHPSESSID] => 5ee41218b41e633b17ec3bf742d1c0f0
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] =>
[_dimension_manager] => Waterscape_Service_DimensionManager Object
(
[_dimension_dao:private] => Waterscape_Dao_Dimension Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
)
[PLACEHOLDER_LOCATION_NAME] => Oxford Canal
[PLACEHOLDER_LOCATION_PREPOSITION] =>
[PLACEHOLDER_EXTRAPAGE_NAME] =>
)
[_count:private] => 19
)
[_components:private] => Waterscape_Util_Hashtable Object
*RECURSION*
[_id:protected] => 114
[_command_class] => Waterscape_Controller_Waterways
[_page_id] => 712928
)
[_component_id:protected] => 8
[_parent_id:protected] =>
[_template:protected] => Component/Breadcrumb.tpl
[_page_id:protected] =>
[_view_component_id:protected] =>
[_instance_name:protected] =>
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /canals-and-rivers/oxford-canal/map
[_path:private] => /canals-and-rivers/oxford-canal/map
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => canals-and-rivers/oxford-canal/map
[PHPSESSID] => 5ee41218b41e633b17ec3bf742d1c0f0
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 114
[page_id] => 712928
[view_name] => map_waterway
[title] => Map of %LOCATION_NAME% | Maps | Waterscape.com
[keywords] =>
[description] =>
[layout_template] => Layouts/twocol_contentright_noimgorsearch.tpl
[template] => Page/locations/map.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Waterways
[path] => /canals-and-rivers/oxford-canal/map
[onload] => mapInit();
[location] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => OX
[_min_easting:private] => 436144
[_max_easting:private] => 454702
[_min_northing:private] => 206379
[_max_northing:private] => 284658
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Oxford Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/oxford-canal
[_standfirst:protected] => The picturesque Oxford Canal meanders slowly through 77 miles of classic scenery, much of which has barely changed in centuries.
[_description:protected] => The Oxford Canal is one of England's most peaceful waterways, running lazily through the countryside from [/in-your-area/oxfordshire/oxford Oxford] to [/in-your-area/warwickshire/coventry Coventry]. It was briefly the principal waterway from [/in-your-area/london London] to the Midlands, but was superseded soon after construction by the more direct Grand Junction Canal - now the [/canals-and-rivers/grand-union-canal Grand Union].
Consequently, the Oxford Canal has escaped large-scale development and few towns have sprung up on its banks. The southern section is particularly charming and remains largely unaltered.
[_id:protected] => 59
[_url_name] => oxford-canal
)
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => OX
[_min_easting:private] => 436144
[_max_easting:private] => 454702
[_min_northing:private] => 206379
[_max_northing:private] => 284658
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Oxford Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/oxford-canal
[_standfirst:protected] => The picturesque Oxford Canal meanders slowly through 77 miles of classic scenery, much of which has barely changed in centuries.
[_description:protected] => The Oxford Canal is one of England's most peaceful waterways, running lazily through the countryside from [/in-your-area/oxfordshire/oxford Oxford] to [/in-your-area/warwickshire/coventry Coventry]. It was briefly the principal waterway from [/in-your-area/london London] to the Midlands, but was superseded soon after construction by the more direct Grand Junction Canal - now the [/canals-and-rivers/grand-union-canal Grand Union].
Consequently, the Oxford Canal has escaped large-scale development and few towns have sprung up on its banks. The southern section is particularly charming and remains largely unaltered.
[_id:protected] => 59
[_url_name] => oxford-canal
)
[_na_office_manager:private] => Waterscape_Service_NavigationAuthorityOfficeManager Object
(
[_navigation_authority_office_dao:private] => Waterscape_Dao_NavigationAuthorityOffice Object
(
[_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_navigation_authority_dao:private] => Waterscape_Dao_NavigationAuthority Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
[_stoppage_manager:private] => Waterscape_Service_StoppageManager Object
(
[_stoppage_dao:private] => Waterscape_Dao_Stoppage Object
(
[_waterway_mgr:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)