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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) 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] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 4
[_name:protected] => Boating
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_id:protected] => 13
[_name:protected] => Services for your boat
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => GU
[_min_easting:private] => 407967
[_max_easting:private] => 527012
[_min_northing:private] => 177115
[_max_northing:private] => 290082
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Grand Union Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/grand-union-canal
[_standfirst:protected] => The trunk route of Britain's canal network, the picturesque Grand Union links London through the Chilterns with [/in-your-area/warwickshire/birmingham Birmingham] via the longest single canal in Britain.
[_description:protected] => The Grand Union is a 1920s marriage of historic waterways that even now impresses with the scale of its vision. The attractive 137-mile main line has many branches to towns along the way. The longest of these, the [/canals-and-rivers/grand-union-canal-leicester-line Leicester Line], runs to [/in-your-area/leicestershire/leicester Leicester], from where the [/canals-and-rivers/river-soar River Soar] continues to [/in-your-area/nottinghamshire/nottingham Nottingham].
As the main line from [/in-your-area/london London] to the Midlands, the Grand Union Canal was once one of the busiest in the country. Today, its charm lies in its diversity: from the centre of London through the Chiltern Hills, rural [/in-your-area/northamptonshire Northamptonshire] and [/in-your-area/warwickshire Warwickshire], and into the suburbs of Birmingham, it offers a wide variety of landscapes, [/features-and-articles/features/wildlife wildlife], architecture, historic craft and buildings.
[/media/documents/22210.pdf Download a Guide and map to West London's Canals]
[/media/documents/22208.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[/media/documents/22219.pdf Download a Guide and map to Nottingham and the East Midlands’ Canals & Rivers]
[/media/documents/22218.pdf Download a Guide and map to Milton Keynes’ Canals]
[/media/documents/22075.pdf Download a guide to using water conservation locks on the Grand Union Canal]
[_id:protected] => 35
[_url_name] => grand-union-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] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 4
[_name:protected] => Boating
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_id:protected] => 13
[_name:protected] => Services for your boat
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => GU
[_min_easting:private] => 407967
[_max_easting:private] => 527012
[_min_northing:private] => 177115
[_max_northing:private] => 290082
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Grand Union Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/grand-union-canal
[_standfirst:protected] => The trunk route of Britain's canal network, the picturesque Grand Union links London through the Chilterns with [/in-your-area/warwickshire/birmingham Birmingham] via the longest single canal in Britain.
[_description:protected] => The Grand Union is a 1920s marriage of historic waterways that even now impresses with the scale of its vision. The attractive 137-mile main line has many branches to towns along the way. The longest of these, the [/canals-and-rivers/grand-union-canal-leicester-line Leicester Line], runs to [/in-your-area/leicestershire/leicester Leicester], from where the [/canals-and-rivers/river-soar River Soar] continues to [/in-your-area/nottinghamshire/nottingham Nottingham].
As the main line from [/in-your-area/london London] to the Midlands, the Grand Union Canal was once one of the busiest in the country. Today, its charm lies in its diversity: from the centre of London through the Chiltern Hills, rural [/in-your-area/northamptonshire Northamptonshire] and [/in-your-area/warwickshire Warwickshire], and into the suburbs of Birmingham, it offers a wide variety of landscapes, [/features-and-articles/features/wildlife wildlife], architecture, historic craft and buildings.
[/media/documents/22210.pdf Download a Guide and map to West London's Canals]
[/media/documents/22208.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[/media/documents/22219.pdf Download a Guide and map to Nottingham and the East Midlands’ Canals & Rivers]
[/media/documents/22218.pdf Download a Guide and map to Milton Keynes’ Canals]
[/media/documents/22075.pdf Download a guide to using water conservation locks on the Grand Union Canal]
[_id:protected] => 35
[_url_name] => grand-union-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] => GU
[_min_easting:private] => 407967
[_max_easting:private] => 527012
[_min_northing:private] => 177115
[_max_northing:private] => 290082
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Grand Union Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/grand-union-canal
[_standfirst:protected] => The trunk route of Britain's canal network, the picturesque Grand Union links London through the Chilterns with [/in-your-area/warwickshire/birmingham Birmingham] via the longest single canal in Britain.
[_description:protected] => The Grand Union is a 1920s marriage of historic waterways that even now impresses with the scale of its vision. The attractive 137-mile main line has many branches to towns along the way. The longest of these, the [/canals-and-rivers/grand-union-canal-leicester-line Leicester Line], runs to [/in-your-area/leicestershire/leicester Leicester], from where the [/canals-and-rivers/river-soar River Soar] continues to [/in-your-area/nottinghamshire/nottingham Nottingham].
As the main line from [/in-your-area/london London] to the Midlands, the Grand Union Canal was once one of the busiest in the country. Today, its charm lies in its diversity: from the centre of London through the Chiltern Hills, rural [/in-your-area/northamptonshire Northamptonshire] and [/in-your-area/warwickshire Warwickshire], and into the suburbs of Birmingham, it offers a wide variety of landscapes, [/features-and-articles/features/wildlife wildlife], architecture, historic craft and buildings.
[/media/documents/22210.pdf Download a Guide and map to West London's Canals]
[/media/documents/22208.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[/media/documents/22219.pdf Download a Guide and map to Nottingham and the East Midlands’ Canals & Rivers]
[/media/documents/22218.pdf Download a Guide and map to Milton Keynes’ Canals]
[/media/documents/22075.pdf Download a guide to using water conservation locks on the Grand Union Canal]
[_id:protected] => 35
[_url_name] => grand-union-canal
)
[_preposition:private] => along the
[_descriptor:private] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 4
[_name:protected] => Boating
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_id:protected] => 13
[_name:protected] => Services for your boat
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
)
[_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] =>
[_items:protected] =>
[_is_paginated:protected] => 1
[_component_id:protected] => 14
[_parent_id:protected] =>
[_template:protected] => Component/ListingPage.tpl
[_page_id:protected] => 711877
[_view_component_id:protected] => 33260
[_instance_name:protected] => directory_page
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /canals-and-rivers/grand-union-canal/boating/services-for-your-boat
[_path:private] => /canals-and-rivers/grand-union-canal/boating/services-for-your-boat
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => canals-and-rivers/grand-union-canal/boating/services-for-your-boat
[PHPSESSID] => ec3cfbfe8f4c062cad0f04c42ff6d8d0
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 78
[page_id] => 711877
[view_name] => waterways_boating_servicesforyourboat
[title] => Waterway & Boating Services for Your Boat %LOCATION_PREPOSITION% %LOCATION_NAME% | Canals & Rivers | Waterscape.com
[keywords] =>
[description] =>
[layout_template] => Page/locations/location.tpl
[template] => Page/locations/servicelistings.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Waterways
[path] => /canals-and-rivers/grand-union-canal/boating/services-for-your-boat
[waterway] => Array
(
[id] => 35
[0] => 35
[name] => Grand Union Canal
[1] => Grand Union Canal
[urlname] => grand-union-canal
[2] => grand-union-canal
[waterway_type] => 15
[3] => 15
[sap_canal_code] => GU
[4] => GU
[introduction] => The Grand Union is a 1920s marriage of historic waterways that even now impresses with the scale of its vision. The attractive 137-mile main line has many branches to towns along the way. The longest of these, the [/canals-and-rivers/grand-union-canal-leicester-line Leicester Line], runs to [/in-your-area/leicestershire/leicester Leicester], from where the [/canals-and-rivers/river-soar River Soar] continues to [/in-your-area/nottinghamshire/nottingham Nottingham].
As the main line from [/in-your-area/london London] to the Midlands, the Grand Union Canal was once one of the busiest in the country. Today, its charm lies in its diversity: from the centre of London through the Chiltern Hills, rural [/in-your-area/northamptonshire Northamptonshire] and [/in-your-area/warwickshire Warwickshire], and into the suburbs of Birmingham, it offers a wide variety of landscapes, [/features-and-articles/features/wildlife wildlife], architecture, historic craft and buildings.
[/media/documents/22210.pdf Download a Guide and map to West London's Canals]
[/media/documents/22208.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[/media/documents/22219.pdf Download a Guide and map to Nottingham and the East Midlands’ Canals & Rivers]
[/media/documents/22218.pdf Download a Guide and map to Milton Keynes’ Canals]
[/media/documents/22075.pdf Download a guide to using water conservation locks on the Grand Union Canal]
[5] => The Grand Union is a 1920s marriage of historic waterways that even now impresses with the scale of its vision. The attractive 137-mile main line has many branches to towns along the way. The longest of these, the [/canals-and-rivers/grand-union-canal-leicester-line Leicester Line], runs to [/in-your-area/leicestershire/leicester Leicester], from where the [/canals-and-rivers/river-soar River Soar] continues to [/in-your-area/nottinghamshire/nottingham Nottingham].
As the main line from [/in-your-area/london London] to the Midlands, the Grand Union Canal was once one of the busiest in the country. Today, its charm lies in its diversity: from the centre of London through the Chiltern Hills, rural [/in-your-area/northamptonshire Northamptonshire] and [/in-your-area/warwickshire Warwickshire], and into the suburbs of Birmingham, it offers a wide variety of landscapes, [/features-and-articles/features/wildlife wildlife], architecture, historic craft and buildings.
[/media/documents/22210.pdf Download a Guide and map to West London's Canals]
[/media/documents/22208.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[/media/documents/22219.pdf Download a Guide and map to Nottingham and the East Midlands’ Canals & Rivers]
[/media/documents/22218.pdf Download a Guide and map to Milton Keynes’ Canals]
[/media/documents/22075.pdf Download a guide to using water conservation locks on the Grand Union Canal]
[overview] => The trunk route of Britain's canal network, the picturesque Grand Union links London through the Chilterns with [/in-your-area/warwickshire/birmingham Birmingham] via the longest single canal in Britain.
[6] => The trunk route of Britain's canal network, the picturesque Grand Union links London through the Chilterns with [/in-your-area/warwickshire/birmingham Birmingham] via the longest single canal in Britain.
[published] => 1
[7] => 1
[metadata_id] =>
[8] =>
[geo_data_id] =>
[9] =>
[importance] => 10
[10] => 10
[min_easting] => 407967
[11] => 407967
[min_northing] => 177115
[12] => 177115
[max_easting] => 527012
[13] => 527012
[max_northing] => 290082
[14] => 290082
[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] => GU
[_min_easting:private] => 407967
[_max_easting:private] => 527012
[_min_northing:private] => 177115
[_max_northing:private] => 290082
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Grand Union Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/grand-union-canal
[_standfirst:protected] => The trunk route of Britain's canal network, the picturesque Grand Union links London through the Chilterns with [/in-your-area/warwickshire/birmingham Birmingham] via the longest single canal in Britain.
[_description:protected] => The Grand Union is a 1920s marriage of historic waterways that even now impresses with the scale of its vision. The attractive 137-mile main line has many branches to towns along the way. The longest of these, the [/canals-and-rivers/grand-union-canal-leicester-line Leicester Line], runs to [/in-your-area/leicestershire/leicester Leicester], from where the [/canals-and-rivers/river-soar River Soar] continues to [/in-your-area/nottinghamshire/nottingham Nottingham].
As the main line from [/in-your-area/london London] to the Midlands, the Grand Union Canal was once one of the busiest in the country. Today, its charm lies in its diversity: from the centre of London through the Chiltern Hills, rural [/in-your-area/northamptonshire Northamptonshire] and [/in-your-area/warwickshire Warwickshire], and into the suburbs of Birmingham, it offers a wide variety of landscapes, [/features-and-articles/features/wildlife wildlife], architecture, historic craft and buildings.
[/media/documents/22210.pdf Download a Guide and map to West London's Canals]
[/media/documents/22208.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[/media/documents/22219.pdf Download a Guide and map to Nottingham and the East Midlands’ Canals & Rivers]
[/media/documents/22218.pdf Download a Guide and map to Milton Keynes’ Canals]
[/media/documents/22075.pdf Download a guide to using water conservation locks on the Grand Union Canal]
[_id:protected] => 35
[_url_name] => grand-union-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] => GU
[_min_easting:private] => 407967
[_max_easting:private] => 527012
[_min_northing:private] => 177115
[_max_northing:private] => 290082
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Grand Union Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/grand-union-canal
[_standfirst:protected] => The trunk route of Britain's canal network, the picturesque Grand Union links London through the Chilterns with [/in-your-area/warwickshire/birmingham Birmingham] via the longest single canal in Britain.
[_description:protected] => The Grand Union is a 1920s marriage of historic waterways that even now impresses with the scale of its vision. The attractive 137-mile main line has many branches to towns along the way. The longest of these, the [/canals-and-rivers/grand-union-canal-leicester-line Leicester Line], runs to [/in-your-area/leicestershire/leicester Leicester], from where the [/canals-and-rivers/river-soar River Soar] continues to [/in-your-area/nottinghamshire/nottingham Nottingham].
As the main line from [/in-your-area/london London] to the Midlands, the Grand Union Canal was once one of the busiest in the country. Today, its charm lies in its diversity: from the centre of London through the Chiltern Hills, rural [/in-your-area/northamptonshire Northamptonshire] and [/in-your-area/warwickshire Warwickshire], and into the suburbs of Birmingham, it offers a wide variety of landscapes, [/features-and-articles/features/wildlife wildlife], architecture, historic craft and buildings.
[/media/documents/22210.pdf Download a Guide and map to West London's Canals]
[/media/documents/22208.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[/media/documents/22219.pdf Download a Guide and map to Nottingham and the East Midlands’ Canals & Rivers]
[/media/documents/22218.pdf Download a Guide and map to Milton Keynes’ Canals]
[/media/documents/22075.pdf Download a guide to using water conservation locks on the Grand Union Canal]
[_id:protected] => 35
[_url_name] => grand-union-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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
)
[_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] =>
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_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] =>
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND w.waterway_id = 35 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 = 13) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 13)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 72
)
)
[_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 * FROM content_view WHERE view_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[31] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[43] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[45] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[51] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[58] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT id FROM waterway WHERE urlname = ? and published = 1
)
[63] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[64] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[65] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[66] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[67] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[68] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[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 = ?
quick search
