Cycling along the Walsall Canal
Cycling is permitted along the whole length of the Walsall Canal. You will need to follow the Waterways Code for Cyclists and obtain a cycling permit. A British Waterways cycling permit can be downloaded free of charge.
Do not speed: the grass path surface may be rutted in places. Please note that the adjacent Ridgeacre Branch is not suitable for cycling.
Cycling routes
Towpath Stoppages
15 Mar 2010 - 23 Apr 2010
Towpath Closure only: Bentley Bridge Ramp
Associated Regional Office: West Midlands WaterwaysUPDATE (01 March 2010): Due to unforeseen circumstances the ramp closure has been postponed until 15/03/2010.
British Waterways apologises for any inconvenience caused
The towpath access ramp will be closed to enable Contractors to construct a new access ramp and associated works. Boat traffic will be able to pass at all times but proceed with caution.
British Waterways apologises for any inconvenience caused.
(Enquiries: 01827 252000)
31 Mar 2010 - 07 Apr 2010
Towpath Closure only: Bentley Road Bridge
Associated Regional Office: West Midlands WaterwaysUPDATE (01 March 2010): Due to unforeseen circumstances the towpath closure has been postponed until 31/03/2010.
British Waterways apologises for any inconvenience caused.
The towpath will be closed between Bughole Bridge and James Bridge Aqueduct to enable Central Networks to carry out essential electrical cable works at Bentley Road Bridge.
British Waterways apologises for any inconvenience caused.
(Enquiries: 01827 252000)
PDOException Object
(
[message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.nationwide' in 'where clause'
[string:private] =>
[code:protected] => 42S22
[file:protected] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line:protected] => 53
[trace:private] => Array
(
[0] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 53
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 16
[function] => getUnlimitedQueryRowCount
[class] => Waterscape_Database_RecordSet_Paged
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
[1] => Array
(
)
)
)
[2] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database.php
[line] => 136
[function] => __construct
[class] => Waterscape_Database_RecordSet_Paged
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
[1] => Array
(
)
[2] => 1
[3] => 9
)
)
[3] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Directory/Finder/Abstract.php
[line] => 62
[function] => getPagedRecordSet
[class] => Waterscape_Database
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
[1] => 1
[2] => 9
)
)
[4] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 133
[function] => find
[class] => Waterscape_Directory_Finder_Abstract
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 7
[_name:protected] => Cycling
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => WS
[_min_easting:private] => 396461
[_max_easting:private] => 401025
[_min_northing:private] => 291654
[_max_northing:private] => 298647
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => UNKNOWN
[_min_easting:private] => 382875
[_max_easting:private] => 420475
[_min_northing:private] => 304050
[_max_northing:private] => 276950
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => BCN
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/bcn
[_standfirst:protected] => Does [/in-your-area/warwickshire/birmingham Birmingham] really have more miles of canal than Venice?
[_description:protected] => The exact numbers depend on where you draw the city boundaries, but the whole Birmingham Canal Navigations system extends for 100 miles in total. It is one of the most intricate canal networks in the world.
These waterways converge at the city centre bustle of [/in-your-area/warwickshire/places-to-go/185/gas-street-basin Gas Street Basin], where historic boats and canal architecture mingle with modern-day restaurants, cafes and pubs. But elsewhere on the 'BCN', you can really get away from it all on winding suburban canals and a series of surprisingly rural branches.
The canals were the life-blood of Victorian Birmingham and the Black Country. At their height, they were so busy that gas lighting was installed beside the locks to permit round-the-clock operation. Boats were built without cabins for maximum carrying capacity, and a near-tidal effect was produced as swarms of narrowboats converged on the Black Country collieries at the same time every day.
The BCN has survived remarkably intact, with 100 miles still navigable from a peak of 160. The main lines and city centre canals are well patronised, but the waterways of the Northern BCN remain truly off the beaten track. But should you decide to tackle some of these rarely cruised waters, beware - boating the BCN can become addictive.
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[/canals-and-rivers/birmingham-and-fazeley-canal Birmingham & Fazeley Canal]
[/canals-and-rivers/birmingham-canal-main-line Birmingham Canal Main Line]
[/canals-and-rivers/birmingham-canal-old-main-line Birmingham Canal Old Main Line]
[/canals-and-rivers/daw-end-branch-canal Daw End Branch Canal]
[/canals-and-rivers/dudley-no-1-canal Dudley No. 1 Canal]
[/canals-and-rivers/dudley-no-2-canal Dudley No. 2 Canal]
[/canals-and-rivers/grand-union-canal Grand Union Canal]
[/canals-and-rivers/rushall-canal Rushall Canal]
[/canals-and-rivers/stourbridge-canal Stourbridge Canal]
[/canals-and-rivers/tame-valley-canal Tame Valley Canal]
[/canals-and-rivers/walsall-canal Walsall Canal]
[/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal]
[/canals-and-rivers/wyrley-and-essington-canal Wyrely & Essington Canal]
[_id:protected] => 459
[_url_name] => bcn
)
[_name:protected] => Walsall Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/walsall-canal
[_standfirst:protected] => The Walsall Canal is fast becoming an example of **an urban waterway revived. ** Environmental improvements along the canal have made it a waterway for local people to be proud of - most notably through the dramatic developments at the once derelict [/in-your-area/staffordshire/walsall Walsall] Town Wharf, including an acclaimed art gallery. And more is planned!
[_description:protected] => The Town Arm, in the heart of Walsall, is almost unrecognisable from just a few years ago when it was on the point of being lost forever. Totally renovated, it now has mooring facilities for boaters and a range of exciting attractions.
Why not discover why Walsall became the British leathergoods capital at the Walsall Leather Museum (01922 721153)? Or perhaps visit the New Art Gallery, which opened in February 2000 and displays an impressive collection of contemporary and modern art (01922 654400).
For nature lovers, walking enthusiasts and cyclists, the canals in Walsall are part of the cycling and walking network that connects the town centre to the surrounding countryside. Time your visit to Walsall to coincide with the Walsall Illuminations - Britain's biggest in-shore illuminations, held in Walsall Arboretum (01922 653148) - or alternatively enjoy some shopping in the bustling town centre and then reward yourself with a bite to eat and a glass of wine at the stylish Wharf 10 bar.
Other attractions include the Jerome K Jerome Birthplace Museum (01922 654315) and boat trips on The Wharf Narrowboat (0121 568 7929).
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[_id:protected] => 102
[_url_name] => walsall-canal
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] => 1
[_page_limit:private] => 9
)
)
)
[5] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 48
[function] => initItems
[class] => Waterscape_Component_DirectoryListingPage
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 7
[_name:protected] => Cycling
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => WS
[_min_easting:private] => 396461
[_max_easting:private] => 401025
[_min_northing:private] => 291654
[_max_northing:private] => 298647
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => UNKNOWN
[_min_easting:private] => 382875
[_max_easting:private] => 420475
[_min_northing:private] => 304050
[_max_northing:private] => 276950
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => BCN
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/bcn
[_standfirst:protected] => Does [/in-your-area/warwickshire/birmingham Birmingham] really have more miles of canal than Venice?
[_description:protected] => The exact numbers depend on where you draw the city boundaries, but the whole Birmingham Canal Navigations system extends for 100 miles in total. It is one of the most intricate canal networks in the world.
These waterways converge at the city centre bustle of [/in-your-area/warwickshire/places-to-go/185/gas-street-basin Gas Street Basin], where historic boats and canal architecture mingle with modern-day restaurants, cafes and pubs. But elsewhere on the 'BCN', you can really get away from it all on winding suburban canals and a series of surprisingly rural branches.
The canals were the life-blood of Victorian Birmingham and the Black Country. At their height, they were so busy that gas lighting was installed beside the locks to permit round-the-clock operation. Boats were built without cabins for maximum carrying capacity, and a near-tidal effect was produced as swarms of narrowboats converged on the Black Country collieries at the same time every day.
The BCN has survived remarkably intact, with 100 miles still navigable from a peak of 160. The main lines and city centre canals are well patronised, but the waterways of the Northern BCN remain truly off the beaten track. But should you decide to tackle some of these rarely cruised waters, beware - boating the BCN can become addictive.
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[/canals-and-rivers/birmingham-and-fazeley-canal Birmingham & Fazeley Canal]
[/canals-and-rivers/birmingham-canal-main-line Birmingham Canal Main Line]
[/canals-and-rivers/birmingham-canal-old-main-line Birmingham Canal Old Main Line]
[/canals-and-rivers/daw-end-branch-canal Daw End Branch Canal]
[/canals-and-rivers/dudley-no-1-canal Dudley No. 1 Canal]
[/canals-and-rivers/dudley-no-2-canal Dudley No. 2 Canal]
[/canals-and-rivers/grand-union-canal Grand Union Canal]
[/canals-and-rivers/rushall-canal Rushall Canal]
[/canals-and-rivers/stourbridge-canal Stourbridge Canal]
[/canals-and-rivers/tame-valley-canal Tame Valley Canal]
[/canals-and-rivers/walsall-canal Walsall Canal]
[/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal]
[/canals-and-rivers/wyrley-and-essington-canal Wyrely & Essington Canal]
[_id:protected] => 459
[_url_name] => bcn
)
[_name:protected] => Walsall Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/walsall-canal
[_standfirst:protected] => The Walsall Canal is fast becoming an example of **an urban waterway revived. ** Environmental improvements along the canal have made it a waterway for local people to be proud of - most notably through the dramatic developments at the once derelict [/in-your-area/staffordshire/walsall Walsall] Town Wharf, including an acclaimed art gallery. And more is planned!
[_description:protected] => The Town Arm, in the heart of Walsall, is almost unrecognisable from just a few years ago when it was on the point of being lost forever. Totally renovated, it now has mooring facilities for boaters and a range of exciting attractions.
Why not discover why Walsall became the British leathergoods capital at the Walsall Leather Museum (01922 721153)? Or perhaps visit the New Art Gallery, which opened in February 2000 and displays an impressive collection of contemporary and modern art (01922 654400).
For nature lovers, walking enthusiasts and cyclists, the canals in Walsall are part of the cycling and walking network that connects the town centre to the surrounding countryside. Time your visit to Walsall to coincide with the Walsall Illuminations - Britain's biggest in-shore illuminations, held in Walsall Arboretum (01922 653148) - or alternatively enjoy some shopping in the bustling town centre and then reward yourself with a bite to eat and a glass of wine at the stylish Wharf 10 bar.
Other attractions include the Jerome K Jerome Birthplace Museum (01922 654315) and boat trips on The Wharf Narrowboat (0121 568 7929).
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[_id:protected] => 102
[_url_name] => walsall-canal
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] => 1
[_page_limit:private] => 9
)
)
)
[6] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Renderer/Component/HtmlRenderer.php
[line] => 18
[function] => fetch
[class] => Waterscape_Component_DirectoryListingPage
[type] => ->
[args] => Array
(
)
)
[7] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Smarty.php
[line] => 262
[function] => render
[class] => Waterscape_Renderer_Component_HtmlRenderer
[type] => ->
[args] => Array
(
[0] => Waterscape_Component_DirectoryListingPage Object
(
[_is_location_page:private] => 1
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => WS
[_min_easting:private] => 396461
[_max_easting:private] => 401025
[_min_northing:private] => 291654
[_max_northing:private] => 298647
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => UNKNOWN
[_min_easting:private] => 382875
[_max_easting:private] => 420475
[_min_northing:private] => 304050
[_max_northing:private] => 276950
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => BCN
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/bcn
[_standfirst:protected] => Does [/in-your-area/warwickshire/birmingham Birmingham] really have more miles of canal than Venice?
[_description:protected] => The exact numbers depend on where you draw the city boundaries, but the whole Birmingham Canal Navigations system extends for 100 miles in total. It is one of the most intricate canal networks in the world.
These waterways converge at the city centre bustle of [/in-your-area/warwickshire/places-to-go/185/gas-street-basin Gas Street Basin], where historic boats and canal architecture mingle with modern-day restaurants, cafes and pubs. But elsewhere on the 'BCN', you can really get away from it all on winding suburban canals and a series of surprisingly rural branches.
The canals were the life-blood of Victorian Birmingham and the Black Country. At their height, they were so busy that gas lighting was installed beside the locks to permit round-the-clock operation. Boats were built without cabins for maximum carrying capacity, and a near-tidal effect was produced as swarms of narrowboats converged on the Black Country collieries at the same time every day.
The BCN has survived remarkably intact, with 100 miles still navigable from a peak of 160. The main lines and city centre canals are well patronised, but the waterways of the Northern BCN remain truly off the beaten track. But should you decide to tackle some of these rarely cruised waters, beware - boating the BCN can become addictive.
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[/canals-and-rivers/birmingham-and-fazeley-canal Birmingham & Fazeley Canal]
[/canals-and-rivers/birmingham-canal-main-line Birmingham Canal Main Line]
[/canals-and-rivers/birmingham-canal-old-main-line Birmingham Canal Old Main Line]
[/canals-and-rivers/daw-end-branch-canal Daw End Branch Canal]
[/canals-and-rivers/dudley-no-1-canal Dudley No. 1 Canal]
[/canals-and-rivers/dudley-no-2-canal Dudley No. 2 Canal]
[/canals-and-rivers/grand-union-canal Grand Union Canal]
[/canals-and-rivers/rushall-canal Rushall Canal]
[/canals-and-rivers/stourbridge-canal Stourbridge Canal]
[/canals-and-rivers/tame-valley-canal Tame Valley Canal]
[/canals-and-rivers/walsall-canal Walsall Canal]
[/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal]
[/canals-and-rivers/wyrley-and-essington-canal Wyrely & Essington Canal]
[_id:protected] => 459
[_url_name] => bcn
)
[_name:protected] => Walsall Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/walsall-canal
[_standfirst:protected] => The Walsall Canal is fast becoming an example of **an urban waterway revived. ** Environmental improvements along the canal have made it a waterway for local people to be proud of - most notably through the dramatic developments at the once derelict [/in-your-area/staffordshire/walsall Walsall] Town Wharf, including an acclaimed art gallery. And more is planned!
[_description:protected] => The Town Arm, in the heart of Walsall, is almost unrecognisable from just a few years ago when it was on the point of being lost forever. Totally renovated, it now has mooring facilities for boaters and a range of exciting attractions.
Why not discover why Walsall became the British leathergoods capital at the Walsall Leather Museum (01922 721153)? Or perhaps visit the New Art Gallery, which opened in February 2000 and displays an impressive collection of contemporary and modern art (01922 654400).
For nature lovers, walking enthusiasts and cyclists, the canals in Walsall are part of the cycling and walking network that connects the town centre to the surrounding countryside. Time your visit to Walsall to coincide with the Walsall Illuminations - Britain's biggest in-shore illuminations, held in Walsall Arboretum (01922 653148) - or alternatively enjoy some shopping in the bustling town centre and then reward yourself with a bite to eat and a glass of wine at the stylish Wharf 10 bar.
Other attractions include the Jerome K Jerome Birthplace Museum (01922 654315) and boat trips on The Wharf Narrowboat (0121 568 7929).
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[_id:protected] => 102
[_url_name] => walsall-canal
)
[_preposition:private] => along the
[_descriptor:private] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 7
[_name:protected] => Cycling
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
[_business_manager:private] =>
[_location_manager:private] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_town_manager:private] =>
[_limit:protected] =>
[_title:protected] => Cycle hire, clubs & services
[_items:protected] =>
[_is_paginated:protected] => 1
[_component_id:protected] => 14
[_parent_id:protected] =>
[_template:protected] => Component/ListingPage.tpl
[_page_id:protected] => 714813
[_view_component_id:protected] => 178
[_instance_name:protected] => directory_page
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /canals-and-rivers/walsall-canal/cycling
[_path:private] => /canals-and-rivers/walsall-canal/cycling
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => canals-and-rivers/walsall-canal/cycling
[PHPSESSID] => 963ea6b0b89037eb3fb534fa133fef22
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 24
[page_id] => 714813
[view_name] => waterway_cycling
[title] => Cycling And Cycle Routes %LOCATION_PREPOSITION% %LOCATION_NAME% | Canals and Rivers | Waterscape.com
[keywords] =>
[description] =>
[layout_template] => Page/locations/location.tpl
[template] => Page/locations/cycling.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Waterways
[path] => /canals-and-rivers/walsall-canal/cycling
[waterway] => Array
(
[id] => 102
[0] => 102
[name] => Walsall Canal
[1] => Walsall Canal
[urlname] => walsall-canal
[2] => walsall-canal
[waterway_type] => 15
[3] => 15
[sap_canal_code] => WS
[4] => WS
[introduction] => The Town Arm, in the heart of Walsall, is almost unrecognisable from just a few years ago when it was on the point of being lost forever. Totally renovated, it now has mooring facilities for boaters and a range of exciting attractions.
Why not discover why Walsall became the British leathergoods capital at the Walsall Leather Museum (01922 721153)? Or perhaps visit the New Art Gallery, which opened in February 2000 and displays an impressive collection of contemporary and modern art (01922 654400).
For nature lovers, walking enthusiasts and cyclists, the canals in Walsall are part of the cycling and walking network that connects the town centre to the surrounding countryside. Time your visit to Walsall to coincide with the Walsall Illuminations - Britain's biggest in-shore illuminations, held in Walsall Arboretum (01922 653148) - or alternatively enjoy some shopping in the bustling town centre and then reward yourself with a bite to eat and a glass of wine at the stylish Wharf 10 bar.
Other attractions include the Jerome K Jerome Birthplace Museum (01922 654315) and boat trips on The Wharf Narrowboat (0121 568 7929).
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[5] => The Town Arm, in the heart of Walsall, is almost unrecognisable from just a few years ago when it was on the point of being lost forever. Totally renovated, it now has mooring facilities for boaters and a range of exciting attractions.
Why not discover why Walsall became the British leathergoods capital at the Walsall Leather Museum (01922 721153)? Or perhaps visit the New Art Gallery, which opened in February 2000 and displays an impressive collection of contemporary and modern art (01922 654400).
For nature lovers, walking enthusiasts and cyclists, the canals in Walsall are part of the cycling and walking network that connects the town centre to the surrounding countryside. Time your visit to Walsall to coincide with the Walsall Illuminations - Britain's biggest in-shore illuminations, held in Walsall Arboretum (01922 653148) - or alternatively enjoy some shopping in the bustling town centre and then reward yourself with a bite to eat and a glass of wine at the stylish Wharf 10 bar.
Other attractions include the Jerome K Jerome Birthplace Museum (01922 654315) and boat trips on The Wharf Narrowboat (0121 568 7929).
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[overview] => The Walsall Canal is fast becoming an example of **an urban waterway revived. ** Environmental improvements along the canal have made it a waterway for local people to be proud of - most notably through the dramatic developments at the once derelict [/in-your-area/staffordshire/walsall Walsall] Town Wharf, including an acclaimed art gallery. And more is planned!
[6] => The Walsall Canal is fast becoming an example of **an urban waterway revived. ** Environmental improvements along the canal have made it a waterway for local people to be proud of - most notably through the dramatic developments at the once derelict [/in-your-area/staffordshire/walsall Walsall] Town Wharf, including an acclaimed art gallery. And more is planned!
[published] => 1
[7] => 1
[metadata_id] =>
[8] =>
[geo_data_id] =>
[9] =>
[importance] => 1
[10] => 1
[min_easting] => 396461
[11] => 396461
[min_northing] => 291654
[12] => 291654
[max_easting] => 401025
[13] => 401025
[max_northing] => 298647
[14] => 298647
[centre_easting] =>
[15] =>
[centre_northing] =>
[16] =>
)
[location] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => WS
[_min_easting:private] => 396461
[_max_easting:private] => 401025
[_min_northing:private] => 291654
[_max_northing:private] => 298647
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => UNKNOWN
[_min_easting:private] => 382875
[_max_easting:private] => 420475
[_min_northing:private] => 304050
[_max_northing:private] => 276950
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => BCN
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/bcn
[_standfirst:protected] => Does [/in-your-area/warwickshire/birmingham Birmingham] really have more miles of canal than Venice?
[_description:protected] => The exact numbers depend on where you draw the city boundaries, but the whole Birmingham Canal Navigations system extends for 100 miles in total. It is one of the most intricate canal networks in the world.
These waterways converge at the city centre bustle of [/in-your-area/warwickshire/places-to-go/185/gas-street-basin Gas Street Basin], where historic boats and canal architecture mingle with modern-day restaurants, cafes and pubs. But elsewhere on the 'BCN', you can really get away from it all on winding suburban canals and a series of surprisingly rural branches.
The canals were the life-blood of Victorian Birmingham and the Black Country. At their height, they were so busy that gas lighting was installed beside the locks to permit round-the-clock operation. Boats were built without cabins for maximum carrying capacity, and a near-tidal effect was produced as swarms of narrowboats converged on the Black Country collieries at the same time every day.
The BCN has survived remarkably intact, with 100 miles still navigable from a peak of 160. The main lines and city centre canals are well patronised, but the waterways of the Northern BCN remain truly off the beaten track. But should you decide to tackle some of these rarely cruised waters, beware - boating the BCN can become addictive.
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[/canals-and-rivers/birmingham-and-fazeley-canal Birmingham & Fazeley Canal]
[/canals-and-rivers/birmingham-canal-main-line Birmingham Canal Main Line]
[/canals-and-rivers/birmingham-canal-old-main-line Birmingham Canal Old Main Line]
[/canals-and-rivers/daw-end-branch-canal Daw End Branch Canal]
[/canals-and-rivers/dudley-no-1-canal Dudley No. 1 Canal]
[/canals-and-rivers/dudley-no-2-canal Dudley No. 2 Canal]
[/canals-and-rivers/grand-union-canal Grand Union Canal]
[/canals-and-rivers/rushall-canal Rushall Canal]
[/canals-and-rivers/stourbridge-canal Stourbridge Canal]
[/canals-and-rivers/tame-valley-canal Tame Valley Canal]
[/canals-and-rivers/walsall-canal Walsall Canal]
[/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal]
[/canals-and-rivers/wyrley-and-essington-canal Wyrely & Essington Canal]
[_id:protected] => 459
[_url_name] => bcn
)
[_name:protected] => Walsall Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/walsall-canal
[_standfirst:protected] => The Walsall Canal is fast becoming an example of **an urban waterway revived. ** Environmental improvements along the canal have made it a waterway for local people to be proud of - most notably through the dramatic developments at the once derelict [/in-your-area/staffordshire/walsall Walsall] Town Wharf, including an acclaimed art gallery. And more is planned!
[_description:protected] => The Town Arm, in the heart of Walsall, is almost unrecognisable from just a few years ago when it was on the point of being lost forever. Totally renovated, it now has mooring facilities for boaters and a range of exciting attractions.
Why not discover why Walsall became the British leathergoods capital at the Walsall Leather Museum (01922 721153)? Or perhaps visit the New Art Gallery, which opened in February 2000 and displays an impressive collection of contemporary and modern art (01922 654400).
For nature lovers, walking enthusiasts and cyclists, the canals in Walsall are part of the cycling and walking network that connects the town centre to the surrounding countryside. Time your visit to Walsall to coincide with the Walsall Illuminations - Britain's biggest in-shore illuminations, held in Walsall Arboretum (01922 653148) - or alternatively enjoy some shopping in the bustling town centre and then reward yourself with a bite to eat and a glass of wine at the stylish Wharf 10 bar.
Other attractions include the Jerome K Jerome Birthplace Museum (01922 654315) and boat trips on The Wharf Narrowboat (0121 568 7929).
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[_id:protected] => 102
[_url_name] => walsall-canal
)
[preposition] => along the
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => WS
[_min_easting:private] => 396461
[_max_easting:private] => 401025
[_min_northing:private] => 291654
[_max_northing:private] => 298647
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => UNKNOWN
[_min_easting:private] => 382875
[_max_easting:private] => 420475
[_min_northing:private] => 304050
[_max_northing:private] => 276950
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => BCN
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/bcn
[_standfirst:protected] => Does [/in-your-area/warwickshire/birmingham Birmingham] really have more miles of canal than Venice?
[_description:protected] => The exact numbers depend on where you draw the city boundaries, but the whole Birmingham Canal Navigations system extends for 100 miles in total. It is one of the most intricate canal networks in the world.
These waterways converge at the city centre bustle of [/in-your-area/warwickshire/places-to-go/185/gas-street-basin Gas Street Basin], where historic boats and canal architecture mingle with modern-day restaurants, cafes and pubs. But elsewhere on the 'BCN', you can really get away from it all on winding suburban canals and a series of surprisingly rural branches.
The canals were the life-blood of Victorian Birmingham and the Black Country. At their height, they were so busy that gas lighting was installed beside the locks to permit round-the-clock operation. Boats were built without cabins for maximum carrying capacity, and a near-tidal effect was produced as swarms of narrowboats converged on the Black Country collieries at the same time every day.
The BCN has survived remarkably intact, with 100 miles still navigable from a peak of 160. The main lines and city centre canals are well patronised, but the waterways of the Northern BCN remain truly off the beaten track. But should you decide to tackle some of these rarely cruised waters, beware - boating the BCN can become addictive.
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[/canals-and-rivers/birmingham-and-fazeley-canal Birmingham & Fazeley Canal]
[/canals-and-rivers/birmingham-canal-main-line Birmingham Canal Main Line]
[/canals-and-rivers/birmingham-canal-old-main-line Birmingham Canal Old Main Line]
[/canals-and-rivers/daw-end-branch-canal Daw End Branch Canal]
[/canals-and-rivers/dudley-no-1-canal Dudley No. 1 Canal]
[/canals-and-rivers/dudley-no-2-canal Dudley No. 2 Canal]
[/canals-and-rivers/grand-union-canal Grand Union Canal]
[/canals-and-rivers/rushall-canal Rushall Canal]
[/canals-and-rivers/stourbridge-canal Stourbridge Canal]
[/canals-and-rivers/tame-valley-canal Tame Valley Canal]
[/canals-and-rivers/walsall-canal Walsall Canal]
[/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal]
[/canals-and-rivers/wyrley-and-essington-canal Wyrely & Essington Canal]
[_id:protected] => 459
[_url_name] => bcn
)
[_name:protected] => Walsall Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/walsall-canal
[_standfirst:protected] => The Walsall Canal is fast becoming an example of **an urban waterway revived. ** Environmental improvements along the canal have made it a waterway for local people to be proud of - most notably through the dramatic developments at the once derelict [/in-your-area/staffordshire/walsall Walsall] Town Wharf, including an acclaimed art gallery. And more is planned!
[_description:protected] => The Town Arm, in the heart of Walsall, is almost unrecognisable from just a few years ago when it was on the point of being lost forever. Totally renovated, it now has mooring facilities for boaters and a range of exciting attractions.
Why not discover why Walsall became the British leathergoods capital at the Walsall Leather Museum (01922 721153)? Or perhaps visit the New Art Gallery, which opened in February 2000 and displays an impressive collection of contemporary and modern art (01922 654400).
For nature lovers, walking enthusiasts and cyclists, the canals in Walsall are part of the cycling and walking network that connects the town centre to the surrounding countryside. Time your visit to Walsall to coincide with the Walsall Illuminations - Britain's biggest in-shore illuminations, held in Walsall Arboretum (01922 653148) - or alternatively enjoy some shopping in the bustling town centre and then reward yourself with a bite to eat and a glass of wine at the stylish Wharf 10 bar.
Other attractions include the Jerome K Jerome Birthplace Museum (01922 654315) and boat trips on The Wharf Narrowboat (0121 568 7929).
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[_id:protected] => 102
[_url_name] => walsall-canal
)
[_na_office_manager:private] => Waterscape_Service_NavigationAuthorityOfficeManager Object
(
[_navigation_authority_office_dao:private] => Waterscape_Dao_NavigationAuthorityOffice Object
(
[_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_navigation_authority_dao:private] => Waterscape_Dao_NavigationAuthority Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
[_stoppage_manager:private] => Waterscape_Service_StoppageManager Object
(
[_stoppage_dao:private] => Waterscape_Dao_Stoppage Object
(
[_waterway_mgr:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion 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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType 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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription 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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
)
[_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] => 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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
)
[_route_manager:private] => Waterscape_Service_RouteManager Object
(
[_route_dao:private] => Waterscape_Dao_Route Object
(
[_route_type_manager:private] => Waterscape_Service_RouteTypeManager Object
(
[_route_type_dao:private] => Waterscape_Dao_RouteType Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
)
[_waypoint_manager:private] => Waterscape_Service_WaypointManager Object
(
[_waypoint_dao:private] => Waterscape_Dao_Waypoint Object
(
[_metadata_mgr:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_geo_point_mgr:private] =>
[_geo_data_type_manager:private] => Waterscape_Service_GeoDataTypeManager Object
(
[_geo_data_dao:private] => Waterscape_Dao_GeoDataType Object
(
[_db:protected] =>
)
)
[_db:protected] =>
[_geo_point_manager] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] =>
)
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
)
[_media_manager:private] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => 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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass 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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
[_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] => 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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
[_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] => 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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[67] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[72] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[73] => Array
(
[sql] => select id from waterway where id = ?
)
[74] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[75] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[76] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[77] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[78] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[79] => Array
(
[sql] => select id from waterway where id = ?
)
[80] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[81] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[82] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[83] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[84] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[86] => Array
(
[sql] => select id from waterway where id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[91] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[92] => Array
(
[sql] => select id from waterway where id = ?
)
[93] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[94] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[95] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[96] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[97] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[98] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[99] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[100] => Array
(
[sql] => select id from waterway where id = ?
)
[101] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[102] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 102 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 103
)
)
)
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => select id from waterway where id = ?
)
[6] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[7] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[10] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[13] => 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 = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[17] => 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 = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[35] => 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 = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => 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 = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => 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 = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?