Cycling near Greenfield
Cyclists in Lancashire may have a rugged landscape to contend with, but they are amply rewarded with stunning views.
But if hills are not your thing, the level towpaths of Lancashire’s waterways may offer a solution. Cyclists can get about in Lancaster along the Lancaster Canal, the Leeds & Liverpool Canal and the two exciting miles of new cycleway now open along the Ribble Link. To cycle here you will need a British Waterways cycle permit.
For cycling routes around Lancaster and Morcambe visit www.celebratingcycling.org
Cycling routes
Towpath Stoppages
There are no stoppages reported at this time.
PDOException Object
(
[message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.nationwide' in 'where clause'
[string:private] =>
[code:protected] => 42S22
[file:protected] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line:protected] => 53
[trace:private] => Array
(
[0] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 53
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 16
[function] => getUnlimitedQueryRowCount
[class] => Waterscape_Database_RecordSet_Paged
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county, sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY sqrt(pow(398989-m.easting,2)+pow(404115-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(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY sqrt(pow(398989-m.easting,2)+pow(404115-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(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY sqrt(pow(398989-m.easting,2)+pow(404115-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] => 7
[_name:protected] => Cycling
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT 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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE 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 county_id FROM county WHERE urlname = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[18] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[19] => 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(398989-wp.easting,2)+pow(404115-wp.northing,2)) <= 16000 AND rt.type_id = 2
)
[20] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[59] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[60] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[76] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[94] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[96] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[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 * FROM town WHERE town_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[108] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[110] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[111] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[112] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[114] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[116] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[117] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[118] => 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
)
[119] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[120] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[121] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[122] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[123] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[124] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[125] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[126] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[128] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[129] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[130] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[131] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[134] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[135] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[136] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[137] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[138] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[139] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[140] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[142] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[143] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[144] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[145] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[146] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[148] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[149] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[150] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[151] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[152] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[153] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[154] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[155] => 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY sqrt(pow(398989-m.easting,2)+pow(404115-m.northing,2)) ASC
)
)
[queryCounter] => 156
)
)
)
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] =>
[_coordinates:protected] => Array
(
)
[_coordinates_size:protected] =>
[_id:protected] =>
)
[_class:protected] => 1
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 18
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 330414
[_min_northing:private] => 431640
[_max_easting:private] => 640319
[_max_northing:private] => 588517
[_centre_easting:private] => 358040
[_centre_northing:private] => 417740
[_name:protected] => Lancashire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lancashire
[_standfirst:protected] => Discover the gems of the hidden North West.
[_description:protected] => Lancashire is a land of contrasts; rolling countryside leads to industrial centres while great waterway heritage, such as the [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct], stands out against unpretentious market towns. The Millennium [/canals-and-rivers/ribble-link Ribble Link] is the gateway to the rest of the waterway world. Discover the great cities and explore the urban buzz of [/in-your-area/lancashire/manchester Manchester] which is complimented by impressive canal architecture. Explore the innovative [/canals-and-rivers/bridgewater-canal Bridgewater Canal] and watch the ships cruise the ‘Big Ditch’.
[/media/documents/22215.pdf Download a Guide and map to Liverpool's canal and docks]
[/media/documents/21892.pdf Download the Ribble Coast and Wetlands Walking Festival leaflet]
[_id:protected] => 33
[_url_name] => lancashire
)
[_easting:protected] => 398989
[_northing:protected] => 404115
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Greenfield
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lancashire/greenfield
[_standfirst:protected] =>
[_description:protected] =>
[_id:protected] => 6284
[_url_name] => greenfield
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] => 1
[_page_limit:private] => 9
)
)
)
[5] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 48
[function] => initItems
[class] => Waterscape_Component_DirectoryListingPage
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 7
[_name:protected] => Cycling
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT 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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE 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 county_id FROM county WHERE urlname = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[18] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[19] => 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(398989-wp.easting,2)+pow(404115-wp.northing,2)) <= 16000 AND rt.type_id = 2
)
[20] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[59] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[60] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[76] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[94] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[96] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[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 * FROM town WHERE town_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[108] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[110] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[111] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[112] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[114] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[116] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[117] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[118] => 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
)
[119] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[120] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[121] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[122] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[123] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[124] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[125] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[126] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[128] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[129] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[130] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[131] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[134] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[135] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[136] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[137] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[138] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[139] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[140] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[142] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[143] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[144] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[145] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[146] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[148] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[149] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[150] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[151] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[152] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[153] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[154] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[155] => 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY sqrt(pow(398989-m.easting,2)+pow(404115-m.northing,2)) ASC
)
)
[queryCounter] => 156
)
)
)
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] =>
[_coordinates:protected] => Array
(
)
[_coordinates_size:protected] =>
[_id:protected] =>
)
[_class:protected] => 1
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 18
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 330414
[_min_northing:private] => 431640
[_max_easting:private] => 640319
[_max_northing:private] => 588517
[_centre_easting:private] => 358040
[_centre_northing:private] => 417740
[_name:protected] => Lancashire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lancashire
[_standfirst:protected] => Discover the gems of the hidden North West.
[_description:protected] => Lancashire is a land of contrasts; rolling countryside leads to industrial centres while great waterway heritage, such as the [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct], stands out against unpretentious market towns. The Millennium [/canals-and-rivers/ribble-link Ribble Link] is the gateway to the rest of the waterway world. Discover the great cities and explore the urban buzz of [/in-your-area/lancashire/manchester Manchester] which is complimented by impressive canal architecture. Explore the innovative [/canals-and-rivers/bridgewater-canal Bridgewater Canal] and watch the ships cruise the ‘Big Ditch’.
[/media/documents/22215.pdf Download a Guide and map to Liverpool's canal and docks]
[/media/documents/21892.pdf Download the Ribble Coast and Wetlands Walking Festival leaflet]
[_id:protected] => 33
[_url_name] => lancashire
)
[_easting:protected] => 398989
[_northing:protected] => 404115
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Greenfield
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lancashire/greenfield
[_standfirst:protected] =>
[_description:protected] =>
[_id:protected] => 6284
[_url_name] => greenfield
)
[_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] =>
[_coordinates:protected] => Array
(
)
[_coordinates_size:protected] =>
[_id:protected] =>
)
[_class:protected] => 1
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 18
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 330414
[_min_northing:private] => 431640
[_max_easting:private] => 640319
[_max_northing:private] => 588517
[_centre_easting:private] => 358040
[_centre_northing:private] => 417740
[_name:protected] => Lancashire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lancashire
[_standfirst:protected] => Discover the gems of the hidden North West.
[_description:protected] => Lancashire is a land of contrasts; rolling countryside leads to industrial centres while great waterway heritage, such as the [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct], stands out against unpretentious market towns. The Millennium [/canals-and-rivers/ribble-link Ribble Link] is the gateway to the rest of the waterway world. Discover the great cities and explore the urban buzz of [/in-your-area/lancashire/manchester Manchester] which is complimented by impressive canal architecture. Explore the innovative [/canals-and-rivers/bridgewater-canal Bridgewater Canal] and watch the ships cruise the ‘Big Ditch’.
[/media/documents/22215.pdf Download a Guide and map to Liverpool's canal and docks]
[/media/documents/21892.pdf Download the Ribble Coast and Wetlands Walking Festival leaflet]
[_id:protected] => 33
[_url_name] => lancashire
)
[_easting:protected] => 398989
[_northing:protected] => 404115
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Greenfield
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lancashire/greenfield
[_standfirst:protected] =>
[_description:protected] =>
[_id:protected] => 6284
[_url_name] => greenfield
)
[_preposition:private] => near
[_descriptor:private] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 7
[_name:protected] => Cycling
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT 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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE 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 county_id FROM county WHERE urlname = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[18] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[19] => 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(398989-wp.easting,2)+pow(404115-wp.northing,2)) <= 16000 AND rt.type_id = 2
)
[20] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[59] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[60] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[76] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[94] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[96] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[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 * FROM town WHERE town_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[108] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[110] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[111] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[112] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[114] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[116] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[117] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[118] => 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
)
[119] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[120] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[121] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[122] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[123] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[124] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[125] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[126] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[128] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[129] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[130] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[131] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[134] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[135] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[136] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[137] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[138] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[139] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[140] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[142] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[143] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[144] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[145] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[146] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[148] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[149] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[150] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[151] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[152] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[153] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[154] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[155] => 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY sqrt(pow(398989-m.easting,2)+pow(404115-m.northing,2)) ASC
)
)
[queryCounter] => 156
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE 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 county_id FROM county WHERE urlname = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[18] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[19] => 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(398989-wp.easting,2)+pow(404115-wp.northing,2)) <= 16000 AND rt.type_id = 2
)
[20] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[59] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[60] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[76] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[94] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[96] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[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 * FROM town WHERE town_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[108] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[110] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[111] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[112] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[114] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[116] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[117] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[118] => 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
)
[119] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[120] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[121] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[122] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[123] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[124] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[125] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[126] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[128] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[129] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[130] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[131] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[134] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[135] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[136] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[137] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[138] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[139] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[140] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[142] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[143] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[144] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[145] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[146] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[148] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[149] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[150] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[151] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[152] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[153] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[154] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[155] => 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY sqrt(pow(398989-m.easting,2)+pow(404115-m.northing,2)) ASC
)
)
[queryCounter] => 156
)
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE 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 county_id FROM county WHERE urlname = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[18] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[19] => 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(398989-wp.easting,2)+pow(404115-wp.northing,2)) <= 16000 AND rt.type_id = 2
)
[20] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[59] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[60] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[76] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[94] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[96] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[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 * FROM town WHERE town_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[108] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[110] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[111] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[112] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[114] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[116] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[117] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[118] => 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
)
[119] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[120] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[121] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[122] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[123] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[124] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[125] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[126] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[128] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[129] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[130] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[131] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[134] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[135] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[136] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[137] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[138] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[139] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[140] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[142] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[143] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[144] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[145] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[146] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[148] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[149] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[150] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[151] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[152] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[153] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[154] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[155] => 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY sqrt(pow(398989-m.easting,2)+pow(404115-m.northing,2)) ASC
)
)
[queryCounter] => 156
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE 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 county_id FROM county WHERE urlname = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[18] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[19] => 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(398989-wp.easting,2)+pow(404115-wp.northing,2)) <= 16000 AND rt.type_id = 2
)
[20] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[59] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[60] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[76] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[94] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[96] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[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 * FROM town WHERE town_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[108] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[110] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[111] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[112] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[114] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[116] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[117] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[118] => 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
)
[119] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[120] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[121] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[122] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[123] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[124] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[125] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[126] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[128] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[129] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[130] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[131] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[134] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[135] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[136] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[137] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[138] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[139] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[140] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[142] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[143] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[144] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[145] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[146] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[148] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[149] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[150] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[151] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[152] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[153] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[154] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[155] => 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY sqrt(pow(398989-m.easting,2)+pow(404115-m.northing,2)) ASC
)
)
[queryCounter] => 156
)
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE 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 county_id FROM county WHERE urlname = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[18] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[19] => 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(398989-wp.easting,2)+pow(404115-wp.northing,2)) <= 16000 AND rt.type_id = 2
)
[20] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[59] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[60] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[76] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[94] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[96] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[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 * FROM town WHERE town_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[108] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[110] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[111] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[112] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[114] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[116] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[117] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[118] => 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
)
[119] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[120] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[121] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[122] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[123] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[124] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[125] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[126] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[128] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[129] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[130] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[131] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[134] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[135] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[136] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[137] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[138] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[139] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[140] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[142] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[143] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[144] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[145] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[146] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[148] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[149] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[150] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[151] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[152] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[153] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[154] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[155] => 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY sqrt(pow(398989-m.easting,2)+pow(404115-m.northing,2)) ASC
)
)
[queryCounter] => 156
)
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_town_manager:private] =>
[_limit:protected] =>
[_title:protected] => Cycle hire, clubs & services
[_items:protected] =>
[_is_paginated:protected] => 1
[_component_id:protected] => 14
[_parent_id:protected] =>
[_template:protected] => Component/ListingPage.tpl
[_page_id:protected] => 272027
[_view_component_id:protected] => 152
[_instance_name:protected] => directory_page
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/lancashire/greenfield/cycling
[_path:private] => /in-your-area/lancashire/greenfield/cycling
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/lancashire/greenfield/cycling
[PHPSESSID] => 1df89a73cfb2e714d3936204af43b0c2
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 12
[page_id] => 272027
[view_name] => locations_cycling
[title] => Cycling And Cycle Routes %LOCATION_PREPOSITION% %LOCATION_NAME% %LOCATION_COUNTY_NAME% | Canals and Rivers | Waterscape.com
[keywords] =>
[description] =>
[layout_template] => Page/locations/location.tpl
[template] => Page/locations/cycling.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Locations
[path] => /in-your-area/lancashire/greenfield/cycling
[location] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] =>
[_coordinates:protected] => Array
(
)
[_coordinates_size:protected] =>
[_id:protected] =>
)
[_class:protected] => 1
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 18
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 330414
[_min_northing:private] => 431640
[_max_easting:private] => 640319
[_max_northing:private] => 588517
[_centre_easting:private] => 358040
[_centre_northing:private] => 417740
[_name:protected] => Lancashire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lancashire
[_standfirst:protected] => Discover the gems of the hidden North West.
[_description:protected] => Lancashire is a land of contrasts; rolling countryside leads to industrial centres while great waterway heritage, such as the [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct], stands out against unpretentious market towns. The Millennium [/canals-and-rivers/ribble-link Ribble Link] is the gateway to the rest of the waterway world. Discover the great cities and explore the urban buzz of [/in-your-area/lancashire/manchester Manchester] which is complimented by impressive canal architecture. Explore the innovative [/canals-and-rivers/bridgewater-canal Bridgewater Canal] and watch the ships cruise the ‘Big Ditch’.
[/media/documents/22215.pdf Download a Guide and map to Liverpool's canal and docks]
[/media/documents/21892.pdf Download the Ribble Coast and Wetlands Walking Festival leaflet]
[_id:protected] => 33
[_url_name] => lancashire
)
[_easting:protected] => 398989
[_northing:protected] => 404115
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Greenfield
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lancashire/greenfield
[_standfirst:protected] =>
[_description:protected] =>
[_id:protected] => 6284
[_url_name] => greenfield
)
[preposition] => near
[section] => cycling
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] =>
[_coordinates:protected] => Array
(
)
[_coordinates_size:protected] =>
[_id:protected] =>
)
[_class:protected] => 1
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 18
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 330414
[_min_northing:private] => 431640
[_max_easting:private] => 640319
[_max_northing:private] => 588517
[_centre_easting:private] => 358040
[_centre_northing:private] => 417740
[_name:protected] => Lancashire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lancashire
[_standfirst:protected] => Discover the gems of the hidden North West.
[_description:protected] => Lancashire is a land of contrasts; rolling countryside leads to industrial centres while great waterway heritage, such as the [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct], stands out against unpretentious market towns. The Millennium [/canals-and-rivers/ribble-link Ribble Link] is the gateway to the rest of the waterway world. Discover the great cities and explore the urban buzz of [/in-your-area/lancashire/manchester Manchester] which is complimented by impressive canal architecture. Explore the innovative [/canals-and-rivers/bridgewater-canal Bridgewater Canal] and watch the ships cruise the ‘Big Ditch’.
[/media/documents/22215.pdf Download a Guide and map to Liverpool's canal and docks]
[/media/documents/21892.pdf Download the Ribble Coast and Wetlands Walking Festival leaflet]
[_id:protected] => 33
[_url_name] => lancashire
)
[_easting:protected] => 398989
[_northing:protected] => 404115
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Greenfield
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lancashire/greenfield
[_standfirst:protected] =>
[_description:protected] =>
[_id:protected] => 6284
[_url_name] => greenfield
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE 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 county_id FROM county WHERE urlname = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[18] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[19] => 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(398989-wp.easting,2)+pow(404115-wp.northing,2)) <= 16000 AND rt.type_id = 2
)
[20] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[59] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[60] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[76] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[94] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[96] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[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 * FROM town WHERE town_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[108] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[110] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[111] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[112] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[114] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[116] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[117] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[118] => 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
)
[119] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[120] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[121] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[122] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[123] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[124] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[125] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[126] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[128] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[129] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[130] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[131] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[134] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[135] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[136] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[137] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[138] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[139] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[140] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[142] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[143] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[144] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[145] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[146] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[148] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[149] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[150] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[151] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[152] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[153] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[154] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[155] => 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY sqrt(pow(398989-m.easting,2)+pow(404115-m.northing,2)) ASC
)
)
[queryCounter] => 156
)
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_navigation_authority_dao:private] => Waterscape_Dao_NavigationAuthority Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
[_stoppage_manager:private] => Waterscape_Service_StoppageManager Object
(
[_stoppage_dao:private] => Waterscape_Dao_Stoppage Object
(
[_waterway_mgr:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion Object
(
[_db:protected] =>
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType Object
(
[_db:protected] =>
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription Object
(
[_db:protected] =>
)
)
[_criteria:private] => Array
(
)
[_raw_criteria:private] =>
[_sql_strings:private] => Array
(
)
[_sql_values:private] => Array
(
)
[_search_data_by:private] => Array
(
[all] => 0
[stoppage] => s
[restriction] => r
[opening_times] => o
[booking_details] => b
[advice] => a
[towpath_closure_only] => t
)
[_str_types_selected:private] =>
[_stoppage_type:private] =>
[_db:protected] => 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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE 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 county_id FROM county WHERE urlname = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[18] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[19] => 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(398989-wp.easting,2)+pow(404115-wp.northing,2)) <= 16000 AND rt.type_id = 2
)
[20] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[59] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[60] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[76] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[94] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[96] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[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 * FROM town WHERE town_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[108] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[110] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[111] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[112] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[114] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[116] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[117] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[118] => 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
)
[119] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[120] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[121] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[122] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[123] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[124] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[125] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[126] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[128] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[129] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[130] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[131] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[134] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[135] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[136] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[137] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[138] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[139] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[140] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[142] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[143] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[144] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[145] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[146] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[148] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[149] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[150] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[151] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[152] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[153] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[154] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[155] => 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY sqrt(pow(398989-m.easting,2)+pow(404115-m.northing,2)) ASC
)
)
[queryCounter] => 156
)
)
)
[_route_manager:private] => Waterscape_Service_RouteManager Object
(
[_route_dao:private] => Waterscape_Dao_Route Object
(
[_route_type_manager:private] => Waterscape_Service_RouteTypeManager Object
(
[_route_type_dao:private] => Waterscape_Dao_RouteType Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_waypoint_manager:private] => Waterscape_Service_WaypointManager Object
(
[_waypoint_dao:private] => Waterscape_Dao_Waypoint Object
(
[_metadata_mgr:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_geo_point_mgr:private] =>
[_geo_data_type_manager:private] => Waterscape_Service_GeoDataTypeManager Object
(
[_geo_data_dao:private] => Waterscape_Dao_GeoDataType Object
(
[_db:protected] =>
)
)
[_db:protected] =>
[_geo_point_manager] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE 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 county_id FROM county WHERE urlname = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[18] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[19] => 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(398989-wp.easting,2)+pow(404115-wp.northing,2)) <= 16000 AND rt.type_id = 2
)
[20] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[59] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[60] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[76] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[94] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[96] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[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 * FROM town WHERE town_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[108] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[110] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[111] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[112] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[114] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[116] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[117] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[118] => 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
)
[119] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[120] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[121] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[122] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[123] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[124] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[125] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[126] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[128] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[129] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[130] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[131] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[134] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[135] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[136] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[137] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[138] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[139] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[140] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[142] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[143] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[144] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[145] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[146] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[148] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[149] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[150] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[151] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[152] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[153] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[154] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[155] => 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY sqrt(pow(398989-m.easting,2)+pow(404115-m.northing,2)) ASC
)
)
[queryCounter] => 156
)
)
)
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE 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 county_id FROM county WHERE urlname = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[18] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[19] => 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(398989-wp.easting,2)+pow(404115-wp.northing,2)) <= 16000 AND rt.type_id = 2
)
[20] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[59] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[60] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[76] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[94] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[96] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[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 * FROM town WHERE town_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[108] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[110] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[111] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[112] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[114] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[116] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[117] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[118] => 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
)
[119] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[120] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[121] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[122] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[123] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[124] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[125] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[126] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[128] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[129] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[130] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[131] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[134] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[135] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[136] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[137] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[138] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[139] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[140] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[142] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[143] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[144] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[145] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[146] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[148] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[149] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[150] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[151] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[152] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[153] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[154] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[155] => 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY sqrt(pow(398989-m.easting,2)+pow(404115-m.northing,2)) ASC
)
)
[queryCounter] => 156
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE 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 county_id FROM county WHERE urlname = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[18] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[19] => 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(398989-wp.easting,2)+pow(404115-wp.northing,2)) <= 16000 AND rt.type_id = 2
)
[20] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[59] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[60] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[76] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[94] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[96] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[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 * FROM town WHERE town_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[108] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[110] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[111] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[112] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[114] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[116] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[117] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[118] => 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
)
[119] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[120] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[121] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[122] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[123] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[124] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[125] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[126] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[128] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[129] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[130] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[131] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[133] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[134] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[135] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[136] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[137] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[138] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[139] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[140] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[142] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[143] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[144] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[145] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[146] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[148] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[149] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[150] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[151] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[152] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[153] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[154] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[155] => 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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND sqrt(pow(398989-m.easting,2)+pow(404115-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 = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY sqrt(pow(398989-m.easting,2)+pow(404115-m.northing,2)) ASC
)
)
[queryCounter] => 156
)
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE 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 county_id FROM county WHERE urlname = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[18] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[19] => 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(398989-wp.easting,2)+pow(404115-wp.northing,2)) <= 16000 AND rt.type_id = 2
)
[20] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[34] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[36] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[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 * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[59] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[60] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[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 metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[76] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[82] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[85] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[91] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[93] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[94] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[96] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT config_value FROM content_page_component_configuration WHERE page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT config_value FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[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 * FROM town WHERE town_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[108] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[109] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[110] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[111] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[112] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[113] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[114] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[116] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[117] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[118] => 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
)
[119] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[120] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[121] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[122] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[123] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[124] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[125] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[126] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[128] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[129] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[130] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[131] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?