Walking near Stoke Bruerne
Challenge yourself with a walk along the Nene Way, a long distance route which follows the Wash coastal path through Northamptonshire and along the unnavigable Nene. The long-established route takes you through some of Northamptonshire’s finest villages – with many a welcoming pub conveniently situated along the way.
Find more walks along the Grand Union Canal in Northamptonshire (opens e-book)
Walking routes
Towpath Stoppages
13 Apr 2008 until further notice
Restriction: Lock 16W to 17W
Associated Regional Office: BW North-WestTowpath has been closed
A retaining wall has collapsed onto the towpath between 16W and 17W on the Huddersfield Narrow Canal; as such the towpath has been closed for health and safety reasons. Navigation is not affected.
Pedestrians are requested to follow the diversion notices that are in place.
Please accept our apologies for any inconvenience caused.
(Enquiries: 01942 405700)
02 Nov 2009 - 26 Mar 2010
Stoppage: Canal between Locks 28 East and 42 East to allow lock gate replacemement
Associated Regional Office: Manchester & Pennine WaterwaysTowpath has been closed
UPDATE (23 February 2010): Due to a late start following the bad weather the completion date has been changed to 26th March 2010.
Lock Gate replacement at Locks: 28 East - Top and Bottom 29 East - Top and Bottom 31 East - Top and Bottom 33 East - Top and Bottom 40 East - Top 42 East - Top
Winding point at Aspley Basin
(Enquiries: 01782 785703)
12 Jan 2010 until further notice
Towpath Closure only: Lock 14 Huddersfield Narrow Canal
Associated Regional Office: Manchester & Pennine WaterwaysThe towpath has been closed between Locks 14 West and 15 West for safety reasons. This is due to the collapse of an adjacent building onto the towpath of the canal at Lock 14 West.
British Waterways apologise for any inconvenience caused.
(Enquiries: 01782 785703)
18 Jan 2010 - 01 Apr 2010
Stoppage: Canal and towpath closed between Locks 13 & 15 to allow repair to Lock 14
Associated Regional Office: Manchester & Pennine WaterwaysTowpath has been closed
UPDATE (12 March 2010): The completion of the £250k investment at this lock will be delayed due to additional works being found to be necessary. These are the relining of the paddle culvert which has to be done to allow the lock to be reopened to navigation, and which must be done before the lock gate replacement work can be completed.
British Waterways apologise for any inconvenience caused.
UPDATE (29 January 2010): Due to adverse weather conditions and additional works fitting the gates the completion date has been changed to 26th March 2010.
British Waterways apologise for any inconvenience caused.
Lock 14 Ramsdens Lock. Major repairs to Lock- lock will be closed, also lock 13 and 15 will be closed, towpath from Lock 15 to 14 will be closed
Towpath closure/diversion to be advised. Winding point at Aspley Basin.
(Enquiries: 01782 785703)
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, sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) AS distance 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
[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, sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) AS distance 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
[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, sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) AS distance 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
[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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT 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_waypoint wp ON r.route_id = wp.route_id WHERE 1=1 AND sqrt(pow(474370-wp.easting,2)+pow(249975-wp.northing,2)) <= 16000 AND rt.type_id = 3
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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 content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[54] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[70] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[71] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[81] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[91] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[94] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => 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
)
[107] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[108] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[110] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[111] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[112] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[113] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[114] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[115] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[116] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[117] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[118] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[119] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[120] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[121] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[122] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[123] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[124] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[125] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[126] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[127] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[128] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[130] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[131] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[132] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[133] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[136] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[137] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[138] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[139] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[140] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[141] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[142] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[143] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[144] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[145] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[146] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[147] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[148] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[150] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[151] => 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
)
)
[queryCounter] => 152
)
)
)
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 474370
[y] => 249975
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20781
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 22
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 488587
[_min_northing:private] => 255602
[_max_easting:private] => 653816
[_max_northing:private] => 588517
[_centre_easting:private] => 476500
[_centre_northing:private] => 260100
[_name:protected] => Northamptonshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/northamptonshire
[_standfirst:protected] => Classically English scenery surrounds the waterways of Northamptonshire.
[_description:protected] => Industrial towns give way to stone-built villages and farmers’ fields as the [/canals-and-rivers/grand-union-canal Grand Union Canal] makes steady progress past Milton Keynes and into the county of 'squires and spires'. Here the [/canals-and-rivers/river-nene River Nene] comes into its own as a quintessentially rural waterway.
[_id:protected] => 20
[_url_name] => northamptonshire
)
[_easting:protected] => 474370
[_northing:protected] => 249975
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Stoke Bruerne
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/northamptonshire/stoke-bruerne
[_standfirst:protected] => All the family will enjoy a day-out in historic Stoke Bruerne on the [/canals-and-rivers/grand-union-canal Grand Union Canal].
[_description:protected] => This bustling village has been attracting visitors for centuries.
First came the Romans, then the Saxons, and when the Normans compiled their Doomsday Book, they recorded Swain Briwere as the lord of the manor.
But the biggest upheaval was the arrival of the canal, which cut the village in two. There must have been mumblings and grumblings at the time, but local people soon began to make money by supplying the canal builders – and later the canal users – with bread, beer, blacksmithing and many other services.
**What to see in Stoke Bruerne**
All the family will enjoy a visit to [/in-your-area/northamptonshire/places-to-go/495/national-waterways-museum-stoke-bruerne The Canal Museum]. You can learn how engineers chose the route of the canal and how the Blisworth Tunnel was built. You can find out about the people who worked the boats, decorating them with roses and castles and making decorative rope work. You’ll also see some of the boat collection alongside the canal.
Stoke Bruerne has its own **nature reserve**, managed by the Wildlife Trust. It’s a great place to look for butterflies, dragonflies, birds and harmless grass snakes.
Read more about [/features-and-articles/features/wildlife waterway wildlife]
**Go for a drive around Stoke Bruerne**
The attractive village of Blisworth is just a short drive from Stoke Bruerne. [/in-your-area/northamptonshire/places-to-go/57/blisworth-tunnel Blisworth Tunnel] is Britain’s second longest useable canal tunnel. It runs for one and three quarter miles from Stroke Bruerne to Blisworth and was built after the canal opened because the first attempt to dig a tunnel was abandoned.
**Go for a walk along the Grand Union Canal**
You’re spoilt for choice for walks around Stoke Bruerne.
The Grand Union Canal Walk follows the canal for as far as you want to go. You could go south to Grafton Regis and come back through the fields past Stoke Park (about six miles). Or you could go north over Blisworth Hill to Blisworth itself, following the old toll road, and come back by the Midshires Way (about five miles).
Alternatively, follow our detailed route on a [/things-to-do/walking/routes/88/a-circular-walk-around-stoke-bruerne circular walk around Stoke Bruerne]
**Fascinating facts about Stoke Bruerne**
Men’s legs once propelled boats through Blisworth Tunnel. Before steam tugs and diesel powered narrowboats, the only way through the tunnel was by human power as there was no towpath for horses. The ‘leggers’ were hired by the boat owners. They lay on their backs with their legs sticking out and walked against the tunnel wall for nearly two miles. Then they walked back to Stoke Bruerne.
Boat people once had their own nurse. Sister Mary Ward’s surgery was near Top Lock. Her patients put up with aches and pains until they could get to Stoke Bruerne and expectant mothers moored their boats here so that she could deliver their babies.
**Disabled access**
The 0.5 mile towpath between the village and the Blisworth Tunnel is suitable for wheelchair users, as is a short stretch outside the Bottom Lock car park.
**Stoke Bruerne audio trail**
This audio trail has been developed with advice from local people who are blind or visually impaired and has been funded by [http://www.britishwaterways.co.uk British Waterways], the Fieldfare Trust and Heritage Lottery Fund. The audio trail guides visitors around the Stoke Bruerne with a lively commentary on the fascinating heritage and present day use of the canal.
The audio trail follows surfaced towpaths and has occasional resting points. Visitors can enjoy the audio trails as they walk along the towpath or take a virtual tour in the comfort of the shop using the tactile map. The trail starts at the museum and takes about 45 minutes to complete. There are six stopping places along the towpath, with seating available at various places along the route. Cassette players and tapes are available free of charge from the Stoke Bruerne Museum shop.
[/media/sound/02_stoke_bruerne.mp3 Download the Stoke Bruerne audio trail]
[/media/documents/20772.doc Read the Stoke Bruerne audio trail script]
**National Waterways Museum, Stoke Bruerne – audio trail**
A Family Audio Trail following the travels of Jack, the boat boy, around Stoke Bruerne in Victorian times.
The family audio trail tells the story of Jack, the son of a canal boatman who has bought a new horse. Jack begs his father to let him name the horse while the family is moored at Stoke Bruerne. You can follow his journey as he meets different people who work at Stoke Bruerne and asks their advice about a suitable name. Follow the audio clues as you listen, to discover the name Jack chose for his horse. Just fill in the spaces on sheet 3 and all will be revealed. You have to do some detective work...
[/media/sound/jacks_horse_cd_april_edits.mp3 Download the National Waterways Musuem, Stoke Bruerne audio trail]
[/media/documents/20773.doc Read the National Waterways Musuem, Stoke Bruerne, audio trail script]
**How to get there**
Stoke Bruerne is situated off the A508 Northampton – Milton Keynes Road, four miles east of Towcester and a short drive from Junction 15 on the M1.
**By road**
Stoke Bruerne is about seven miles south of Northampton, about 10 miles from Milton Keynes, and 10 minutes from both the M1 (J15) and the A5, just off the A508.
**By public transport**
United Counties service number 87 runs between Northampton and Milton Keynes, stopping at Stoke Bruerne, Mondays to Saturdays. No service on Sundays. The Saunterbus operates between Easter and September on selected days. The 'Heritage' route stops at Stoke Bruerne.
[/media/documents/20807.pdf Download a Guide and map to Milton Keynes’ Canals]
[_id:protected] => 40
[_url_name] => stoke-bruerne
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT 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_waypoint wp ON r.route_id = wp.route_id WHERE 1=1 AND sqrt(pow(474370-wp.easting,2)+pow(249975-wp.northing,2)) <= 16000 AND rt.type_id = 3
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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 content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[54] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[70] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[71] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[81] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[91] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[94] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => 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
)
[107] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[108] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[110] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[111] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[112] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[113] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[114] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[115] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[116] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[117] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[118] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[119] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[120] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[121] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[122] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[123] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[124] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[125] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[126] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[127] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[128] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[130] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[131] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[132] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[133] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[136] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[137] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[138] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[139] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[140] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[141] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[142] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[143] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[144] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[145] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[146] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[147] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[148] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[150] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[151] => 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
)
)
[queryCounter] => 152
)
)
)
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 474370
[y] => 249975
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20781
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 22
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 488587
[_min_northing:private] => 255602
[_max_easting:private] => 653816
[_max_northing:private] => 588517
[_centre_easting:private] => 476500
[_centre_northing:private] => 260100
[_name:protected] => Northamptonshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/northamptonshire
[_standfirst:protected] => Classically English scenery surrounds the waterways of Northamptonshire.
[_description:protected] => Industrial towns give way to stone-built villages and farmers’ fields as the [/canals-and-rivers/grand-union-canal Grand Union Canal] makes steady progress past Milton Keynes and into the county of 'squires and spires'. Here the [/canals-and-rivers/river-nene River Nene] comes into its own as a quintessentially rural waterway.
[_id:protected] => 20
[_url_name] => northamptonshire
)
[_easting:protected] => 474370
[_northing:protected] => 249975
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Stoke Bruerne
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/northamptonshire/stoke-bruerne
[_standfirst:protected] => All the family will enjoy a day-out in historic Stoke Bruerne on the [/canals-and-rivers/grand-union-canal Grand Union Canal].
[_description:protected] => This bustling village has been attracting visitors for centuries.
First came the Romans, then the Saxons, and when the Normans compiled their Doomsday Book, they recorded Swain Briwere as the lord of the manor.
But the biggest upheaval was the arrival of the canal, which cut the village in two. There must have been mumblings and grumblings at the time, but local people soon began to make money by supplying the canal builders – and later the canal users – with bread, beer, blacksmithing and many other services.
**What to see in Stoke Bruerne**
All the family will enjoy a visit to [/in-your-area/northamptonshire/places-to-go/495/national-waterways-museum-stoke-bruerne The Canal Museum]. You can learn how engineers chose the route of the canal and how the Blisworth Tunnel was built. You can find out about the people who worked the boats, decorating them with roses and castles and making decorative rope work. You’ll also see some of the boat collection alongside the canal.
Stoke Bruerne has its own **nature reserve**, managed by the Wildlife Trust. It’s a great place to look for butterflies, dragonflies, birds and harmless grass snakes.
Read more about [/features-and-articles/features/wildlife waterway wildlife]
**Go for a drive around Stoke Bruerne**
The attractive village of Blisworth is just a short drive from Stoke Bruerne. [/in-your-area/northamptonshire/places-to-go/57/blisworth-tunnel Blisworth Tunnel] is Britain’s second longest useable canal tunnel. It runs for one and three quarter miles from Stroke Bruerne to Blisworth and was built after the canal opened because the first attempt to dig a tunnel was abandoned.
**Go for a walk along the Grand Union Canal**
You’re spoilt for choice for walks around Stoke Bruerne.
The Grand Union Canal Walk follows the canal for as far as you want to go. You could go south to Grafton Regis and come back through the fields past Stoke Park (about six miles). Or you could go north over Blisworth Hill to Blisworth itself, following the old toll road, and come back by the Midshires Way (about five miles).
Alternatively, follow our detailed route on a [/things-to-do/walking/routes/88/a-circular-walk-around-stoke-bruerne circular walk around Stoke Bruerne]
**Fascinating facts about Stoke Bruerne**
Men’s legs once propelled boats through Blisworth Tunnel. Before steam tugs and diesel powered narrowboats, the only way through the tunnel was by human power as there was no towpath for horses. The ‘leggers’ were hired by the boat owners. They lay on their backs with their legs sticking out and walked against the tunnel wall for nearly two miles. Then they walked back to Stoke Bruerne.
Boat people once had their own nurse. Sister Mary Ward’s surgery was near Top Lock. Her patients put up with aches and pains until they could get to Stoke Bruerne and expectant mothers moored their boats here so that she could deliver their babies.
**Disabled access**
The 0.5 mile towpath between the village and the Blisworth Tunnel is suitable for wheelchair users, as is a short stretch outside the Bottom Lock car park.
**Stoke Bruerne audio trail**
This audio trail has been developed with advice from local people who are blind or visually impaired and has been funded by [http://www.britishwaterways.co.uk British Waterways], the Fieldfare Trust and Heritage Lottery Fund. The audio trail guides visitors around the Stoke Bruerne with a lively commentary on the fascinating heritage and present day use of the canal.
The audio trail follows surfaced towpaths and has occasional resting points. Visitors can enjoy the audio trails as they walk along the towpath or take a virtual tour in the comfort of the shop using the tactile map. The trail starts at the museum and takes about 45 minutes to complete. There are six stopping places along the towpath, with seating available at various places along the route. Cassette players and tapes are available free of charge from the Stoke Bruerne Museum shop.
[/media/sound/02_stoke_bruerne.mp3 Download the Stoke Bruerne audio trail]
[/media/documents/20772.doc Read the Stoke Bruerne audio trail script]
**National Waterways Museum, Stoke Bruerne – audio trail**
A Family Audio Trail following the travels of Jack, the boat boy, around Stoke Bruerne in Victorian times.
The family audio trail tells the story of Jack, the son of a canal boatman who has bought a new horse. Jack begs his father to let him name the horse while the family is moored at Stoke Bruerne. You can follow his journey as he meets different people who work at Stoke Bruerne and asks their advice about a suitable name. Follow the audio clues as you listen, to discover the name Jack chose for his horse. Just fill in the spaces on sheet 3 and all will be revealed. You have to do some detective work...
[/media/sound/jacks_horse_cd_april_edits.mp3 Download the National Waterways Musuem, Stoke Bruerne audio trail]
[/media/documents/20773.doc Read the National Waterways Musuem, Stoke Bruerne, audio trail script]
**How to get there**
Stoke Bruerne is situated off the A508 Northampton – Milton Keynes Road, four miles east of Towcester and a short drive from Junction 15 on the M1.
**By road**
Stoke Bruerne is about seven miles south of Northampton, about 10 miles from Milton Keynes, and 10 minutes from both the M1 (J15) and the A5, just off the A508.
**By public transport**
United Counties service number 87 runs between Northampton and Milton Keynes, stopping at Stoke Bruerne, Mondays to Saturdays. No service on Sundays. The Saunterbus operates between Easter and September on selected days. The 'Heritage' route stops at Stoke Bruerne.
[/media/documents/20807.pdf Download a Guide and map to Milton Keynes’ Canals]
[_id:protected] => 40
[_url_name] => stoke-bruerne
)
[_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_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 474370
[y] => 249975
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20781
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 22
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 488587
[_min_northing:private] => 255602
[_max_easting:private] => 653816
[_max_northing:private] => 588517
[_centre_easting:private] => 476500
[_centre_northing:private] => 260100
[_name:protected] => Northamptonshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/northamptonshire
[_standfirst:protected] => Classically English scenery surrounds the waterways of Northamptonshire.
[_description:protected] => Industrial towns give way to stone-built villages and farmers’ fields as the [/canals-and-rivers/grand-union-canal Grand Union Canal] makes steady progress past Milton Keynes and into the county of 'squires and spires'. Here the [/canals-and-rivers/river-nene River Nene] comes into its own as a quintessentially rural waterway.
[_id:protected] => 20
[_url_name] => northamptonshire
)
[_easting:protected] => 474370
[_northing:protected] => 249975
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Stoke Bruerne
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/northamptonshire/stoke-bruerne
[_standfirst:protected] => All the family will enjoy a day-out in historic Stoke Bruerne on the [/canals-and-rivers/grand-union-canal Grand Union Canal].
[_description:protected] => This bustling village has been attracting visitors for centuries.
First came the Romans, then the Saxons, and when the Normans compiled their Doomsday Book, they recorded Swain Briwere as the lord of the manor.
But the biggest upheaval was the arrival of the canal, which cut the village in two. There must have been mumblings and grumblings at the time, but local people soon began to make money by supplying the canal builders – and later the canal users – with bread, beer, blacksmithing and many other services.
**What to see in Stoke Bruerne**
All the family will enjoy a visit to [/in-your-area/northamptonshire/places-to-go/495/national-waterways-museum-stoke-bruerne The Canal Museum]. You can learn how engineers chose the route of the canal and how the Blisworth Tunnel was built. You can find out about the people who worked the boats, decorating them with roses and castles and making decorative rope work. You’ll also see some of the boat collection alongside the canal.
Stoke Bruerne has its own **nature reserve**, managed by the Wildlife Trust. It’s a great place to look for butterflies, dragonflies, birds and harmless grass snakes.
Read more about [/features-and-articles/features/wildlife waterway wildlife]
**Go for a drive around Stoke Bruerne**
The attractive village of Blisworth is just a short drive from Stoke Bruerne. [/in-your-area/northamptonshire/places-to-go/57/blisworth-tunnel Blisworth Tunnel] is Britain’s second longest useable canal tunnel. It runs for one and three quarter miles from Stroke Bruerne to Blisworth and was built after the canal opened because the first attempt to dig a tunnel was abandoned.
**Go for a walk along the Grand Union Canal**
You’re spoilt for choice for walks around Stoke Bruerne.
The Grand Union Canal Walk follows the canal for as far as you want to go. You could go south to Grafton Regis and come back through the fields past Stoke Park (about six miles). Or you could go north over Blisworth Hill to Blisworth itself, following the old toll road, and come back by the Midshires Way (about five miles).
Alternatively, follow our detailed route on a [/things-to-do/walking/routes/88/a-circular-walk-around-stoke-bruerne circular walk around Stoke Bruerne]
**Fascinating facts about Stoke Bruerne**
Men’s legs once propelled boats through Blisworth Tunnel. Before steam tugs and diesel powered narrowboats, the only way through the tunnel was by human power as there was no towpath for horses. The ‘leggers’ were hired by the boat owners. They lay on their backs with their legs sticking out and walked against the tunnel wall for nearly two miles. Then they walked back to Stoke Bruerne.
Boat people once had their own nurse. Sister Mary Ward’s surgery was near Top Lock. Her patients put up with aches and pains until they could get to Stoke Bruerne and expectant mothers moored their boats here so that she could deliver their babies.
**Disabled access**
The 0.5 mile towpath between the village and the Blisworth Tunnel is suitable for wheelchair users, as is a short stretch outside the Bottom Lock car park.
**Stoke Bruerne audio trail**
This audio trail has been developed with advice from local people who are blind or visually impaired and has been funded by [http://www.britishwaterways.co.uk British Waterways], the Fieldfare Trust and Heritage Lottery Fund. The audio trail guides visitors around the Stoke Bruerne with a lively commentary on the fascinating heritage and present day use of the canal.
The audio trail follows surfaced towpaths and has occasional resting points. Visitors can enjoy the audio trails as they walk along the towpath or take a virtual tour in the comfort of the shop using the tactile map. The trail starts at the museum and takes about 45 minutes to complete. There are six stopping places along the towpath, with seating available at various places along the route. Cassette players and tapes are available free of charge from the Stoke Bruerne Museum shop.
[/media/sound/02_stoke_bruerne.mp3 Download the Stoke Bruerne audio trail]
[/media/documents/20772.doc Read the Stoke Bruerne audio trail script]
**National Waterways Museum, Stoke Bruerne – audio trail**
A Family Audio Trail following the travels of Jack, the boat boy, around Stoke Bruerne in Victorian times.
The family audio trail tells the story of Jack, the son of a canal boatman who has bought a new horse. Jack begs his father to let him name the horse while the family is moored at Stoke Bruerne. You can follow his journey as he meets different people who work at Stoke Bruerne and asks their advice about a suitable name. Follow the audio clues as you listen, to discover the name Jack chose for his horse. Just fill in the spaces on sheet 3 and all will be revealed. You have to do some detective work...
[/media/sound/jacks_horse_cd_april_edits.mp3 Download the National Waterways Musuem, Stoke Bruerne audio trail]
[/media/documents/20773.doc Read the National Waterways Musuem, Stoke Bruerne, audio trail script]
**How to get there**
Stoke Bruerne is situated off the A508 Northampton – Milton Keynes Road, four miles east of Towcester and a short drive from Junction 15 on the M1.
**By road**
Stoke Bruerne is about seven miles south of Northampton, about 10 miles from Milton Keynes, and 10 minutes from both the M1 (J15) and the A5, just off the A508.
**By public transport**
United Counties service number 87 runs between Northampton and Milton Keynes, stopping at Stoke Bruerne, Mondays to Saturdays. No service on Sundays. The Saunterbus operates between Easter and September on selected days. The 'Heritage' route stops at Stoke Bruerne.
[/media/documents/20807.pdf Download a Guide and map to Milton Keynes’ Canals]
[_id:protected] => 40
[_url_name] => stoke-bruerne
)
[_preposition:private] => near
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT 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_waypoint wp ON r.route_id = wp.route_id WHERE 1=1 AND sqrt(pow(474370-wp.easting,2)+pow(249975-wp.northing,2)) <= 16000 AND rt.type_id = 3
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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 content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[54] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[70] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[71] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[81] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[91] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[94] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => 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
)
[107] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[108] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[110] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[111] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[112] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[113] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[114] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[115] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[116] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[117] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[118] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[119] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[120] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[121] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[122] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[123] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[124] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[125] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[126] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[127] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[128] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[130] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[131] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[132] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[133] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[136] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[137] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[138] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[139] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[140] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[141] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[142] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[143] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[144] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[145] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[146] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[147] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[148] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[150] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[151] => 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
)
)
[queryCounter] => 152
)
)
[_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] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT 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_waypoint wp ON r.route_id = wp.route_id WHERE 1=1 AND sqrt(pow(474370-wp.easting,2)+pow(249975-wp.northing,2)) <= 16000 AND rt.type_id = 3
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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 content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[54] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[70] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[71] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[81] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[91] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[94] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => 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
)
[107] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[108] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[110] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[111] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[112] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[113] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[114] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[115] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[116] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[117] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[118] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[119] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[120] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[121] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[122] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[123] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[124] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[125] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[126] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[127] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[128] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[130] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[131] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[132] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[133] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[136] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[137] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[138] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[139] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[140] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[141] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[142] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[143] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[144] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[145] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[146] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[147] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[148] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[150] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[151] => 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
)
)
[queryCounter] => 152
)
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT 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_waypoint wp ON r.route_id = wp.route_id WHERE 1=1 AND sqrt(pow(474370-wp.easting,2)+pow(249975-wp.northing,2)) <= 16000 AND rt.type_id = 3
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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 content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[54] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[70] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[71] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[81] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[91] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[94] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => 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
)
[107] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[108] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[110] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[111] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[112] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[113] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[114] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[115] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[116] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[117] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[118] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[119] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[120] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[121] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[122] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[123] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[124] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[125] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[126] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[127] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[128] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[130] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[131] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[132] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[133] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[136] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[137] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[138] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[139] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[140] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[141] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[142] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[143] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[144] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[145] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[146] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[147] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[148] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[150] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[151] => 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
)
)
[queryCounter] => 152
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT 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_waypoint wp ON r.route_id = wp.route_id WHERE 1=1 AND sqrt(pow(474370-wp.easting,2)+pow(249975-wp.northing,2)) <= 16000 AND rt.type_id = 3
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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 content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[54] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[70] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[71] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[81] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[91] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[94] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => 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
)
[107] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[108] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[110] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[111] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[112] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[113] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[114] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[115] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[116] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[117] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[118] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[119] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[120] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[121] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[122] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[123] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[124] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[125] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[126] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[127] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[128] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[130] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[131] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[132] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[133] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[136] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[137] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[138] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[139] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[140] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[141] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[142] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[143] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[144] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[145] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[146] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[147] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[148] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[150] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[151] => 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
)
)
[queryCounter] => 152
)
)
[_geo_point_mgr:private] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT 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_waypoint wp ON r.route_id = wp.route_id WHERE 1=1 AND sqrt(pow(474370-wp.easting,2)+pow(249975-wp.northing,2)) <= 16000 AND rt.type_id = 3
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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 content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[54] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[70] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[71] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[81] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[91] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[94] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => 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
)
[107] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[108] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[110] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[111] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[112] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[113] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[114] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[115] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[116] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[117] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[118] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[119] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[120] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[121] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[122] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[123] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[124] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[125] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[126] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[127] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[128] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[130] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[131] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[132] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[133] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[136] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[137] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[138] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[139] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[140] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[141] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[142] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[143] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[144] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[145] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[146] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[147] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[148] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[150] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[151] => 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
)
)
[queryCounter] => 152
)
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT 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_waypoint wp ON r.route_id = wp.route_id WHERE 1=1 AND sqrt(pow(474370-wp.easting,2)+pow(249975-wp.northing,2)) <= 16000 AND rt.type_id = 3
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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 content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[54] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[70] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[71] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[81] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[91] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[94] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => 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
)
[107] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[108] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[110] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[111] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[112] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[113] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[114] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[115] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[116] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[117] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[118] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[119] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[120] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[121] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[122] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[123] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[124] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[125] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[126] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[127] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[128] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[130] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[131] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[132] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[133] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[136] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[137] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[138] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[139] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[140] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[141] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[142] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[143] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[144] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[145] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[146] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[147] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[148] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[150] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[151] => 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
)
)
[queryCounter] => 152
)
)
)
[_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] => 3536
[_view_component_id:protected] => 154
[_instance_name:protected] => directory_page
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/northamptonshire/stoke-bruerne/walking
[_path:private] => /in-your-area/northamptonshire/stoke-bruerne/walking
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/northamptonshire/stoke-bruerne/walking
[PHPSESSID] => 215f2efc5a64896a729f06e159e90fcf
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 13
[page_id] => 3536
[view_name] => locations_walking
[title] => Walks, Walking and Walking Routes %LOCATION_PREPOSITION% %LOCATION_NAME% %LOCATION_COUNTY_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_Locations
[path] => /in-your-area/northamptonshire/stoke-bruerne/walking
[location] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 474370
[y] => 249975
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20781
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 22
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 488587
[_min_northing:private] => 255602
[_max_easting:private] => 653816
[_max_northing:private] => 588517
[_centre_easting:private] => 476500
[_centre_northing:private] => 260100
[_name:protected] => Northamptonshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/northamptonshire
[_standfirst:protected] => Classically English scenery surrounds the waterways of Northamptonshire.
[_description:protected] => Industrial towns give way to stone-built villages and farmers’ fields as the [/canals-and-rivers/grand-union-canal Grand Union Canal] makes steady progress past Milton Keynes and into the county of 'squires and spires'. Here the [/canals-and-rivers/river-nene River Nene] comes into its own as a quintessentially rural waterway.
[_id:protected] => 20
[_url_name] => northamptonshire
)
[_easting:protected] => 474370
[_northing:protected] => 249975
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Stoke Bruerne
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/northamptonshire/stoke-bruerne
[_standfirst:protected] => All the family will enjoy a day-out in historic Stoke Bruerne on the [/canals-and-rivers/grand-union-canal Grand Union Canal].
[_description:protected] => This bustling village has been attracting visitors for centuries.
First came the Romans, then the Saxons, and when the Normans compiled their Doomsday Book, they recorded Swain Briwere as the lord of the manor.
But the biggest upheaval was the arrival of the canal, which cut the village in two. There must have been mumblings and grumblings at the time, but local people soon began to make money by supplying the canal builders – and later the canal users – with bread, beer, blacksmithing and many other services.
**What to see in Stoke Bruerne**
All the family will enjoy a visit to [/in-your-area/northamptonshire/places-to-go/495/national-waterways-museum-stoke-bruerne The Canal Museum]. You can learn how engineers chose the route of the canal and how the Blisworth Tunnel was built. You can find out about the people who worked the boats, decorating them with roses and castles and making decorative rope work. You’ll also see some of the boat collection alongside the canal.
Stoke Bruerne has its own **nature reserve**, managed by the Wildlife Trust. It’s a great place to look for butterflies, dragonflies, birds and harmless grass snakes.
Read more about [/features-and-articles/features/wildlife waterway wildlife]
**Go for a drive around Stoke Bruerne**
The attractive village of Blisworth is just a short drive from Stoke Bruerne. [/in-your-area/northamptonshire/places-to-go/57/blisworth-tunnel Blisworth Tunnel] is Britain’s second longest useable canal tunnel. It runs for one and three quarter miles from Stroke Bruerne to Blisworth and was built after the canal opened because the first attempt to dig a tunnel was abandoned.
**Go for a walk along the Grand Union Canal**
You’re spoilt for choice for walks around Stoke Bruerne.
The Grand Union Canal Walk follows the canal for as far as you want to go. You could go south to Grafton Regis and come back through the fields past Stoke Park (about six miles). Or you could go north over Blisworth Hill to Blisworth itself, following the old toll road, and come back by the Midshires Way (about five miles).
Alternatively, follow our detailed route on a [/things-to-do/walking/routes/88/a-circular-walk-around-stoke-bruerne circular walk around Stoke Bruerne]
**Fascinating facts about Stoke Bruerne**
Men’s legs once propelled boats through Blisworth Tunnel. Before steam tugs and diesel powered narrowboats, the only way through the tunnel was by human power as there was no towpath for horses. The ‘leggers’ were hired by the boat owners. They lay on their backs with their legs sticking out and walked against the tunnel wall for nearly two miles. Then they walked back to Stoke Bruerne.
Boat people once had their own nurse. Sister Mary Ward’s surgery was near Top Lock. Her patients put up with aches and pains until they could get to Stoke Bruerne and expectant mothers moored their boats here so that she could deliver their babies.
**Disabled access**
The 0.5 mile towpath between the village and the Blisworth Tunnel is suitable for wheelchair users, as is a short stretch outside the Bottom Lock car park.
**Stoke Bruerne audio trail**
This audio trail has been developed with advice from local people who are blind or visually impaired and has been funded by [http://www.britishwaterways.co.uk British Waterways], the Fieldfare Trust and Heritage Lottery Fund. The audio trail guides visitors around the Stoke Bruerne with a lively commentary on the fascinating heritage and present day use of the canal.
The audio trail follows surfaced towpaths and has occasional resting points. Visitors can enjoy the audio trails as they walk along the towpath or take a virtual tour in the comfort of the shop using the tactile map. The trail starts at the museum and takes about 45 minutes to complete. There are six stopping places along the towpath, with seating available at various places along the route. Cassette players and tapes are available free of charge from the Stoke Bruerne Museum shop.
[/media/sound/02_stoke_bruerne.mp3 Download the Stoke Bruerne audio trail]
[/media/documents/20772.doc Read the Stoke Bruerne audio trail script]
**National Waterways Museum, Stoke Bruerne – audio trail**
A Family Audio Trail following the travels of Jack, the boat boy, around Stoke Bruerne in Victorian times.
The family audio trail tells the story of Jack, the son of a canal boatman who has bought a new horse. Jack begs his father to let him name the horse while the family is moored at Stoke Bruerne. You can follow his journey as he meets different people who work at Stoke Bruerne and asks their advice about a suitable name. Follow the audio clues as you listen, to discover the name Jack chose for his horse. Just fill in the spaces on sheet 3 and all will be revealed. You have to do some detective work...
[/media/sound/jacks_horse_cd_april_edits.mp3 Download the National Waterways Musuem, Stoke Bruerne audio trail]
[/media/documents/20773.doc Read the National Waterways Musuem, Stoke Bruerne, audio trail script]
**How to get there**
Stoke Bruerne is situated off the A508 Northampton – Milton Keynes Road, four miles east of Towcester and a short drive from Junction 15 on the M1.
**By road**
Stoke Bruerne is about seven miles south of Northampton, about 10 miles from Milton Keynes, and 10 minutes from both the M1 (J15) and the A5, just off the A508.
**By public transport**
United Counties service number 87 runs between Northampton and Milton Keynes, stopping at Stoke Bruerne, Mondays to Saturdays. No service on Sundays. The Saunterbus operates between Easter and September on selected days. The 'Heritage' route stops at Stoke Bruerne.
[/media/documents/20807.pdf Download a Guide and map to Milton Keynes’ Canals]
[_id:protected] => 40
[_url_name] => stoke-bruerne
)
[preposition] => near
[section] => walking
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 474370
[y] => 249975
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20781
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 22
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 488587
[_min_northing:private] => 255602
[_max_easting:private] => 653816
[_max_northing:private] => 588517
[_centre_easting:private] => 476500
[_centre_northing:private] => 260100
[_name:protected] => Northamptonshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/northamptonshire
[_standfirst:protected] => Classically English scenery surrounds the waterways of Northamptonshire.
[_description:protected] => Industrial towns give way to stone-built villages and farmers’ fields as the [/canals-and-rivers/grand-union-canal Grand Union Canal] makes steady progress past Milton Keynes and into the county of 'squires and spires'. Here the [/canals-and-rivers/river-nene River Nene] comes into its own as a quintessentially rural waterway.
[_id:protected] => 20
[_url_name] => northamptonshire
)
[_easting:protected] => 474370
[_northing:protected] => 249975
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Stoke Bruerne
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/northamptonshire/stoke-bruerne
[_standfirst:protected] => All the family will enjoy a day-out in historic Stoke Bruerne on the [/canals-and-rivers/grand-union-canal Grand Union Canal].
[_description:protected] => This bustling village has been attracting visitors for centuries.
First came the Romans, then the Saxons, and when the Normans compiled their Doomsday Book, they recorded Swain Briwere as the lord of the manor.
But the biggest upheaval was the arrival of the canal, which cut the village in two. There must have been mumblings and grumblings at the time, but local people soon began to make money by supplying the canal builders – and later the canal users – with bread, beer, blacksmithing and many other services.
**What to see in Stoke Bruerne**
All the family will enjoy a visit to [/in-your-area/northamptonshire/places-to-go/495/national-waterways-museum-stoke-bruerne The Canal Museum]. You can learn how engineers chose the route of the canal and how the Blisworth Tunnel was built. You can find out about the people who worked the boats, decorating them with roses and castles and making decorative rope work. You’ll also see some of the boat collection alongside the canal.
Stoke Bruerne has its own **nature reserve**, managed by the Wildlife Trust. It’s a great place to look for butterflies, dragonflies, birds and harmless grass snakes.
Read more about [/features-and-articles/features/wildlife waterway wildlife]
**Go for a drive around Stoke Bruerne**
The attractive village of Blisworth is just a short drive from Stoke Bruerne. [/in-your-area/northamptonshire/places-to-go/57/blisworth-tunnel Blisworth Tunnel] is Britain’s second longest useable canal tunnel. It runs for one and three quarter miles from Stroke Bruerne to Blisworth and was built after the canal opened because the first attempt to dig a tunnel was abandoned.
**Go for a walk along the Grand Union Canal**
You’re spoilt for choice for walks around Stoke Bruerne.
The Grand Union Canal Walk follows the canal for as far as you want to go. You could go south to Grafton Regis and come back through the fields past Stoke Park (about six miles). Or you could go north over Blisworth Hill to Blisworth itself, following the old toll road, and come back by the Midshires Way (about five miles).
Alternatively, follow our detailed route on a [/things-to-do/walking/routes/88/a-circular-walk-around-stoke-bruerne circular walk around Stoke Bruerne]
**Fascinating facts about Stoke Bruerne**
Men’s legs once propelled boats through Blisworth Tunnel. Before steam tugs and diesel powered narrowboats, the only way through the tunnel was by human power as there was no towpath for horses. The ‘leggers’ were hired by the boat owners. They lay on their backs with their legs sticking out and walked against the tunnel wall for nearly two miles. Then they walked back to Stoke Bruerne.
Boat people once had their own nurse. Sister Mary Ward’s surgery was near Top Lock. Her patients put up with aches and pains until they could get to Stoke Bruerne and expectant mothers moored their boats here so that she could deliver their babies.
**Disabled access**
The 0.5 mile towpath between the village and the Blisworth Tunnel is suitable for wheelchair users, as is a short stretch outside the Bottom Lock car park.
**Stoke Bruerne audio trail**
This audio trail has been developed with advice from local people who are blind or visually impaired and has been funded by [http://www.britishwaterways.co.uk British Waterways], the Fieldfare Trust and Heritage Lottery Fund. The audio trail guides visitors around the Stoke Bruerne with a lively commentary on the fascinating heritage and present day use of the canal.
The audio trail follows surfaced towpaths and has occasional resting points. Visitors can enjoy the audio trails as they walk along the towpath or take a virtual tour in the comfort of the shop using the tactile map. The trail starts at the museum and takes about 45 minutes to complete. There are six stopping places along the towpath, with seating available at various places along the route. Cassette players and tapes are available free of charge from the Stoke Bruerne Museum shop.
[/media/sound/02_stoke_bruerne.mp3 Download the Stoke Bruerne audio trail]
[/media/documents/20772.doc Read the Stoke Bruerne audio trail script]
**National Waterways Museum, Stoke Bruerne – audio trail**
A Family Audio Trail following the travels of Jack, the boat boy, around Stoke Bruerne in Victorian times.
The family audio trail tells the story of Jack, the son of a canal boatman who has bought a new horse. Jack begs his father to let him name the horse while the family is moored at Stoke Bruerne. You can follow his journey as he meets different people who work at Stoke Bruerne and asks their advice about a suitable name. Follow the audio clues as you listen, to discover the name Jack chose for his horse. Just fill in the spaces on sheet 3 and all will be revealed. You have to do some detective work...
[/media/sound/jacks_horse_cd_april_edits.mp3 Download the National Waterways Musuem, Stoke Bruerne audio trail]
[/media/documents/20773.doc Read the National Waterways Musuem, Stoke Bruerne, audio trail script]
**How to get there**
Stoke Bruerne is situated off the A508 Northampton – Milton Keynes Road, four miles east of Towcester and a short drive from Junction 15 on the M1.
**By road**
Stoke Bruerne is about seven miles south of Northampton, about 10 miles from Milton Keynes, and 10 minutes from both the M1 (J15) and the A5, just off the A508.
**By public transport**
United Counties service number 87 runs between Northampton and Milton Keynes, stopping at Stoke Bruerne, Mondays to Saturdays. No service on Sundays. The Saunterbus operates between Easter and September on selected days. The 'Heritage' route stops at Stoke Bruerne.
[/media/documents/20807.pdf Download a Guide and map to Milton Keynes’ Canals]
[_id:protected] => 40
[_url_name] => stoke-bruerne
)
[_na_office_manager:private] => Waterscape_Service_NavigationAuthorityOfficeManager Object
(
[_navigation_authority_office_dao:private] => Waterscape_Dao_NavigationAuthorityOffice Object
(
[_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT 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_waypoint wp ON r.route_id = wp.route_id WHERE 1=1 AND sqrt(pow(474370-wp.easting,2)+pow(249975-wp.northing,2)) <= 16000 AND rt.type_id = 3
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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 content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[54] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[70] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[71] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[81] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[91] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[94] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => 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
)
[107] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[108] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[110] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[111] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[112] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[113] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[114] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[115] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[116] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[117] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[118] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[119] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[120] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[121] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[122] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[123] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[124] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[125] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[126] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[127] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[128] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[130] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[131] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[132] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[133] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[136] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[137] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[138] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[139] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[140] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[141] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[142] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[143] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[144] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[145] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[146] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[147] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[148] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[150] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[151] => 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
)
)
[queryCounter] => 152
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT 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_waypoint wp ON r.route_id = wp.route_id WHERE 1=1 AND sqrt(pow(474370-wp.easting,2)+pow(249975-wp.northing,2)) <= 16000 AND rt.type_id = 3
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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 content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[54] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[70] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[71] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[81] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[91] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[94] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => 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
)
[107] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[108] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[110] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[111] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[112] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[113] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[114] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[115] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[116] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[117] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[118] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[119] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[120] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[121] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[122] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[123] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[124] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[125] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[126] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[127] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[128] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[130] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[131] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[132] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[133] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[136] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[137] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[138] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[139] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[140] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[141] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[142] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[143] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[144] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[145] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[146] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[147] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[148] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[150] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[151] => 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
)
)
[queryCounter] => 152
)
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT 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_waypoint wp ON r.route_id = wp.route_id WHERE 1=1 AND sqrt(pow(474370-wp.easting,2)+pow(249975-wp.northing,2)) <= 16000 AND rt.type_id = 3
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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 content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[54] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[70] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[71] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[81] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[91] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[94] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => 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
)
[107] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[108] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[110] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[111] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[112] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[113] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[114] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[115] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[116] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[117] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[118] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[119] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[120] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[121] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[122] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[123] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[124] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[125] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[126] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[127] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[128] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[130] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[131] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[132] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[133] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[136] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[137] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[138] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[139] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[140] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[141] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[142] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[143] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[144] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[145] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[146] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[147] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[148] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[150] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[151] => 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
)
)
[queryCounter] => 152
)
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT 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_waypoint wp ON r.route_id = wp.route_id WHERE 1=1 AND sqrt(pow(474370-wp.easting,2)+pow(249975-wp.northing,2)) <= 16000 AND rt.type_id = 3
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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 content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[54] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[70] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[71] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[81] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[91] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[94] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => 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
)
[107] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[108] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[110] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[111] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[112] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[113] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[114] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[115] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[116] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[117] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[118] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[119] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[120] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[121] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[122] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[123] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[124] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[125] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[126] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[127] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[128] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[130] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[131] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[132] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[133] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[136] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[137] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[138] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[139] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[140] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[141] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[142] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[143] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[144] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[145] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[146] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[147] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[148] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[150] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[151] => 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
)
)
[queryCounter] => 152
)
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT 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_waypoint wp ON r.route_id = wp.route_id WHERE 1=1 AND sqrt(pow(474370-wp.easting,2)+pow(249975-wp.northing,2)) <= 16000 AND rt.type_id = 3
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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 content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[54] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[70] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[71] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[79] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[81] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[91] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[94] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => 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
)
[107] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[108] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[110] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[111] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[112] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[113] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[114] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[115] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[116] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[117] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[118] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[119] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[120] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[121] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[122] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[123] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[124] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[125] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[126] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[127] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[128] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[130] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[131] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[132] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[133] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[136] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[137] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[138] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[139] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[140] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[141] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[142] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[143] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[144] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[145] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[146] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[147] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[148] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[150] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[151] => 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 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) <= 16000 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 sqrt(pow(474370-m.easting,2)+pow(249975-m.northing,2)) ASC
)
)
[queryCounter] => 152
)
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT 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_waypoint wp ON r.route_id = wp.route_id WHERE 1=1 AND sqrt(pow(474370-wp.easting,2)+pow(249975-wp.northing,2)) <= 16000 AND rt.type_id = 3
)
[14] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(