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 of %LOCATION_NAME%
[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] => 2007-10-08 01:08:04
[_indexed:private] =>
[_geo_data_id:private] =>
[_geo_data_type:private] => point
[_id:protected] => 43447
)
[response] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 113
[page_id] => 1909
[view_name] => map_location
[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_Locations
[path] => /in-your-area/warwickshire/birmingham/map
[onload] => mapInit();
[google_map_key] => ABQIAAAADBrEc2bNhMboJ0bBJ2wI4xRvp9RyboS0d78StvLqOsTlN5qkjBQCzLGnvMpYqkEl0uAspKjpWLMgPg
[location] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 405756
[y] => 285434
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20743
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 31
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 387697
[_min_northing:private] => 297693
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 426980
[_centre_northing:private] => 266040
[_name:protected] => Warwickshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire
[_standfirst:protected] => Home of the Bard, Warwickshire is also renowned for its numerous waterways and scenic cruising.
[_description:protected] => [/in-your-area/warwickshire/birmingham Birmingham] is commonly known as the canal capital of the UK, but the waterway interest doesn’t finish at the city limits. Some of Britain’s most interesting rivers and canals wind through rural Warwickshire – and there’s a multitude of attractions and events to keep you occupied on dry land too.
[_id:protected] => 23
[_url_name] => warwickshire
)
[_easting:protected] => 405756
[_northing:protected] => 285434
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Birmingham
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire/birmingham
[_standfirst:protected] => Britain’s canal capital
[_description:protected] => Birmingham’s canals add green space and vibrancy to Britain’s second city. Take to the towpaths and enjoy a gloriously traffic-free journey to work - or find your own green shortcut through the centre and beat the crowds to the bars of [/in-your-area/warwickshire/places-to-go/649/brindleyplace Brindleyplace]. Follow our scenic canals to discover the best of Birmingham.
**Walking to work in Birmingham**
The [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] carves a green corridor past the university and the leafy streets of Edgbaston to the offices and shops near Broad Street. Why not swap the queuing traffic on the Bristol Road for a scenic stroll to work along the canal? Or get off the bus early and take to the towpath for your government recommended 20 minutes of exercise with a power-walk to the office. Handy canalside cafes can even provide that essential morning coffee en-route.
Commuting? Sidestep the suited throngs and enjoy a waterside walk from New Street Station: the [/canals-and-rivers/birmingham-and-fazeley-canal Birmingham & Fazeley Canal] is a peaceful pathway to St Paul’s Square and the ICC. And remember, the best thing about towpath walking is that you’ll never take the wrong turning.
**Canalside eating, drinking and shopping**
Birmingham is a fantastic place to shop – and to recuperate in a friendly bar afterwards. But if the crowds of Corporation Street get too much to bear, remember that the Midlands’ answer to Bond Street, the [/in-your-area/warwickshire/places-to-go/298/mailbox Mailbox], is just a short stroll along the Worcester & Birmingham Canal. Looking for something special? The famous Jewellery Quarter has produced beautiful rings, gems and trinkets on the banks of the Birmingham & Fazeley Canal for over 200 years.
And after all that shopping you’ll need a bite to eat. Between Brindleyplace, [/in-your-area/warwickshire/places-to-go/185/gas-street-basin Gas Street Basin] and Broad Street, Birmingham boasts countless canalside pubs, bars, cafes and restaurants where you can enjoy a quick snack, an after-work drink or a romantic dinner a deux. Find out more with our [http://www.waterscape.com/eatingdrinking/ eating and drinking pages].
**Days out by the canal**
Calling all chocoholics. The famous [/in-your-area/warwickshire/places-to-go/85/cadbury-world Cadbury World] offers a great (and tasty) day out for all the family – and any calories accidentally imbibed on the tour can be worked off with a walk along the Worcester & Birmingham Canal afterwards. Elsewhere, the [/in-your-area/warwickshire/places-to-go/336/national-sea-life-centre National Sea Life Centre] is enduringly popular in the heart of Brindleyplace and with galleries, historic houses, theatres and canal architecture all just a short drive away – you’re sure to find an outing to suit in waterside Birmingham.
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[_id:protected] => 2
[_url_name] => birmingham
)
[preposition] => near
[section] => map
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 405756
[y] => 285434
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20743
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 31
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 387697
[_min_northing:private] => 297693
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 426980
[_centre_northing:private] => 266040
[_name:protected] => Warwickshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire
[_standfirst:protected] => Home of the Bard, Warwickshire is also renowned for its numerous waterways and scenic cruising.
[_description:protected] => [/in-your-area/warwickshire/birmingham Birmingham] is commonly known as the canal capital of the UK, but the waterway interest doesn’t finish at the city limits. Some of Britain’s most interesting rivers and canals wind through rural Warwickshire – and there’s a multitude of attractions and events to keep you occupied on dry land too.
[_id:protected] => 23
[_url_name] => warwickshire
)
[_easting:protected] => 405756
[_northing:protected] => 285434
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Birmingham
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire/birmingham
[_standfirst:protected] => Britain’s canal capital
[_description:protected] => Birmingham’s canals add green space and vibrancy to Britain’s second city. Take to the towpaths and enjoy a gloriously traffic-free journey to work - or find your own green shortcut through the centre and beat the crowds to the bars of [/in-your-area/warwickshire/places-to-go/649/brindleyplace Brindleyplace]. Follow our scenic canals to discover the best of Birmingham.
**Walking to work in Birmingham**
The [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] carves a green corridor past the university and the leafy streets of Edgbaston to the offices and shops near Broad Street. Why not swap the queuing traffic on the Bristol Road for a scenic stroll to work along the canal? Or get off the bus early and take to the towpath for your government recommended 20 minutes of exercise with a power-walk to the office. Handy canalside cafes can even provide that essential morning coffee en-route.
Commuting? Sidestep the suited throngs and enjoy a waterside walk from New Street Station: the [/canals-and-rivers/birmingham-and-fazeley-canal Birmingham & Fazeley Canal] is a peaceful pathway to St Paul’s Square and the ICC. And remember, the best thing about towpath walking is that you’ll never take the wrong turning.
**Canalside eating, drinking and shopping**
Birmingham is a fantastic place to shop – and to recuperate in a friendly bar afterwards. But if the crowds of Corporation Street get too much to bear, remember that the Midlands’ answer to Bond Street, the [/in-your-area/warwickshire/places-to-go/298/mailbox Mailbox], is just a short stroll along the Worcester & Birmingham Canal. Looking for something special? The famous Jewellery Quarter has produced beautiful rings, gems and trinkets on the banks of the Birmingham & Fazeley Canal for over 200 years.
And after all that shopping you’ll need a bite to eat. Between Brindleyplace, [/in-your-area/warwickshire/places-to-go/185/gas-street-basin Gas Street Basin] and Broad Street, Birmingham boasts countless canalside pubs, bars, cafes and restaurants where you can enjoy a quick snack, an after-work drink or a romantic dinner a deux. Find out more with our [http://www.waterscape.com/eatingdrinking/ eating and drinking pages].
**Days out by the canal**
Calling all chocoholics. The famous [/in-your-area/warwickshire/places-to-go/85/cadbury-world Cadbury World] offers a great (and tasty) day out for all the family – and any calories accidentally imbibed on the tour can be worked off with a walk along the Worcester & Birmingham Canal afterwards. Elsewhere, the [/in-your-area/warwickshire/places-to-go/336/national-sea-life-centre National Sea Life Centre] is enduringly popular in the heart of Brindleyplace and with galleries, historic houses, theatres and canal architecture all just a short drive away – you’re sure to find an outing to suit in waterside Birmingham.
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[_id:protected] => 2
[_url_name] => birmingham
)
[_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] => 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_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] =>
)
)
[_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] =>
)
)
[_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] => 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_geo_point_mgr:private] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_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] =>
)
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_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] => 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_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] => 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway 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] => 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_geo_point_mgr:private] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
)
[_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] => 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway 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] => 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_geo_point_mgr:private] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_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] =>
[_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] => /in-your-area/warwickshire/birmingham/map
[_path:private] => /in-your-area/warwickshire/birmingham/map
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/warwickshire/birmingham/map
[PHPSESSID] => d337fbe420d5825cac5f41ac75c53cdc
[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_PAGE_NUM] => map
[PLACEHOLDER_LOCATION_COUNTY_NAME] => Warwickshire
[PLACEHOLDER_LOCATION_NAME] => Birmingham
[PLACEHOLDER_LOCATION_PREPOSITION] => near
)
[_count:private] => 23
)
[request] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/warwickshire/birmingham/map
[_path:private] => /in-your-area/warwickshire/birmingham/map
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/warwickshire/birmingham/map
[PHPSESSID] => d337fbe420d5825cac5f41ac75c53cdc
[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_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 405756
[y] => 285434
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20743
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 31
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 387697
[_min_northing:private] => 297693
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 426980
[_centre_northing:private] => 266040
[_name:protected] => Warwickshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire
[_standfirst:protected] => Home of the Bard, Warwickshire is also renowned for its numerous waterways and scenic cruising.
[_description:protected] => [/in-your-area/warwickshire/birmingham Birmingham] is commonly known as the canal capital of the UK, but the waterway interest doesn’t finish at the city limits. Some of Britain’s most interesting rivers and canals wind through rural Warwickshire – and there’s a multitude of attractions and events to keep you occupied on dry land too.
[_id:protected] => 23
[_url_name] => warwickshire
)
[_easting:protected] => 405756
[_northing:protected] => 285434
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Birmingham
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire/birmingham
[_standfirst:protected] => Britain’s canal capital
[_description:protected] => Birmingham’s canals add green space and vibrancy to Britain’s second city. Take to the towpaths and enjoy a gloriously traffic-free journey to work - or find your own green shortcut through the centre and beat the crowds to the bars of [/in-your-area/warwickshire/places-to-go/649/brindleyplace Brindleyplace]. Follow our scenic canals to discover the best of Birmingham.
**Walking to work in Birmingham**
The [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] carves a green corridor past the university and the leafy streets of Edgbaston to the offices and shops near Broad Street. Why not swap the queuing traffic on the Bristol Road for a scenic stroll to work along the canal? Or get off the bus early and take to the towpath for your government recommended 20 minutes of exercise with a power-walk to the office. Handy canalside cafes can even provide that essential morning coffee en-route.
Commuting? Sidestep the suited throngs and enjoy a waterside walk from New Street Station: the [/canals-and-rivers/birmingham-and-fazeley-canal Birmingham & Fazeley Canal] is a peaceful pathway to St Paul’s Square and the ICC. And remember, the best thing about towpath walking is that you’ll never take the wrong turning.
**Canalside eating, drinking and shopping**
Birmingham is a fantastic place to shop – and to recuperate in a friendly bar afterwards. But if the crowds of Corporation Street get too much to bear, remember that the Midlands’ answer to Bond Street, the [/in-your-area/warwickshire/places-to-go/298/mailbox Mailbox], is just a short stroll along the Worcester & Birmingham Canal. Looking for something special? The famous Jewellery Quarter has produced beautiful rings, gems and trinkets on the banks of the Birmingham & Fazeley Canal for over 200 years.
And after all that shopping you’ll need a bite to eat. Between Brindleyplace, [/in-your-area/warwickshire/places-to-go/185/gas-street-basin Gas Street Basin] and Broad Street, Birmingham boasts countless canalside pubs, bars, cafes and restaurants where you can enjoy a quick snack, an after-work drink or a romantic dinner a deux. Find out more with our [http://www.waterscape.com/eatingdrinking/ eating and drinking pages].
**Days out by the canal**
Calling all chocoholics. The famous [/in-your-area/warwickshire/places-to-go/85/cadbury-world Cadbury World] offers a great (and tasty) day out for all the family – and any calories accidentally imbibed on the tour can be worked off with a walk along the Worcester & Birmingham Canal afterwards. Elsewhere, the [/in-your-area/warwickshire/places-to-go/336/national-sea-life-centre National Sea Life Centre] is enduringly popular in the heart of Brindleyplace and with galleries, historic houses, theatres and canal architecture all just a short drive away – you’re sure to find an outing to suit in waterside Birmingham.
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[_id:protected] => 2
[_url_name] => birmingham
)
[_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] => 1909
[_view_component_id:protected] => 203
[_instance_name:protected] => google_map
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/warwickshire/birmingham/map
[_path:private] => /in-your-area/warwickshire/birmingham/map
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/warwickshire/birmingham/map
[PHPSESSID] => d337fbe420d5825cac5f41ac75c53cdc
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 113
[page_id] => 1909
[view_name] => map_location
[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_Locations
[path] => /in-your-area/warwickshire/birmingham/map
[onload] => mapInit();
[google_map_key] => ABQIAAAADBrEc2bNhMboJ0bBJ2wI4xRvp9RyboS0d78StvLqOsTlN5qkjBQCzLGnvMpYqkEl0uAspKjpWLMgPg
[location] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 405756
[y] => 285434
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20743
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 31
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 387697
[_min_northing:private] => 297693
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 426980
[_centre_northing:private] => 266040
[_name:protected] => Warwickshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire
[_standfirst:protected] => Home of the Bard, Warwickshire is also renowned for its numerous waterways and scenic cruising.
[_description:protected] => [/in-your-area/warwickshire/birmingham Birmingham] is commonly known as the canal capital of the UK, but the waterway interest doesn’t finish at the city limits. Some of Britain’s most interesting rivers and canals wind through rural Warwickshire – and there’s a multitude of attractions and events to keep you occupied on dry land too.
[_id:protected] => 23
[_url_name] => warwickshire
)
[_easting:protected] => 405756
[_northing:protected] => 285434
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Birmingham
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire/birmingham
[_standfirst:protected] => Britain’s canal capital
[_description:protected] => Birmingham’s canals add green space and vibrancy to Britain’s second city. Take to the towpaths and enjoy a gloriously traffic-free journey to work - or find your own green shortcut through the centre and beat the crowds to the bars of [/in-your-area/warwickshire/places-to-go/649/brindleyplace Brindleyplace]. Follow our scenic canals to discover the best of Birmingham.
**Walking to work in Birmingham**
The [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] carves a green corridor past the university and the leafy streets of Edgbaston to the offices and shops near Broad Street. Why not swap the queuing traffic on the Bristol Road for a scenic stroll to work along the canal? Or get off the bus early and take to the towpath for your government recommended 20 minutes of exercise with a power-walk to the office. Handy canalside cafes can even provide that essential morning coffee en-route.
Commuting? Sidestep the suited throngs and enjoy a waterside walk from New Street Station: the [/canals-and-rivers/birmingham-and-fazeley-canal Birmingham & Fazeley Canal] is a peaceful pathway to St Paul’s Square and the ICC. And remember, the best thing about towpath walking is that you’ll never take the wrong turning.
**Canalside eating, drinking and shopping**
Birmingham is a fantastic place to shop – and to recuperate in a friendly bar afterwards. But if the crowds of Corporation Street get too much to bear, remember that the Midlands’ answer to Bond Street, the [/in-your-area/warwickshire/places-to-go/298/mailbox Mailbox], is just a short stroll along the Worcester & Birmingham Canal. Looking for something special? The famous Jewellery Quarter has produced beautiful rings, gems and trinkets on the banks of the Birmingham & Fazeley Canal for over 200 years.
And after all that shopping you’ll need a bite to eat. Between Brindleyplace, [/in-your-area/warwickshire/places-to-go/185/gas-street-basin Gas Street Basin] and Broad Street, Birmingham boasts countless canalside pubs, bars, cafes and restaurants where you can enjoy a quick snack, an after-work drink or a romantic dinner a deux. Find out more with our [http://www.waterscape.com/eatingdrinking/ eating and drinking pages].
**Days out by the canal**
Calling all chocoholics. The famous [/in-your-area/warwickshire/places-to-go/85/cadbury-world Cadbury World] offers a great (and tasty) day out for all the family – and any calories accidentally imbibed on the tour can be worked off with a walk along the Worcester & Birmingham Canal afterwards. Elsewhere, the [/in-your-area/warwickshire/places-to-go/336/national-sea-life-centre National Sea Life Centre] is enduringly popular in the heart of Brindleyplace and with galleries, historic houses, theatres and canal architecture all just a short drive away – you’re sure to find an outing to suit in waterside Birmingham.
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[_id:protected] => 2
[_url_name] => birmingham
)
[preposition] => near
[section] => map
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 405756
[y] => 285434
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20743
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 31
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 387697
[_min_northing:private] => 297693
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 426980
[_centre_northing:private] => 266040
[_name:protected] => Warwickshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire
[_standfirst:protected] => Home of the Bard, Warwickshire is also renowned for its numerous waterways and scenic cruising.
[_description:protected] => [/in-your-area/warwickshire/birmingham Birmingham] is commonly known as the canal capital of the UK, but the waterway interest doesn’t finish at the city limits. Some of Britain’s most interesting rivers and canals wind through rural Warwickshire – and there’s a multitude of attractions and events to keep you occupied on dry land too.
[_id:protected] => 23
[_url_name] => warwickshire
)
[_easting:protected] => 405756
[_northing:protected] => 285434
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Birmingham
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire/birmingham
[_standfirst:protected] => Britain’s canal capital
[_description:protected] => Birmingham’s canals add green space and vibrancy to Britain’s second city. Take to the towpaths and enjoy a gloriously traffic-free journey to work - or find your own green shortcut through the centre and beat the crowds to the bars of [/in-your-area/warwickshire/places-to-go/649/brindleyplace Brindleyplace]. Follow our scenic canals to discover the best of Birmingham.
**Walking to work in Birmingham**
The [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] carves a green corridor past the university and the leafy streets of Edgbaston to the offices and shops near Broad Street. Why not swap the queuing traffic on the Bristol Road for a scenic stroll to work along the canal? Or get off the bus early and take to the towpath for your government recommended 20 minutes of exercise with a power-walk to the office. Handy canalside cafes can even provide that essential morning coffee en-route.
Commuting? Sidestep the suited throngs and enjoy a waterside walk from New Street Station: the [/canals-and-rivers/birmingham-and-fazeley-canal Birmingham & Fazeley Canal] is a peaceful pathway to St Paul’s Square and the ICC. And remember, the best thing about towpath walking is that you’ll never take the wrong turning.
**Canalside eating, drinking and shopping**
Birmingham is a fantastic place to shop – and to recuperate in a friendly bar afterwards. But if the crowds of Corporation Street get too much to bear, remember that the Midlands’ answer to Bond Street, the [/in-your-area/warwickshire/places-to-go/298/mailbox Mailbox], is just a short stroll along the Worcester & Birmingham Canal. Looking for something special? The famous Jewellery Quarter has produced beautiful rings, gems and trinkets on the banks of the Birmingham & Fazeley Canal for over 200 years.
And after all that shopping you’ll need a bite to eat. Between Brindleyplace, [/in-your-area/warwickshire/places-to-go/185/gas-street-basin Gas Street Basin] and Broad Street, Birmingham boasts countless canalside pubs, bars, cafes and restaurants where you can enjoy a quick snack, an after-work drink or a romantic dinner a deux. Find out more with our [http://www.waterscape.com/eatingdrinking/ eating and drinking pages].
**Days out by the canal**
Calling all chocoholics. The famous [/in-your-area/warwickshire/places-to-go/85/cadbury-world Cadbury World] offers a great (and tasty) day out for all the family – and any calories accidentally imbibed on the tour can be worked off with a walk along the Worcester & Birmingham Canal afterwards. Elsewhere, the [/in-your-area/warwickshire/places-to-go/336/national-sea-life-centre National Sea Life Centre] is enduringly popular in the heart of Brindleyplace and with galleries, historic houses, theatres and canal architecture all just a short drive away – you’re sure to find an outing to suit in waterside Birmingham.
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[_id:protected] => 2
[_url_name] => birmingham
)
[_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] => 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_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] =>
)
)
[_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] =>
)
)
[_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] => 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_geo_point_mgr:private] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_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] =>
)
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_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] => 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_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] => 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway 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] => 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_geo_point_mgr:private] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint 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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)
[queryCounter] => 35
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => 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 = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[19] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
)