Walking near Tardebigge
Walking opportunities abound in Worcestershire. Long-distance walkers can take on the Severn Way – particularly attractive around Worcestershire – or head east and tackle the 77-mile Oxford Canal Walk. Families set their own pace on the footpaths around Earlswood Lakes and history buffs can admire the restoration work on the Droitwich Canals.
Download a mini guide to cycling and walking around Dudley
Walking routes
Towpath Stoppages
22 Oct 2009 until further notice
Towpath Closure only: Husbands Bosworth Tunnel
Associated Regional Office: BW South-EastBridge 45 to Husbands Bosworth Tunnel
Please note that the towpath between Bridge 45 (A4304 Market Harborough Road) and Husbands Bosworth Tunnel remains closed due to severe erosion and steep banks. Work is in progress to reinstate the towpath which will be re-opened early in the New Year.
(Enquiries: 01908 302500)
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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-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(400050-wp.easting,2)+pow(268748-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 town_id FROM town WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[115] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[116] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[117] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[118] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[119] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[121] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[122] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[123] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[124] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[125] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[126] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[127] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[129] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[130] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[131] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[132] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[135] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[136] => 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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-m.northing,2)) ASC
)
)
[queryCounter] => 137
)
)
)
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 400050
[y] => 268748
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20777
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 34
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 408781
[_min_northing:private] => 250661
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 384300
[_centre_northing:private] => 254840
[_name:protected] => Worcestershire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire
[_standfirst:protected] => The undulating landscape of the South Midlands is surprisingly rural.
[_description:protected] => The historic town of Worcester is a stone’s throw from [/in-your-area/warwickshire/birmingham Birmingham]’s suburbia and Shakespeare’s Stratford. Surrounded by gentle countryside, Worcestershire is blessed with numerous waterways, long stretches of delightful scenery, pretty towns and fascinating canal architecture such as the Tardebigge Flight and [/in-your-area/worcestershire/places-to-go/470/stourport-basins Stourport Basins].
[_id:protected] => 22
[_url_name] => worcestershire
)
[_easting:protected] => 400050
[_northing:protected] => 268748
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Tardebigge
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire/tardebigge
[_standfirst:protected] => The thirty locks in the Tardebigge Flight make it the largest flight of locks in Britain, and raise the [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] up 220 feet through some delightful rolling countryside just southeast of Bromsgrove.
[_description:protected] => At Bridge 54, about three quarters of a mile before Tardebigge top lock is Tardebigge reservoir, a popular local spot for fishing. At Tardebigge Top Lock there is a plaque to commemorate the 1946 founding of the Inland Waterways Association - today still the most important waterways conservation pressure group. LTC (Tom) Rolt and Robert Aickman hatched their initial plans here on //Cressy//, Rolt's narrowboat.
Tardebigge itself, just south at the same point, is a charming village centred around its imposing 18th Century church. Beyond Tardebigge Top Lock, boaters will find in short order Tardebigge Tunnel (580yards) and Shortwood Tunnel (612yards).
[_id:protected] => 36
[_url_name] => tardebigge
)
[_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(400050-wp.easting,2)+pow(268748-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 town_id FROM town WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[115] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[116] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[117] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[118] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[119] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[121] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[122] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[123] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[124] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[125] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[126] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[127] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[129] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[130] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[131] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[132] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[135] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[136] => 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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-m.northing,2)) ASC
)
)
[queryCounter] => 137
)
)
)
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 400050
[y] => 268748
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20777
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 34
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 408781
[_min_northing:private] => 250661
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 384300
[_centre_northing:private] => 254840
[_name:protected] => Worcestershire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire
[_standfirst:protected] => The undulating landscape of the South Midlands is surprisingly rural.
[_description:protected] => The historic town of Worcester is a stone’s throw from [/in-your-area/warwickshire/birmingham Birmingham]’s suburbia and Shakespeare’s Stratford. Surrounded by gentle countryside, Worcestershire is blessed with numerous waterways, long stretches of delightful scenery, pretty towns and fascinating canal architecture such as the Tardebigge Flight and [/in-your-area/worcestershire/places-to-go/470/stourport-basins Stourport Basins].
[_id:protected] => 22
[_url_name] => worcestershire
)
[_easting:protected] => 400050
[_northing:protected] => 268748
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Tardebigge
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire/tardebigge
[_standfirst:protected] => The thirty locks in the Tardebigge Flight make it the largest flight of locks in Britain, and raise the [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] up 220 feet through some delightful rolling countryside just southeast of Bromsgrove.
[_description:protected] => At Bridge 54, about three quarters of a mile before Tardebigge top lock is Tardebigge reservoir, a popular local spot for fishing. At Tardebigge Top Lock there is a plaque to commemorate the 1946 founding of the Inland Waterways Association - today still the most important waterways conservation pressure group. LTC (Tom) Rolt and Robert Aickman hatched their initial plans here on //Cressy//, Rolt's narrowboat.
Tardebigge itself, just south at the same point, is a charming village centred around its imposing 18th Century church. Beyond Tardebigge Top Lock, boaters will find in short order Tardebigge Tunnel (580yards) and Shortwood Tunnel (612yards).
[_id:protected] => 36
[_url_name] => tardebigge
)
[_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] => 400050
[y] => 268748
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20777
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 34
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 408781
[_min_northing:private] => 250661
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 384300
[_centre_northing:private] => 254840
[_name:protected] => Worcestershire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire
[_standfirst:protected] => The undulating landscape of the South Midlands is surprisingly rural.
[_description:protected] => The historic town of Worcester is a stone’s throw from [/in-your-area/warwickshire/birmingham Birmingham]’s suburbia and Shakespeare’s Stratford. Surrounded by gentle countryside, Worcestershire is blessed with numerous waterways, long stretches of delightful scenery, pretty towns and fascinating canal architecture such as the Tardebigge Flight and [/in-your-area/worcestershire/places-to-go/470/stourport-basins Stourport Basins].
[_id:protected] => 22
[_url_name] => worcestershire
)
[_easting:protected] => 400050
[_northing:protected] => 268748
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Tardebigge
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire/tardebigge
[_standfirst:protected] => The thirty locks in the Tardebigge Flight make it the largest flight of locks in Britain, and raise the [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] up 220 feet through some delightful rolling countryside just southeast of Bromsgrove.
[_description:protected] => At Bridge 54, about three quarters of a mile before Tardebigge top lock is Tardebigge reservoir, a popular local spot for fishing. At Tardebigge Top Lock there is a plaque to commemorate the 1946 founding of the Inland Waterways Association - today still the most important waterways conservation pressure group. LTC (Tom) Rolt and Robert Aickman hatched their initial plans here on //Cressy//, Rolt's narrowboat.
Tardebigge itself, just south at the same point, is a charming village centred around its imposing 18th Century church. Beyond Tardebigge Top Lock, boaters will find in short order Tardebigge Tunnel (580yards) and Shortwood Tunnel (612yards).
[_id:protected] => 36
[_url_name] => tardebigge
)
[_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(400050-wp.easting,2)+pow(268748-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 town_id FROM town WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[115] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[116] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[117] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[118] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[119] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[121] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[122] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[123] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[124] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[125] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[126] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[127] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[129] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[130] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[131] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[132] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[135] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[136] => 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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-m.northing,2)) ASC
)
)
[queryCounter] => 137
)
)
[_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(400050-wp.easting,2)+pow(268748-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 town_id FROM town WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[115] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[116] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[117] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[118] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[119] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[121] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[122] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[123] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[124] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[125] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[126] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[127] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[129] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[130] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[131] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[132] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[135] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[136] => 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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-m.northing,2)) ASC
)
)
[queryCounter] => 137
)
)
)
[_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(400050-wp.easting,2)+pow(268748-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 town_id FROM town WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[115] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[116] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[117] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[118] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[119] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[121] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[122] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[123] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[124] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[125] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[126] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[127] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[129] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[130] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[131] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[132] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[135] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[136] => 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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-m.northing,2)) ASC
)
)
[queryCounter] => 137
)
)
)
[_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(400050-wp.easting,2)+pow(268748-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 town_id FROM town WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[115] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[116] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[117] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[118] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[119] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[121] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[122] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[123] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[124] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[125] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[126] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[127] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[129] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[130] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[131] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[132] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[135] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[136] => 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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-m.northing,2)) ASC
)
)
[queryCounter] => 137
)
)
[_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(400050-wp.easting,2)+pow(268748-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 town_id FROM town WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[115] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[116] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[117] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[118] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[119] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[121] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[122] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[123] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[124] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[125] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[126] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[127] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[129] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[130] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[131] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[132] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[135] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[136] => 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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-m.northing,2)) ASC
)
)
[queryCounter] => 137
)
)
)
[_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(400050-wp.easting,2)+pow(268748-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 town_id FROM town WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[115] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[116] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[117] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[118] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[119] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[121] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[122] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[123] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[124] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[125] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[126] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[127] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[129] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[130] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[131] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[132] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[135] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[136] => 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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-m.northing,2)) ASC
)
)
[queryCounter] => 137
)
)
)
[_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] => 3364
[_view_component_id:protected] => 154
[_instance_name:protected] => directory_page
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/worcestershire/tardebigge/walking
[_path:private] => /in-your-area/worcestershire/tardebigge/walking
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/worcestershire/tardebigge/walking
[PHPSESSID] => 22794982ac65d386b9217d3dcc0b4cd9
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 13
[page_id] => 3364
[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/worcestershire/tardebigge/walking
[location] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 400050
[y] => 268748
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20777
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 34
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 408781
[_min_northing:private] => 250661
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 384300
[_centre_northing:private] => 254840
[_name:protected] => Worcestershire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire
[_standfirst:protected] => The undulating landscape of the South Midlands is surprisingly rural.
[_description:protected] => The historic town of Worcester is a stone’s throw from [/in-your-area/warwickshire/birmingham Birmingham]’s suburbia and Shakespeare’s Stratford. Surrounded by gentle countryside, Worcestershire is blessed with numerous waterways, long stretches of delightful scenery, pretty towns and fascinating canal architecture such as the Tardebigge Flight and [/in-your-area/worcestershire/places-to-go/470/stourport-basins Stourport Basins].
[_id:protected] => 22
[_url_name] => worcestershire
)
[_easting:protected] => 400050
[_northing:protected] => 268748
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Tardebigge
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire/tardebigge
[_standfirst:protected] => The thirty locks in the Tardebigge Flight make it the largest flight of locks in Britain, and raise the [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] up 220 feet through some delightful rolling countryside just southeast of Bromsgrove.
[_description:protected] => At Bridge 54, about three quarters of a mile before Tardebigge top lock is Tardebigge reservoir, a popular local spot for fishing. At Tardebigge Top Lock there is a plaque to commemorate the 1946 founding of the Inland Waterways Association - today still the most important waterways conservation pressure group. LTC (Tom) Rolt and Robert Aickman hatched their initial plans here on //Cressy//, Rolt's narrowboat.
Tardebigge itself, just south at the same point, is a charming village centred around its imposing 18th Century church. Beyond Tardebigge Top Lock, boaters will find in short order Tardebigge Tunnel (580yards) and Shortwood Tunnel (612yards).
[_id:protected] => 36
[_url_name] => tardebigge
)
[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] => 400050
[y] => 268748
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20777
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 34
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 408781
[_min_northing:private] => 250661
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 384300
[_centre_northing:private] => 254840
[_name:protected] => Worcestershire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire
[_standfirst:protected] => The undulating landscape of the South Midlands is surprisingly rural.
[_description:protected] => The historic town of Worcester is a stone’s throw from [/in-your-area/warwickshire/birmingham Birmingham]’s suburbia and Shakespeare’s Stratford. Surrounded by gentle countryside, Worcestershire is blessed with numerous waterways, long stretches of delightful scenery, pretty towns and fascinating canal architecture such as the Tardebigge Flight and [/in-your-area/worcestershire/places-to-go/470/stourport-basins Stourport Basins].
[_id:protected] => 22
[_url_name] => worcestershire
)
[_easting:protected] => 400050
[_northing:protected] => 268748
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Tardebigge
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/worcestershire/tardebigge
[_standfirst:protected] => The thirty locks in the Tardebigge Flight make it the largest flight of locks in Britain, and raise the [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] up 220 feet through some delightful rolling countryside just southeast of Bromsgrove.
[_description:protected] => At Bridge 54, about three quarters of a mile before Tardebigge top lock is Tardebigge reservoir, a popular local spot for fishing. At Tardebigge Top Lock there is a plaque to commemorate the 1946 founding of the Inland Waterways Association - today still the most important waterways conservation pressure group. LTC (Tom) Rolt and Robert Aickman hatched their initial plans here on //Cressy//, Rolt's narrowboat.
Tardebigge itself, just south at the same point, is a charming village centred around its imposing 18th Century church. Beyond Tardebigge Top Lock, boaters will find in short order Tardebigge Tunnel (580yards) and Shortwood Tunnel (612yards).
[_id:protected] => 36
[_url_name] => tardebigge
)
[_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(400050-wp.easting,2)+pow(268748-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 town_id FROM town WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[115] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[116] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[117] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[118] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[119] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[121] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[122] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[123] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[124] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[125] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[126] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[127] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[129] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[130] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[131] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[132] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[135] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[136] => 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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-m.northing,2)) ASC
)
)
[queryCounter] => 137
)
)
[_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(400050-wp.easting,2)+pow(268748-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 town_id FROM town WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[115] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[116] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[117] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[118] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[119] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[121] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[122] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[123] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[124] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[125] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[126] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[127] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[129] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[130] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[131] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[132] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[135] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[136] => 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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-m.northing,2)) ASC
)
)
[queryCounter] => 137
)
)
)
[_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(400050-wp.easting,2)+pow(268748-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 town_id FROM town WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[115] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[116] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[117] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[118] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[119] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[121] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[122] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[123] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[124] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[125] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[126] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[127] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[129] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[130] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[131] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[132] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[135] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[136] => 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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-m.northing,2)) ASC
)
)
[queryCounter] => 137
)
)
)
[_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(400050-wp.easting,2)+pow(268748-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 town_id FROM town WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[115] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[116] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[117] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[118] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[119] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[121] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[122] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[123] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[124] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[125] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[126] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[127] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[129] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[130] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[131] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[132] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[135] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[136] => 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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-m.northing,2)) ASC
)
)
[queryCounter] => 137
)
)
)
[_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(400050-wp.easting,2)+pow(268748-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 town_id FROM town WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[115] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[116] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[117] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[118] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[119] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[121] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[122] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[123] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[124] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[125] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[126] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[127] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[129] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[130] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[131] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[132] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[135] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[136] => 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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-m.northing,2)) ASC
)
)
[queryCounter] => 137
)
)
)
[_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(400050-wp.easting,2)+pow(268748-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 town_id FROM town WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[115] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[116] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[117] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[118] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[119] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[121] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[122] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[123] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[124] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[125] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[126] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[127] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[129] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[130] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[131] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[132] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[134] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[135] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[136] => 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(400050-m.easting,2)+pow(268748-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(400050-m.easting,2)+pow(268748-m.northing,2)) ASC
)
)
[queryCounter] => 137
)
)
)
[_route_manager:private] => Waterscape_Service_RouteManager Object
(
[_route_dao:private] => Waterscape_Dao_Route Object
(
[_route_type_manager:private] => Waterscape_Service_RouteTypeManager Object
(
[_route_type_dao:private] => Waterscape_Dao_RouteType Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT 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(400050-wp.easting,2)+pow(268748-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 town_id FROM town WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[115] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[116] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)