Walking along the River Thames
Let the River Thames gradually unravel its secrets as you walk along the Thames Path. The 184 miles of the Path offer easy, level walking and can be enjoyed in many ways, whether for an afternoon stroll, a weekend break or a full scale trek of the entire length from its source to Teddington and on to the Thames Barrier.
The Thames Path is one of only 13 National Trails in England, and is easily accessible by public transport. You can split the trail over several days and stay overnight at one of the many campsites, B&Bs and hotels along the river. For detailed information about the Thames Path, call the National Trails Office on 01865 810224 or visit www.nationaltrails.gov.uk.
The Thames and its Path can be enjoyed at any time of year but the months between April and November are considered the best for wildlife and the changing countryside colours. Lightweight comfortable shoes are suitable for gentle walking in the summer, but in the wet months put on your wellingtons or walking boots. Rain does sometimes affect the path, particularly west of Oxford, so check with the Environment Agency's Flood Information line on 0845 988 1188.
The beauty of a trail along a river is that it is so easy to follow the route! In addition good signage and helpful lock keepers along the way will ensure you don't get lost and will point out all the interesting places. So put your walking boots on and enjoy meandering the day away.
The Thames is also accessible for those with a disability. The Landscape Strategy has recently published, in partnership with the Environment Agency and the Countryside Agency, a guide to ten easily accessible walks around the Richmond area. The guide includes large print maps and is easy to follow. Copies can be obtained from the Thames Landscape Strategy, c/o Holly Lodge, Richmond Park, Richmond TW10 5HS. Call 020 8940 0654 or email tls@richmond.gov.uk.
The Ramblers' Association exists to facilitate, for the benefit of everyone, the enjoyment and discovery that walking outdoors can bring, and to promote respect for the life of the countryside. Visit www.ramblers.org.uk.
If you're looking for a bit of inspiration for a walk, a Thames & Chilterns Walk leaflet is available from local Tourist Information Centres and Thames locks, covering a range of different walks from Henley-on-Thames along the River Thames and into the Chiltern Hills.
Click here to buy the Nicholson Guide online >>
Click here to buy the Geoprojects map online >>
Walking routes
- Walking the Thames from Henley to Hambleden »
- Exploring Hambleden and Henley »
- Exploring Henley and Remenham Wood »
- River Thames around Abingdon »
- Walking in the Isle of Dogs »
- Thames Path 4 Tadpole Bridge to Eynsham »
- Thames Path 6 Oxford to Abingdon »
- Thames Path 5 Eynsham to Oxford »
- Thames Path 3 Lechlade to Tadpole Bridge »
Towpath Stoppages
There are no stoppages reported at this time.
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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) 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] => 6
[_name:protected] => Walking
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 16
[_geo_data_id:private] =>
[_sap_canal_code:private] => UNKNOWN
[_min_easting:private] => 420481
[_max_easting:private] => 567221
[_min_northing:private] => 165860
[_max_northing:private] => 210297
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => River Thames
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/river-thames
[_standfirst:protected] => One of the most famous rivers in the world, the Thames runs for 216 miles from source to sea and is steeped in lore along virtually its entire route.
[_description:protected] => Rights of navigation were laid down in Magna Carta, but the river's history extends much further. Festivals and rituals such as the Boat Race, Henley Regatta and the annual Swan Upping imbue a character found nowhere but Old Father Thames.
Under the authority of the [http://www.environment-agency.gov.uk/navigation/ Environment Agency], the non-tidal Thames can be navigated for 135 miles from Cricklade to Teddington Lock, passing through 44 picturesque locks and near almost 150 [/features-and-articles/features/wildlife wildlife] sites. You can discover it by boat or from the Thames Path, one of Britain's most popular National Trails.
For more information about the River Thames visit the Environment Agency site [http://www.visitthames.co.uk visitthames.co.uk]
[/media/documents/22239.pdf Download a Guide and map to the East End's canals and London Docklands]
[_id:protected] => 170
[_url_name] => river-thames
)
[_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] => 6
[_name:protected] => Walking
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 16
[_geo_data_id:private] =>
[_sap_canal_code:private] => UNKNOWN
[_min_easting:private] => 420481
[_max_easting:private] => 567221
[_min_northing:private] => 165860
[_max_northing:private] => 210297
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => River Thames
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/river-thames
[_standfirst:protected] => One of the most famous rivers in the world, the Thames runs for 216 miles from source to sea and is steeped in lore along virtually its entire route.
[_description:protected] => Rights of navigation were laid down in Magna Carta, but the river's history extends much further. Festivals and rituals such as the Boat Race, Henley Regatta and the annual Swan Upping imbue a character found nowhere but Old Father Thames.
Under the authority of the [http://www.environment-agency.gov.uk/navigation/ Environment Agency], the non-tidal Thames can be navigated for 135 miles from Cricklade to Teddington Lock, passing through 44 picturesque locks and near almost 150 [/features-and-articles/features/wildlife wildlife] sites. You can discover it by boat or from the Thames Path, one of Britain's most popular National Trails.
For more information about the River Thames visit the Environment Agency site [http://www.visitthames.co.uk visitthames.co.uk]
[/media/documents/22239.pdf Download a Guide and map to the East End's canals and London Docklands]
[_id:protected] => 170
[_url_name] => river-thames
)
[_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] => 16
[_geo_data_id:private] =>
[_sap_canal_code:private] => UNKNOWN
[_min_easting:private] => 420481
[_max_easting:private] => 567221
[_min_northing:private] => 165860
[_max_northing:private] => 210297
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => River Thames
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/river-thames
[_standfirst:protected] => One of the most famous rivers in the world, the Thames runs for 216 miles from source to sea and is steeped in lore along virtually its entire route.
[_description:protected] => Rights of navigation were laid down in Magna Carta, but the river's history extends much further. Festivals and rituals such as the Boat Race, Henley Regatta and the annual Swan Upping imbue a character found nowhere but Old Father Thames.
Under the authority of the [http://www.environment-agency.gov.uk/navigation/ Environment Agency], the non-tidal Thames can be navigated for 135 miles from Cricklade to Teddington Lock, passing through 44 picturesque locks and near almost 150 [/features-and-articles/features/wildlife wildlife] sites. You can discover it by boat or from the Thames Path, one of Britain's most popular National Trails.
For more information about the River Thames visit the Environment Agency site [http://www.visitthames.co.uk visitthames.co.uk]
[/media/documents/22239.pdf Download a Guide and map to the East End's canals and London Docklands]
[_id:protected] => 170
[_url_name] => river-thames
)
[_preposition:private] => along the
[_descriptor:private] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 6
[_name:protected] => Walking
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
)
[_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] => Walking clubs & services
[_items:protected] =>
[_is_paginated:protected] => 1
[_component_id:protected] => 14
[_parent_id:protected] =>
[_template:protected] => Component/ListingPage.tpl
[_page_id:protected] => 717804
[_view_component_id:protected] => 177
[_instance_name:protected] => directory_page
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /canals-and-rivers/river-thames/walking
[_path:private] => /canals-and-rivers/river-thames/walking
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => canals-and-rivers/river-thames/walking
[PHPSESSID] => 4561e56428a297eec764b085391961f1
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 23
[page_id] => 717804
[view_name] => waterway_walking
[title] => Walks and Walking Routes %LOCATION_PREPOSITION% %LOCATION_NAME% | Canals and Rivers
[keywords] =>
[description] =>
[layout_template] => Page/locations/location.tpl
[template] => Page/locations/walking.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Waterways
[path] => /canals-and-rivers/river-thames/walking
[waterway] => Array
(
[id] => 170
[0] => 170
[name] => River Thames
[1] => River Thames
[urlname] => river-thames
[2] => river-thames
[waterway_type] => 16
[3] => 16
[sap_canal_code] => UNKNOWN
[4] => UNKNOWN
[introduction] => Rights of navigation were laid down in Magna Carta, but the river's history extends much further. Festivals and rituals such as the Boat Race, Henley Regatta and the annual Swan Upping imbue a character found nowhere but Old Father Thames.
Under the authority of the [http://www.environment-agency.gov.uk/navigation/ Environment Agency], the non-tidal Thames can be navigated for 135 miles from Cricklade to Teddington Lock, passing through 44 picturesque locks and near almost 150 [/features-and-articles/features/wildlife wildlife] sites. You can discover it by boat or from the Thames Path, one of Britain's most popular National Trails.
For more information about the River Thames visit the Environment Agency site [http://www.visitthames.co.uk visitthames.co.uk]
[/media/documents/22239.pdf Download a Guide and map to the East End's canals and London Docklands]
[5] => Rights of navigation were laid down in Magna Carta, but the river's history extends much further. Festivals and rituals such as the Boat Race, Henley Regatta and the annual Swan Upping imbue a character found nowhere but Old Father Thames.
Under the authority of the [http://www.environment-agency.gov.uk/navigation/ Environment Agency], the non-tidal Thames can be navigated for 135 miles from Cricklade to Teddington Lock, passing through 44 picturesque locks and near almost 150 [/features-and-articles/features/wildlife wildlife] sites. You can discover it by boat or from the Thames Path, one of Britain's most popular National Trails.
For more information about the River Thames visit the Environment Agency site [http://www.visitthames.co.uk visitthames.co.uk]
[/media/documents/22239.pdf Download a Guide and map to the East End's canals and London Docklands]
[overview] => One of the most famous rivers in the world, the Thames runs for 216 miles from source to sea and is steeped in lore along virtually its entire route.
[6] => One of the most famous rivers in the world, the Thames runs for 216 miles from source to sea and is steeped in lore along virtually its entire route.
[published] => 1
[7] => 1
[metadata_id] =>
[8] =>
[geo_data_id] =>
[9] =>
[importance] => 10
[10] => 10
[min_easting] => 420481
[11] => 420481
[min_northing] => 165860
[12] => 165860
[max_easting] => 567221
[13] => 567221
[max_northing] => 210297
[14] => 210297
[centre_easting] =>
[15] =>
[centre_northing] =>
[16] =>
)
[location] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 16
[_geo_data_id:private] =>
[_sap_canal_code:private] => UNKNOWN
[_min_easting:private] => 420481
[_max_easting:private] => 567221
[_min_northing:private] => 165860
[_max_northing:private] => 210297
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => River Thames
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/river-thames
[_standfirst:protected] => One of the most famous rivers in the world, the Thames runs for 216 miles from source to sea and is steeped in lore along virtually its entire route.
[_description:protected] => Rights of navigation were laid down in Magna Carta, but the river's history extends much further. Festivals and rituals such as the Boat Race, Henley Regatta and the annual Swan Upping imbue a character found nowhere but Old Father Thames.
Under the authority of the [http://www.environment-agency.gov.uk/navigation/ Environment Agency], the non-tidal Thames can be navigated for 135 miles from Cricklade to Teddington Lock, passing through 44 picturesque locks and near almost 150 [/features-and-articles/features/wildlife wildlife] sites. You can discover it by boat or from the Thames Path, one of Britain's most popular National Trails.
For more information about the River Thames visit the Environment Agency site [http://www.visitthames.co.uk visitthames.co.uk]
[/media/documents/22239.pdf Download a Guide and map to the East End's canals and London Docklands]
[_id:protected] => 170
[_url_name] => river-thames
)
[preposition] => along the
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 16
[_geo_data_id:private] =>
[_sap_canal_code:private] => UNKNOWN
[_min_easting:private] => 420481
[_max_easting:private] => 567221
[_min_northing:private] => 165860
[_max_northing:private] => 210297
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => River Thames
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/river-thames
[_standfirst:protected] => One of the most famous rivers in the world, the Thames runs for 216 miles from source to sea and is steeped in lore along virtually its entire route.
[_description:protected] => Rights of navigation were laid down in Magna Carta, but the river's history extends much further. Festivals and rituals such as the Boat Race, Henley Regatta and the annual Swan Upping imbue a character found nowhere but Old Father Thames.
Under the authority of the [http://www.environment-agency.gov.uk/navigation/ Environment Agency], the non-tidal Thames can be navigated for 135 miles from Cricklade to Teddington Lock, passing through 44 picturesque locks and near almost 150 [/features-and-articles/features/wildlife wildlife] sites. You can discover it by boat or from the Thames Path, one of Britain's most popular National Trails.
For more information about the River Thames visit the Environment Agency site [http://www.visitthames.co.uk visitthames.co.uk]
[/media/documents/22239.pdf Download a Guide and map to the East End's canals and London Docklands]
[_id:protected] => 170
[_url_name] => river-thames
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion Object
(
[_db:protected] =>
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType Object
(
[_db:protected] =>
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription Object
(
[_db:protected] =>
)
)
[_criteria:private] => Array
(
)
[_raw_criteria:private] =>
[_sql_strings:private] => Array
(
)
[_sql_values:private] => Array
(
)
[_search_data_by:private] => Array
(
[all] => 0
[stoppage] => s
[restriction] => r
[opening_times] => o
[booking_details] => b
[advice] => a
[towpath_closure_only] => t
)
[_str_types_selected:private] =>
[_stoppage_type:private] =>
[_db:protected] => 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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
)
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
)
[_business_manager:private] => Waterscape_Service_BusinessManager Object
(
[_business_dao:private] => Waterscape_Dao_Business Object
(
[_address_manager:protected] => Waterscape_Service_StreetAddressManager Object
(
[_street_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
)
[_metadata_manager:protected] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_attribute_manager:protected] => Waterscape_Service_AttributeManager Object
(
[_attribute_dao:private] => Waterscape_Dao_Attribute Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_category_manager:protected] => Waterscape_Service_CategoryManager Object
(
[_category_dao:private] => Waterscape_Dao_Category Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_section_manager:protected] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_location_manager:protected] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * 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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_media_manager:protected] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => 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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
[_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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => 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 = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => 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
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND w.waterway_id = 170 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 = 6) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 6)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 78
)
)
[_db:protected] =>
)
)
)
[_db:protected] =>
)
)
[_menu_id:protected] =>
[_menu_items:protected] =>
[_display_class:protected] =>
[_html_class:protected] =>
[_html_id:protected] =>
[_menu_components:protected] =>
[_page_manager:protected] => Waterscape_Service_PageManager Object
(
[_page_dao:private] => Waterscape_Dao_Page Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * 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 component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => 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 = 3
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => 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 = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => 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 = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE 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 <> ?