Cycling along the Monmouthshire & Brecon Canal
Download a guide to cycling the towpath of the Monmouthshire & Brecon Canal. The guide includes a rating of the towpath condition for each canal section - plus comments on what to look out for, pubs, local landmarks etc.
Download your guide to cycling the Mon & Brec (published March 2010)
Cycling is permitted on the following sections of canal:
- Brecon to Brynich (3.3km)
- Llanfoist to Goytre (8.1km)
- Pontymoile Basin to Solomon's Bridge, Cwmbran (2.2km)
- Solomon's Bridge, Cwmbran to Newport (11.8km, unnavigable canal - National Cycle Network route 46)
- Crumlin Arm (National Cycle Network route 47 section)
A British Waterways cycling permit is required north of Cwmbran.
The Taff Trail is a 55-mile route along disused railways, country lanes and canal towpaths. It follows the Mon & Brec for a short while between Brecon and Brynich, as well as parts of the long-lost Glamorganshire Canal, paths alongside reservoirs, and tracks through river valleys. It starts at Cardiff, then heads inland to Pontypridd, Merthyr Tydfil, Cefn Coed and Brecon. See below for our full guide including detailed maps.
Beicio ar hyd Camlas Mynwy ac Aberhonddu
Mae caniatâd i feicio ar hyd y rhannau hyn o’r gamlas:
- Aberhonddu i Brynich (3.3km)
- Llan-ffwyst i Goetre (8.1km)
- Basn Llanfihangel Pont-y-moel i Bont Solomon, Cwmbrân (2.2km)
- Pont Solomon, Cwmbrân i Gasnewydd (11.8km, camlas na ellir teithio arni - llwybr 46 y Rhwydwaith Beicio Cenedlaethol)
- Braich Crymlyn (rhan o lwybr 47 y Rhwydwaith Beicio Cenedlaethol)
Mae angen trwydded feicio Dyfrffyrdd Prydain i’r gogledd o Gwmbrân.
Mae Llwybr y Taf yn llwybr 55 milltir ar hyd hen reilffyrdd, lonydd gwledig a llwybrau tynnu camlesi. Mae’n dilyn Camlas Mynwy ac Aberhonddu am ychydig rhwng Aberhonddu a Brynich, yn ogystal â rhan o hen Gamlas Sir Morgannwg, llwybrau sy’n pasio cronfeydd d?r a llwybrau drwy ddyffrynnoedd afonydd. Gan ddechrau yng Nghaerdydd, mae’n mynd ymlaen i Bontypridd, Merthyr Tudful, Cefn Coed ac Aberhonddu.
Cycling routes
Towpath Stoppages
There are no stoppages reported at this time.
PDOException Object
(
[message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.nationwide' in 'where clause'
[string:private] =>
[code:protected] => 42S22
[file:protected] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line:protected] => 53
[trace:private] => Array
(
[0] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 53
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 16
[function] => getUnlimitedQueryRowCount
[class] => Waterscape_Database_RecordSet_Paged
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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 INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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 INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => MB
[_min_easting:private] => 304652
[_max_easting:private] => 331804
[_min_northing:private] => 196927
[_max_northing:private] => 228223
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Monmouthshire & Brecon Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/monmouthshire-and-brecon-canal
[_standfirst:protected] => The Monmouthshire and Brecon Canal winds through 35 miles of peaceful countryside all the way from Brecon south to Cwmbran. Its pretty scenery and lightly-locked route make it understandably popular with holidaymakers.
[_description:protected] => The terminus at Brecon has been completely revitalised in recent years. This is the only major settlement on the canal - otherwise, it generally keeps away from the beaten track.
The canal passes through a World Heritage Site, which also contains industrial landmarks such as the Big Pit Mining Museum. As the Mon & Brec is not currently accessible from any other waterway, most people cruise it on a hire-boat. There are several fleets based on the canal.
[http://www.itvlocal.com/wales/news/?player=WAL_News_15&void=191029 Watch an ITV Wales news report on the Monmouthshire & Brecon Canal]
[/features-and-articles/news/692/new-leaflet-launched-for-mon-and-brec New leaflet launched for Mon & Brec].
++ Camlas Mynwy ac Aberhonddu
**Camlas Mynwy ac Aberhonddu sy’n llifo drwy Barc Cenedlaethol Bannau Brycheiniog yw’r un o’r camlesi harddaf ar y rhwydwaith ddyfrffyrdd.**
Mae camlas Mynwy ac Aberhonddu yn llifo trwy 35 milltir o gefn gwlad heddychlon yr holl ffordd o Aberhonddu i Gwmbrân yn y de. Mae ei golygfeydd godidog a’i lociau prin yn ei gwneud hi’n boblogaidd gydag ymwelwyr.
Yn ddiweddar, mae diwedd y gamlas yn Aberhonddu wedi’i adfywio’n llwyr. Dyma’r unig dref fawr ar hyd y gamlas. Mae gweddill y gamlas yn mynd trwy ardaloedd gwledig yn bennaf.
Mae’n mynd heibio i Safle Treftadaeth y Byd, sydd hefyd yn cynnwys mannau diwydiannol nodedig fel Amgueddfa Lofaol Cymru, Big Pit. Gan nad oes modd mynd ar gamlas Mynwy ac Aberhonddu o unrhyw ddyfrffordd arall ar hyn o bryd, mae’r rhan fwyaf o bobl yn llogi cwch gan un o’r amryw o gwmnïau llogi cychod ar hyd y gamlas.
[_id:protected] => 53
[_url_name] => monmouthshire-and-brecon-canal
)
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => MB
[_min_easting:private] => 304652
[_max_easting:private] => 331804
[_min_northing:private] => 196927
[_max_northing:private] => 228223
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Monmouthshire & Brecon Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/monmouthshire-and-brecon-canal
[_standfirst:protected] => The Monmouthshire and Brecon Canal winds through 35 miles of peaceful countryside all the way from Brecon south to Cwmbran. Its pretty scenery and lightly-locked route make it understandably popular with holidaymakers.
[_description:protected] => The terminus at Brecon has been completely revitalised in recent years. This is the only major settlement on the canal - otherwise, it generally keeps away from the beaten track.
The canal passes through a World Heritage Site, which also contains industrial landmarks such as the Big Pit Mining Museum. As the Mon & Brec is not currently accessible from any other waterway, most people cruise it on a hire-boat. There are several fleets based on the canal.
[http://www.itvlocal.com/wales/news/?player=WAL_News_15&void=191029 Watch an ITV Wales news report on the Monmouthshire & Brecon Canal]
[/features-and-articles/news/692/new-leaflet-launched-for-mon-and-brec New leaflet launched for Mon & Brec].
++ Camlas Mynwy ac Aberhonddu
**Camlas Mynwy ac Aberhonddu sy’n llifo drwy Barc Cenedlaethol Bannau Brycheiniog yw’r un o’r camlesi harddaf ar y rhwydwaith ddyfrffyrdd.**
Mae camlas Mynwy ac Aberhonddu yn llifo trwy 35 milltir o gefn gwlad heddychlon yr holl ffordd o Aberhonddu i Gwmbrân yn y de. Mae ei golygfeydd godidog a’i lociau prin yn ei gwneud hi’n boblogaidd gydag ymwelwyr.
Yn ddiweddar, mae diwedd y gamlas yn Aberhonddu wedi’i adfywio’n llwyr. Dyma’r unig dref fawr ar hyd y gamlas. Mae gweddill y gamlas yn mynd trwy ardaloedd gwledig yn bennaf.
Mae’n mynd heibio i Safle Treftadaeth y Byd, sydd hefyd yn cynnwys mannau diwydiannol nodedig fel Amgueddfa Lofaol Cymru, Big Pit. Gan nad oes modd mynd ar gamlas Mynwy ac Aberhonddu o unrhyw ddyfrffordd arall ar hyn o bryd, mae’r rhan fwyaf o bobl yn llogi cwch gan un o’r amryw o gwmnïau llogi cychod ar hyd y gamlas.
[_id:protected] => 53
[_url_name] => monmouthshire-and-brecon-canal
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] => 1
[_page_limit:private] => 9
)
)
)
[6] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Renderer/Component/HtmlRenderer.php
[line] => 18
[function] => fetch
[class] => Waterscape_Component_DirectoryListingPage
[type] => ->
[args] => Array
(
)
)
[7] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Smarty.php
[line] => 262
[function] => render
[class] => Waterscape_Renderer_Component_HtmlRenderer
[type] => ->
[args] => Array
(
[0] => Waterscape_Component_DirectoryListingPage Object
(
[_is_location_page:private] => 1
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => MB
[_min_easting:private] => 304652
[_max_easting:private] => 331804
[_min_northing:private] => 196927
[_max_northing:private] => 228223
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Monmouthshire & Brecon Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/monmouthshire-and-brecon-canal
[_standfirst:protected] => The Monmouthshire and Brecon Canal winds through 35 miles of peaceful countryside all the way from Brecon south to Cwmbran. Its pretty scenery and lightly-locked route make it understandably popular with holidaymakers.
[_description:protected] => The terminus at Brecon has been completely revitalised in recent years. This is the only major settlement on the canal - otherwise, it generally keeps away from the beaten track.
The canal passes through a World Heritage Site, which also contains industrial landmarks such as the Big Pit Mining Museum. As the Mon & Brec is not currently accessible from any other waterway, most people cruise it on a hire-boat. There are several fleets based on the canal.
[http://www.itvlocal.com/wales/news/?player=WAL_News_15&void=191029 Watch an ITV Wales news report on the Monmouthshire & Brecon Canal]
[/features-and-articles/news/692/new-leaflet-launched-for-mon-and-brec New leaflet launched for Mon & Brec].
++ Camlas Mynwy ac Aberhonddu
**Camlas Mynwy ac Aberhonddu sy’n llifo drwy Barc Cenedlaethol Bannau Brycheiniog yw’r un o’r camlesi harddaf ar y rhwydwaith ddyfrffyrdd.**
Mae camlas Mynwy ac Aberhonddu yn llifo trwy 35 milltir o gefn gwlad heddychlon yr holl ffordd o Aberhonddu i Gwmbrân yn y de. Mae ei golygfeydd godidog a’i lociau prin yn ei gwneud hi’n boblogaidd gydag ymwelwyr.
Yn ddiweddar, mae diwedd y gamlas yn Aberhonddu wedi’i adfywio’n llwyr. Dyma’r unig dref fawr ar hyd y gamlas. Mae gweddill y gamlas yn mynd trwy ardaloedd gwledig yn bennaf.
Mae’n mynd heibio i Safle Treftadaeth y Byd, sydd hefyd yn cynnwys mannau diwydiannol nodedig fel Amgueddfa Lofaol Cymru, Big Pit. Gan nad oes modd mynd ar gamlas Mynwy ac Aberhonddu o unrhyw ddyfrffordd arall ar hyn o bryd, mae’r rhan fwyaf o bobl yn llogi cwch gan un o’r amryw o gwmnïau llogi cychod ar hyd y gamlas.
[_id:protected] => 53
[_url_name] => monmouthshire-and-brecon-canal
)
[_preposition:private] => along the
[_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 * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
[_business_manager:private] =>
[_location_manager:private] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_town_manager:private] =>
[_limit:protected] =>
[_title:protected] => 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] => 712657
[_view_component_id:protected] => 178
[_instance_name:protected] => directory_page
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /canals-and-rivers/monmouthshire-and-brecon-canal/cycling
[_path:private] => /canals-and-rivers/monmouthshire-and-brecon-canal/cycling
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => canals-and-rivers/monmouthshire-and-brecon-canal/cycling
[PHPSESSID] => bbc33cd2125a65901746d4395b2cb6e7
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 24
[page_id] => 712657
[view_name] => waterway_cycling
[title] => Cycling And Cycle Routes %LOCATION_PREPOSITION% %LOCATION_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_Waterways
[path] => /canals-and-rivers/monmouthshire-and-brecon-canal/cycling
[waterway] => Array
(
[id] => 53
[0] => 53
[name] => Monmouthshire & Brecon Canal
[1] => Monmouthshire & Brecon Canal
[urlname] => monmouthshire-and-brecon-canal
[2] => monmouthshire-and-brecon-canal
[waterway_type] => 15
[3] => 15
[sap_canal_code] => MB
[4] => MB
[introduction] => The terminus at Brecon has been completely revitalised in recent years. This is the only major settlement on the canal - otherwise, it generally keeps away from the beaten track.
The canal passes through a World Heritage Site, which also contains industrial landmarks such as the Big Pit Mining Museum. As the Mon & Brec is not currently accessible from any other waterway, most people cruise it on a hire-boat. There are several fleets based on the canal.
[http://www.itvlocal.com/wales/news/?player=WAL_News_15&void=191029 Watch an ITV Wales news report on the Monmouthshire & Brecon Canal]
[/features-and-articles/news/692/new-leaflet-launched-for-mon-and-brec New leaflet launched for Mon & Brec].
++ Camlas Mynwy ac Aberhonddu
**Camlas Mynwy ac Aberhonddu sy’n llifo drwy Barc Cenedlaethol Bannau Brycheiniog yw’r un o’r camlesi harddaf ar y rhwydwaith ddyfrffyrdd.**
Mae camlas Mynwy ac Aberhonddu yn llifo trwy 35 milltir o gefn gwlad heddychlon yr holl ffordd o Aberhonddu i Gwmbrân yn y de. Mae ei golygfeydd godidog a’i lociau prin yn ei gwneud hi’n boblogaidd gydag ymwelwyr.
Yn ddiweddar, mae diwedd y gamlas yn Aberhonddu wedi’i adfywio’n llwyr. Dyma’r unig dref fawr ar hyd y gamlas. Mae gweddill y gamlas yn mynd trwy ardaloedd gwledig yn bennaf.
Mae’n mynd heibio i Safle Treftadaeth y Byd, sydd hefyd yn cynnwys mannau diwydiannol nodedig fel Amgueddfa Lofaol Cymru, Big Pit. Gan nad oes modd mynd ar gamlas Mynwy ac Aberhonddu o unrhyw ddyfrffordd arall ar hyn o bryd, mae’r rhan fwyaf o bobl yn llogi cwch gan un o’r amryw o gwmnïau llogi cychod ar hyd y gamlas.
[5] => The terminus at Brecon has been completely revitalised in recent years. This is the only major settlement on the canal - otherwise, it generally keeps away from the beaten track.
The canal passes through a World Heritage Site, which also contains industrial landmarks such as the Big Pit Mining Museum. As the Mon & Brec is not currently accessible from any other waterway, most people cruise it on a hire-boat. There are several fleets based on the canal.
[http://www.itvlocal.com/wales/news/?player=WAL_News_15&void=191029 Watch an ITV Wales news report on the Monmouthshire & Brecon Canal]
[/features-and-articles/news/692/new-leaflet-launched-for-mon-and-brec New leaflet launched for Mon & Brec].
++ Camlas Mynwy ac Aberhonddu
**Camlas Mynwy ac Aberhonddu sy’n llifo drwy Barc Cenedlaethol Bannau Brycheiniog yw’r un o’r camlesi harddaf ar y rhwydwaith ddyfrffyrdd.**
Mae camlas Mynwy ac Aberhonddu yn llifo trwy 35 milltir o gefn gwlad heddychlon yr holl ffordd o Aberhonddu i Gwmbrân yn y de. Mae ei golygfeydd godidog a’i lociau prin yn ei gwneud hi’n boblogaidd gydag ymwelwyr.
Yn ddiweddar, mae diwedd y gamlas yn Aberhonddu wedi’i adfywio’n llwyr. Dyma’r unig dref fawr ar hyd y gamlas. Mae gweddill y gamlas yn mynd trwy ardaloedd gwledig yn bennaf.
Mae’n mynd heibio i Safle Treftadaeth y Byd, sydd hefyd yn cynnwys mannau diwydiannol nodedig fel Amgueddfa Lofaol Cymru, Big Pit. Gan nad oes modd mynd ar gamlas Mynwy ac Aberhonddu o unrhyw ddyfrffordd arall ar hyn o bryd, mae’r rhan fwyaf o bobl yn llogi cwch gan un o’r amryw o gwmnïau llogi cychod ar hyd y gamlas.
[overview] => The Monmouthshire and Brecon Canal winds through 35 miles of peaceful countryside all the way from Brecon south to Cwmbran. Its pretty scenery and lightly-locked route make it understandably popular with holidaymakers.
[6] => The Monmouthshire and Brecon Canal winds through 35 miles of peaceful countryside all the way from Brecon south to Cwmbran. Its pretty scenery and lightly-locked route make it understandably popular with holidaymakers.
[published] => 1
[7] => 1
[metadata_id] =>
[8] =>
[geo_data_id] =>
[9] =>
[importance] => 10
[10] => 10
[min_easting] => 304652
[11] => 304652
[min_northing] => 196927
[12] => 196927
[max_easting] => 331804
[13] => 331804
[max_northing] => 228223
[14] => 228223
[centre_easting] =>
[15] =>
[centre_northing] =>
[16] =>
)
[location] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => MB
[_min_easting:private] => 304652
[_max_easting:private] => 331804
[_min_northing:private] => 196927
[_max_northing:private] => 228223
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Monmouthshire & Brecon Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/monmouthshire-and-brecon-canal
[_standfirst:protected] => The Monmouthshire and Brecon Canal winds through 35 miles of peaceful countryside all the way from Brecon south to Cwmbran. Its pretty scenery and lightly-locked route make it understandably popular with holidaymakers.
[_description:protected] => The terminus at Brecon has been completely revitalised in recent years. This is the only major settlement on the canal - otherwise, it generally keeps away from the beaten track.
The canal passes through a World Heritage Site, which also contains industrial landmarks such as the Big Pit Mining Museum. As the Mon & Brec is not currently accessible from any other waterway, most people cruise it on a hire-boat. There are several fleets based on the canal.
[http://www.itvlocal.com/wales/news/?player=WAL_News_15&void=191029 Watch an ITV Wales news report on the Monmouthshire & Brecon Canal]
[/features-and-articles/news/692/new-leaflet-launched-for-mon-and-brec New leaflet launched for Mon & Brec].
++ Camlas Mynwy ac Aberhonddu
**Camlas Mynwy ac Aberhonddu sy’n llifo drwy Barc Cenedlaethol Bannau Brycheiniog yw’r un o’r camlesi harddaf ar y rhwydwaith ddyfrffyrdd.**
Mae camlas Mynwy ac Aberhonddu yn llifo trwy 35 milltir o gefn gwlad heddychlon yr holl ffordd o Aberhonddu i Gwmbrân yn y de. Mae ei golygfeydd godidog a’i lociau prin yn ei gwneud hi’n boblogaidd gydag ymwelwyr.
Yn ddiweddar, mae diwedd y gamlas yn Aberhonddu wedi’i adfywio’n llwyr. Dyma’r unig dref fawr ar hyd y gamlas. Mae gweddill y gamlas yn mynd trwy ardaloedd gwledig yn bennaf.
Mae’n mynd heibio i Safle Treftadaeth y Byd, sydd hefyd yn cynnwys mannau diwydiannol nodedig fel Amgueddfa Lofaol Cymru, Big Pit. Gan nad oes modd mynd ar gamlas Mynwy ac Aberhonddu o unrhyw ddyfrffordd arall ar hyn o bryd, mae’r rhan fwyaf o bobl yn llogi cwch gan un o’r amryw o gwmnïau llogi cychod ar hyd y gamlas.
[_id:protected] => 53
[_url_name] => monmouthshire-and-brecon-canal
)
[preposition] => along the
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => MB
[_min_easting:private] => 304652
[_max_easting:private] => 331804
[_min_northing:private] => 196927
[_max_northing:private] => 228223
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Monmouthshire & Brecon Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/monmouthshire-and-brecon-canal
[_standfirst:protected] => The Monmouthshire and Brecon Canal winds through 35 miles of peaceful countryside all the way from Brecon south to Cwmbran. Its pretty scenery and lightly-locked route make it understandably popular with holidaymakers.
[_description:protected] => The terminus at Brecon has been completely revitalised in recent years. This is the only major settlement on the canal - otherwise, it generally keeps away from the beaten track.
The canal passes through a World Heritage Site, which also contains industrial landmarks such as the Big Pit Mining Museum. As the Mon & Brec is not currently accessible from any other waterway, most people cruise it on a hire-boat. There are several fleets based on the canal.
[http://www.itvlocal.com/wales/news/?player=WAL_News_15&void=191029 Watch an ITV Wales news report on the Monmouthshire & Brecon Canal]
[/features-and-articles/news/692/new-leaflet-launched-for-mon-and-brec New leaflet launched for Mon & Brec].
++ Camlas Mynwy ac Aberhonddu
**Camlas Mynwy ac Aberhonddu sy’n llifo drwy Barc Cenedlaethol Bannau Brycheiniog yw’r un o’r camlesi harddaf ar y rhwydwaith ddyfrffyrdd.**
Mae camlas Mynwy ac Aberhonddu yn llifo trwy 35 milltir o gefn gwlad heddychlon yr holl ffordd o Aberhonddu i Gwmbrân yn y de. Mae ei golygfeydd godidog a’i lociau prin yn ei gwneud hi’n boblogaidd gydag ymwelwyr.
Yn ddiweddar, mae diwedd y gamlas yn Aberhonddu wedi’i adfywio’n llwyr. Dyma’r unig dref fawr ar hyd y gamlas. Mae gweddill y gamlas yn mynd trwy ardaloedd gwledig yn bennaf.
Mae’n mynd heibio i Safle Treftadaeth y Byd, sydd hefyd yn cynnwys mannau diwydiannol nodedig fel Amgueddfa Lofaol Cymru, Big Pit. Gan nad oes modd mynd ar gamlas Mynwy ac Aberhonddu o unrhyw ddyfrffordd arall ar hyn o bryd, mae’r rhan fwyaf o bobl yn llogi cwch gan un o’r amryw o gwmnïau llogi cychod ar hyd y gamlas.
[_id:protected] => 53
[_url_name] => monmouthshire-and-brecon-canal
)
[_na_office_manager:private] => Waterscape_Service_NavigationAuthorityOfficeManager Object
(
[_navigation_authority_office_dao:private] => Waterscape_Dao_NavigationAuthorityOffice Object
(
[_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_navigation_authority_dao:private] => Waterscape_Dao_NavigationAuthority Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
[_stoppage_manager:private] => Waterscape_Service_StoppageManager Object
(
[_stoppage_dao:private] => Waterscape_Dao_Stoppage Object
(
[_waterway_mgr:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion Object
(
[_db:protected] =>
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType Object
(
[_db:protected] =>
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription Object
(
[_db:protected] =>
)
)
[_criteria:private] => Array
(
)
[_raw_criteria:private] =>
[_sql_strings:private] => Array
(
)
[_sql_values:private] => Array
(
)
[_search_data_by:private] => Array
(
[all] => 0
[stoppage] => s
[restriction] => r
[opening_times] => o
[booking_details] => b
[advice] => a
[towpath_closure_only] => t
)
[_str_types_selected:private] =>
[_stoppage_type:private] =>
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
)
[_route_manager:private] => Waterscape_Service_RouteManager Object
(
[_route_dao:private] => Waterscape_Dao_Route Object
(
[_route_type_manager:private] => Waterscape_Service_RouteTypeManager Object
(
[_route_type_dao:private] => Waterscape_Dao_RouteType Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
)
[_waypoint_manager:private] => Waterscape_Service_WaypointManager Object
(
[_waypoint_dao:private] => Waterscape_Dao_Waypoint Object
(
[_metadata_mgr:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_geo_point_mgr:private] =>
[_geo_data_type_manager:private] => Waterscape_Service_GeoDataTypeManager Object
(
[_geo_data_dao:private] => Waterscape_Dao_GeoDataType Object
(
[_db:protected] =>
)
)
[_db:protected] =>
[_geo_point_manager] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] =>
)
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
)
[_media_manager:private] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
[_db:protected] =>
)
)
)
[_rating_manager:private] => Waterscape_Service_RouteRatingManager Object
(
[_route_rating_dao:private] => Waterscape_Dao_RouteRating Object
(
[_db:protected] =>
)
)
[_metadata_manager:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
)
)
[_view_manager:private] => Waterscape_Service_ViewManager Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
)
[_business_manager:private] => Waterscape_Service_BusinessManager Object
(
[_business_dao:private] => Waterscape_Dao_Business Object
(
[_address_manager:protected] => Waterscape_Service_StreetAddressManager Object
(
[_street_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
)
[_metadata_manager:protected] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_attribute_manager:protected] => Waterscape_Service_AttributeManager Object
(
[_attribute_dao:private] => Waterscape_Dao_Attribute Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_category_manager:protected] => Waterscape_Service_CategoryManager Object
(
[_category_dao:private] => Waterscape_Dao_Category Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_section_manager:protected] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_location_manager:protected] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_media_manager:protected] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[50] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[66] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[67] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[68] => Array
(
[sql] => SELECT id FROM stoppage WHERE waterway_id = ? AND ( (end_date IS NULL) OR (start_date >= CURDATE()) OR (end_date >= CURDATE()) ) AND is_published = 1 AND (is_towpath_closed = 1 OR type = "t") ORDER BY start_date ASC
)
[69] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[70] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[71] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[72] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[73] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[74] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[75] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[76] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[77] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id INNER JOIN service_provider_waterway w ON w.item_id = i.id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 7) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 7)) AND w.waterway_id = 53 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] => 78
)
)
[_db:protected] =>
)
)
)
[_db:protected] =>
)
)
[_menu_id:protected] =>
[_menu_items:protected] =>
[_display_class:protected] =>
[_html_class:protected] =>
[_html_id:protected] =>
[_menu_components:protected] =>
[_page_manager:protected] => Waterscape_Service_PageManager Object
(
[_page_dao:private] => Waterscape_Dao_Page Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM waterway WHERE urlname = ? LIMIT 1
)
[4] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[5] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[7] => Array
(
[sql] => SELECT DISTINCT r.route_id, r.name, r.description, r.picture, rt.name AS route_type FROM route r INNER JOIN route_type rt ON rt.type_id = r.route_type INNER JOIN route_waterway rw ON rw.route_id = r.route_id WHERE 1=1 AND rw.waterway_id = ? AND is_published = 1 AND rt.type_id = 2
)
[8] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)