Cycling in Lowlands
There are two reasons why towpath cycling is such a great way to get around the Lowlands.
For one thing, canal towpaths cross some of the most stunning scenery Scotland has to offer; for the other, they are (almost) entirely flat.
The towpaths of the Forth & Clyde were restored with cycling in mind. Pedal from Dalmuir to Bowland – and then continue along the [Glasgow to Loch Lomond cycleway and explore the network of nearby forest trails. If this sounds far too energetic, you can hire your bikes from Luss and take a relaxing ride along the purpose-built cycle path north to Firkin Point and Tarbet. Alternatively, head south to the shores of Loch Lomond.
The River Tay winds through stunning scenery and interesting woodlands, and cycling along it will no doubt take your breath away. A section of the National Cycle Network follows the route of the Tay.
Cycling routes
- Bathgate: 28 mile Cycle Tour »
- Cycling the Cheshire Cycleway »
- Cycling from Edinburgh to The Falkirk Wheel »
- Penrith to Langwathby »
- Solway Firth Coastline »
- Linlithgow to Blackness Castle »
- Stanhope Circular Route Four »
- Stanhope Circular Route One »
- Stanhope Circular Route Three »
- Stanhope Circular Route Two »
- The Witchs Trails »
- Laggan Wolftrax »
- The Marriots Way »
Towpath Stoppages
28 Sep 2006 until further notice
Advice: Bridge 4, Dover Bridge - Leigh Branch
Associated Regional Office: BW North-WestTowpath has been closed
The towpath here has been temporarily closed to customers. This is due to failed timber supports on this section beneath the bridge. British Waterways apologise for any inconvenience caused.
(Enquiries: 01942 405 700 )
29 Jun 2009 until further notice
Towpath Closure only: Armley Mills to Kirkstall Brewery Towpath Improvements
Associated Regional Office: BW YorkshireTowpath improvement works on the Leeds & Liverpool Canal. Phased works will be undertaken over approximately a 20-week period during which time sections of the towpath will need to be closed. However, efforts will be made to minimise disruption wherever possible. Suggested route diversions are shown in the maps displayed on site. We apologise for any inconvenience caused and thank you for your patience during this time.
This work is a partnership scheme between BW, Leeds City Council and Sustrans to deliver an improved and more durable multi-user towpath route.
For further information contact:
British Waterways: Business Support Team on 0113 281 6860
Leeds City Council: Site Contract Supervisor on 0113 247 5505
(Enquiries: 0113 281 6860)
04 Jan 2010 until further notice
Towpath Closure only: Bridge 71 Rawlinson lane & Bridge 68 Redhouse Bridge on the Leeds & Liverpool canal
Associated Regional Office: North West WaterwaysA closure to the towpath is required on the Leeds and Liverpool Canal between Rawlinson Lane Bridge and Red House Bridge, for a distance of approximately 2KM, navigation should not be affected during this project.
British Waterways have received Funding to undertake towpath & wash wall improvements on the Leeds & Liverpool Canal between Rawlinson Lane Bridge 71 & Red House Bridge 68.
In the interest of public Health & Safety the towpath will be closed to the general public intermittently throughout January 2010 to April 2010 during the construction phase of this project.
An update notice will be issued on when construction is complete.
Please accept our apologies for any inconvenience caused.
(Enquiries: 01942405700)
09 Nov 2010 - 18 Dec 2009
Stoppage: Eldonian Way Road Bridge
Associated Regional Office: North West WaterwaysTowpath has been closed
Highway bridge maintenance by Liverpool City Council
Closure only affects Eldonian Village arm. Winding available at junction Stanley Flight
(Enquiries: 01942 405700)
PDOException Object
(
[message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.nationwide' in 'where clause'
[string:private] =>
[code:protected] => 42S22
[file:protected] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line:protected] => 53
[trace:private] => Array
(
[0] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 53
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 16
[function] => getUnlimitedQueryRowCount
[class] => Waterscape_Database_RecordSet_Paged
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
[1] => Array
(
)
)
)
[2] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database.php
[line] => 136
[function] => __construct
[class] => Waterscape_Database_RecordSet_Paged
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
[1] => Array
(
)
[2] => 1
[3] => 9
)
)
[3] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Directory/Finder/Abstract.php
[line] => 62
[function] => getPagedRecordSet
[class] => Waterscape_Database
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
[1] => 1
[2] => 9
)
)
[4] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 133
[function] => find
[class] => Waterscape_Directory_Finder_Abstract
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 7
[_name:protected] => Cycling
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
)
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 39
[_os_country_code:private] => 179
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 352903
[_min_northing:private] => 868189
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 284980
[_centre_northing:private] => 680960
[_name:protected] => Lowlands
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lowlands
[_standfirst:protected] => Golden eagles soar above the land of Braveheart and Mary Queen of Scots.
[_description:protected] => Ancient castles, a turbulent history, and the innovative 21st century [/in-your-area/lowlands/places-to-go/496/the-falkirk-wheel Falkirk Wheel] - welcome to the Scottish Lowlands. Cruise the [/canals-and-rivers/union-canal Union Canal] into the heart of Edinburgh, stroll around the picturesque Loch Lomond or don your walking boots and explore the wild Trossachs.
++Photograph & Art Competition Winners 2008
The results are in! To find the full list of winners click [/features-and-articles/features/scottish-canals-photography-competition-2008 here].
View some [http://www.images-scotland.com images of Scotland]
[_id:protected] => 43
[_url_name] => lowlands
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
)
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 39
[_os_country_code:private] => 179
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 352903
[_min_northing:private] => 868189
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 284980
[_centre_northing:private] => 680960
[_name:protected] => Lowlands
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lowlands
[_standfirst:protected] => Golden eagles soar above the land of Braveheart and Mary Queen of Scots.
[_description:protected] => Ancient castles, a turbulent history, and the innovative 21st century [/in-your-area/lowlands/places-to-go/496/the-falkirk-wheel Falkirk Wheel] - welcome to the Scottish Lowlands. Cruise the [/canals-and-rivers/union-canal Union Canal] into the heart of Edinburgh, stroll around the picturesque Loch Lomond or don your walking boots and explore the wild Trossachs.
++Photograph & Art Competition Winners 2008
The results are in! To find the full list of winners click [/features-and-articles/features/scottish-canals-photography-competition-2008 here].
View some [http://www.images-scotland.com images of Scotland]
[_id:protected] => 43
[_url_name] => lowlands
)
[_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_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 39
[_os_country_code:private] => 179
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 352903
[_min_northing:private] => 868189
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 284980
[_centre_northing:private] => 680960
[_name:protected] => Lowlands
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lowlands
[_standfirst:protected] => Golden eagles soar above the land of Braveheart and Mary Queen of Scots.
[_description:protected] => Ancient castles, a turbulent history, and the innovative 21st century [/in-your-area/lowlands/places-to-go/496/the-falkirk-wheel Falkirk Wheel] - welcome to the Scottish Lowlands. Cruise the [/canals-and-rivers/union-canal Union Canal] into the heart of Edinburgh, stroll around the picturesque Loch Lomond or don your walking boots and explore the wild Trossachs.
++Photograph & Art Competition Winners 2008
The results are in! To find the full list of winners click [/features-and-articles/features/scottish-canals-photography-competition-2008 here].
View some [http://www.images-scotland.com images of Scotland]
[_id:protected] => 43
[_url_name] => lowlands
)
[_preposition:private] => in
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] => 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
)
[_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] => 1815
[_view_component_id:protected] => 152
[_instance_name:protected] => directory_page
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/lowlands/cycling
[_path:private] => /in-your-area/lowlands/cycling
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/lowlands/cycling
[PHPSESSID] => 97be0cc07fb8cdf26340cbfc1667d44c
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 12
[page_id] => 1815
[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/lowlands/cycling
[location] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 39
[_os_country_code:private] => 179
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 352903
[_min_northing:private] => 868189
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 284980
[_centre_northing:private] => 680960
[_name:protected] => Lowlands
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lowlands
[_standfirst:protected] => Golden eagles soar above the land of Braveheart and Mary Queen of Scots.
[_description:protected] => Ancient castles, a turbulent history, and the innovative 21st century [/in-your-area/lowlands/places-to-go/496/the-falkirk-wheel Falkirk Wheel] - welcome to the Scottish Lowlands. Cruise the [/canals-and-rivers/union-canal Union Canal] into the heart of Edinburgh, stroll around the picturesque Loch Lomond or don your walking boots and explore the wild Trossachs.
++Photograph & Art Competition Winners 2008
The results are in! To find the full list of winners click [/features-and-articles/features/scottish-canals-photography-competition-2008 here].
View some [http://www.images-scotland.com images of Scotland]
[_id:protected] => 43
[_url_name] => lowlands
)
[preposition] => in
[section] => cycling
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 39
[_os_country_code:private] => 179
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 352903
[_min_northing:private] => 868189
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 284980
[_centre_northing:private] => 680960
[_name:protected] => Lowlands
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lowlands
[_standfirst:protected] => Golden eagles soar above the land of Braveheart and Mary Queen of Scots.
[_description:protected] => Ancient castles, a turbulent history, and the innovative 21st century [/in-your-area/lowlands/places-to-go/496/the-falkirk-wheel Falkirk Wheel] - welcome to the Scottish Lowlands. Cruise the [/canals-and-rivers/union-canal Union Canal] into the heart of Edinburgh, stroll around the picturesque Loch Lomond or don your walking boots and explore the wild Trossachs.
++Photograph & Art Competition Winners 2008
The results are in! To find the full list of winners click [/features-and-articles/features/scottish-canals-photography-competition-2008 here].
View some [http://www.images-scotland.com images of Scotland]
[_id:protected] => 43
[_url_name] => lowlands
)
[_na_office_manager:private] => Waterscape_Service_NavigationAuthorityOfficeManager Object
(
[_navigation_authority_office_dao:private] => Waterscape_Dao_NavigationAuthorityOffice Object
(
[_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_navigation_authority_dao:private] => Waterscape_Dao_NavigationAuthority Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
[_stoppage_manager:private] => Waterscape_Service_StoppageManager Object
(
[_stoppage_dao:private] => Waterscape_Dao_Stoppage Object
(
[_waterway_mgr:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
)
[_route_manager:private] => Waterscape_Service_RouteManager Object
(
[_route_dao:private] => Waterscape_Dao_Route Object
(
[_route_type_manager:private] => Waterscape_Service_RouteTypeManager Object
(
[_route_type_dao:private] => Waterscape_Dao_RouteType Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
)
[_waypoint_manager:private] => Waterscape_Service_WaypointManager Object
(
[_waypoint_dao:private] => Waterscape_Dao_Waypoint Object
(
[_metadata_mgr:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_geo_point_mgr:private] =>
[_geo_data_type_manager:private] => Waterscape_Service_GeoDataTypeManager Object
(
[_geo_data_dao:private] => Waterscape_Dao_GeoDataType Object
(
[_db:protected] =>
)
)
[_db:protected] =>
[_geo_point_manager] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] =>
)
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] => 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
)
[_media_manager:private] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[92] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[93] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[94] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[99] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[100] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[101] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => 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 a.county = 43 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 106
)
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, c.county_id AS county_id, c.name AS county_name, rt.name AS route_type FROM route r INNER JOIN county c INNER JOIN geo_data g ON g.id = c.geo_data_id 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 c.county_id = ? AND r.is_published = 1 AND CONTAINS(g.geo_data, GeomFromText(concat('POINT(',wp.easting,' ',wp.northing,')'))) = 1 AND rt.type_id = 2
)
[7] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_generic_component_configuration WHERE instance_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[28] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[31] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[54] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[55] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[71] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[72] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[73] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[74] => 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
)
[75] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[76] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[77] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[78] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[79] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[80] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[81] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[83] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[84] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[85] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[86] => Array
(
[sql] => SELECT name FROM stoppage_type WHERE id = ?
)
[87] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[88] => Array
(
[sql] => SELECT id, name, region_url FROM navigation_authority_region WHERE id = ?
)
[89] => Array
(
[sql] => SELECT description FROM stoppage_business_description WHERE id = ?
)
[90] => Array
(
[sql] => SELECT * FROM stoppage WHERE id = ?
)
[91] => Array
(
[sql] => SELECT name FROM s