Fishing along the Lancaster Canal
Fishing is a popular pastime for users of the Lancaster Canal and it's not difficult to see why. The scenery surrounding our 55 mile stretch provides a perfect backdrop for those in search of a little time out, and yet underneath the waters a variety of fish, both large and small await your line.
The Lancaster Canal is an important match fishery, but there is plenty of room for pleasure anglers too. Most fishing takes place between Preston and Carnforth with roach, bream, tench, perch and gudgeon being the main species. Chub, normally a river fish, have become well established at Forton and these provide good sport. There is a good number of tench and carp in places, particularly in the Northern Reaches. Pike are also widespread and reach 20lb in their preferred areas. Anglers are welcomed all year round, but do remember the canals are used by many different groups of people, so the Waterways Code must be adhered to.
If you find walking difficult, or require a wheelchair, you will find many accessible urban locations with nearby parking. Some pegs have been specially constructed for disabled anglers.
A permit is required to fish on the canal, in addition to the standard Environment Agency rod licence. There are two types of permits you can purchase for the Lancaster Canal, depending on how much fishing you plan to do.
Waterway Wanderers Permit
For the fishing enthusiast, this permit will allow you to fish on many of the North West Region canals. These areas include the 43 mile stretch of Shropshire Union Canal, 40 miles of the Llangollen Canal, 45 miles of the Leeds and Liverpool Canal, and 55 miles of the Lancaster Canal.
For 12 months, this costs £15.00 for adults, or £7.50 for juniors, OAP & Disabled. Monthly & day permits are also available but should be obtained in advance. One day is £2.00 adults, £1.50 concessions. One month is £10.00 adults, £5.00 concessions.
Waterway Anglers Together
Another option available to those who would prefer to be involved in a club, or beginners and casual anglers on a day ticket is the Anglers Together Scheme.
Each participating angling club pays an Annual Registration fee of £365. Participating clubs then obtain permits valid for a whole year for each and every member of the club for 99p per member.
Clubs and contact numbers along the Lancaster Canal are:
- Kendal & District Angling Club Phone: (01539) 442051
- Lancaster Anglers Centre Phone: (01524) 733820
- Preston Federated Anglers Phone: (01772) 613606
- Northern Anglers Association Phone: (01257) 249 372
- Alkali Angling Club Phone: (01253) 865584
- Lansil Sports & Social Club Phone: (01524) 425000
British Waterways is also opening an new fishing lake at Borwick. For details, call 01606 723852.
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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
[1] => Array
(
)
[2] =>
[3] =>
)
)
[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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
[1] =>
[2] =>
)
)
[4] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/FisheryListingPage.php
[line] => 39
[function] => find
[class] => Waterscape_Directory_Finder_Abstract
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 5
[_name:protected] => Fishing
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => LC
[_min_easting:private] => 344501
[_max_easting:private] => 353982
[_min_northing:private] => 430224
[_max_northing:private] => 485425
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Lancaster Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/lancaster-canal
[_standfirst:protected] => One of the most scenic canals now on the network, this gentle waterway offers wonderful views of the Silverdale coast, Forest of Bowland and rolling countryside of Wyre.
[_description:protected] => The Lancaster Canal is unique. Being a contour canal (built along the natural lie of the land), it has 41 miles without locks. This is the longest stretch in the country, and in fact the only locks on the main length are derelict! These are at Tewitfield, the southernmost point of the Northern Reaches, and as such are part of the £50 million restoration scheme to reopen the 14 miles of canal to Kendal.
Though the canal was once busy with cargoes from Kendal, Preston and [/in-your-area/lancashire/lancaster Lancaster], it has only just been connected to the national waterway network by the [/canals-and-rivers/ribble-link Millennium Ribble Link].
A waterbus now runs on the canal in the summer months, resurrecting a 200-year old tradition. Enjoy one of a variety of cruises on offer, including Lancaster to Carnforth, Carnforth to Tewitfield, Lancaster country cruises and [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct] Cruises with [/services-directory/4235/lancaster-canal-packet-boats Lancaster Canal Packet Boats].
[/media/documents/22413.pdf Download a guide to Lancaster Canal]
[_id:protected] => 42
[_url_name] => lancaster-canal
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] =>
[_page_limit:private] =>
)
)
)
[5] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/FisheryListingPage.php
[line] => 18
[function] => getFishingServices
[class] => Waterscape_Component_FisheryListingPage
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 5
[_name:protected] => Fishing
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => LC
[_min_easting:private] => 344501
[_max_easting:private] => 353982
[_min_northing:private] => 430224
[_max_northing:private] => 485425
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Lancaster Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/lancaster-canal
[_standfirst:protected] => One of the most scenic canals now on the network, this gentle waterway offers wonderful views of the Silverdale coast, Forest of Bowland and rolling countryside of Wyre.
[_description:protected] => The Lancaster Canal is unique. Being a contour canal (built along the natural lie of the land), it has 41 miles without locks. This is the longest stretch in the country, and in fact the only locks on the main length are derelict! These are at Tewitfield, the southernmost point of the Northern Reaches, and as such are part of the £50 million restoration scheme to reopen the 14 miles of canal to Kendal.
Though the canal was once busy with cargoes from Kendal, Preston and [/in-your-area/lancashire/lancaster Lancaster], it has only just been connected to the national waterway network by the [/canals-and-rivers/ribble-link Millennium Ribble Link].
A waterbus now runs on the canal in the summer months, resurrecting a 200-year old tradition. Enjoy one of a variety of cruises on offer, including Lancaster to Carnforth, Carnforth to Tewitfield, Lancaster country cruises and [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct] Cruises with [/services-directory/4235/lancaster-canal-packet-boats Lancaster Canal Packet Boats].
[/media/documents/22413.pdf Download a guide to Lancaster Canal]
[_id:protected] => 42
[_url_name] => lancaster-canal
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] =>
[_page_limit:private] =>
)
)
)
[6] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 48
[function] => initItems
[class] => Waterscape_Component_FisheryListingPage
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 5
[_name:protected] => Fishing
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_location:private] => Waterscape_Model_Waterway Object
(
[_location_type:protected] => 3
[_waterway_type:private] => 15
[_geo_data_id:private] =>
[_sap_canal_code:private] => LC
[_min_easting:private] => 344501
[_max_easting:private] => 353982
[_min_northing:private] => 430224
[_max_northing:private] => 485425
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Lancaster Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/lancaster-canal
[_standfirst:protected] => One of the most scenic canals now on the network, this gentle waterway offers wonderful views of the Silverdale coast, Forest of Bowland and rolling countryside of Wyre.
[_description:protected] => The Lancaster Canal is unique. Being a contour canal (built along the natural lie of the land), it has 41 miles without locks. This is the longest stretch in the country, and in fact the only locks on the main length are derelict! These are at Tewitfield, the southernmost point of the Northern Reaches, and as such are part of the £50 million restoration scheme to reopen the 14 miles of canal to Kendal.
Though the canal was once busy with cargoes from Kendal, Preston and [/in-your-area/lancashire/lancaster Lancaster], it has only just been connected to the national waterway network by the [/canals-and-rivers/ribble-link Millennium Ribble Link].
A waterbus now runs on the canal in the summer months, resurrecting a 200-year old tradition. Enjoy one of a variety of cruises on offer, including Lancaster to Carnforth, Carnforth to Tewitfield, Lancaster country cruises and [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct] Cruises with [/services-directory/4235/lancaster-canal-packet-boats Lancaster Canal Packet Boats].
[/media/documents/22413.pdf Download a guide to Lancaster Canal]
[_id:protected] => 42
[_url_name] => lancaster-canal
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] =>
[_page_limit:private] =>
)
)
)
[7] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Renderer/Component/HtmlRenderer.php
[line] => 18
[function] => fetch
[class] => Waterscape_Component_DirectoryListingPage
[type] => ->
[args] => Array
(
)
)
[8] => 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_FisheryListingPage Object
(
[_fishery_manager:private] =>
[_is_location_page:private] =>
[_location:private] =>
[_preposition:private] =>
[_descriptor:private] =>
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_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] => Fisheries and fishing services along the Lancaster Canal
[_items:protected] =>
[_is_paginated:protected] => 1
[_component_id:protected] => 34
[_parent_id:protected] =>
[_template:protected] => Component/FisheryListPage.tpl
[_page_id:protected] => 712171
[_view_component_id:protected] => 194
[_instance_name:protected] => fisheries
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /canals-and-rivers/lancaster-canal/fishing
[_path:private] => /canals-and-rivers/lancaster-canal/fishing
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => canals-and-rivers/lancaster-canal/fishing
[PHPSESSID] => f7da83f131714adf70f23ca31c6cc052
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 22
[page_id] => 712171
[view_name] => waterway_fishing
[title] => Angling, Fisheries and Fishing %LOCATION_PREPOSITION% %LOCATION_NAME% | Canals and Rivers
[keywords] =>
[description] =>
[layout_template] => Page/locations/location.tpl
[template] => Page/locations/fishing.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Waterways
[path] => /canals-and-rivers/lancaster-canal/fishing
[waterway] => Array
(
[id] => 42
[0] => 42
[name] => Lancaster Canal
[1] => Lancaster Canal
[urlname] => lancaster-canal
[2] => lancaster-canal
[waterway_type] => 15
[3] => 15
[sap_canal_code] => LC
[4] => LC
[introduction] => The Lancaster Canal is unique. Being a contour canal (built along the natural lie of the land), it has 41 miles without locks. This is the longest stretch in the country, and in fact the only locks on the main length are derelict! These are at Tewitfield, the southernmost point of the Northern Reaches, and as such are part of the £50 million restoration scheme to reopen the 14 miles of canal to Kendal.
Though the canal was once busy with cargoes from Kendal, Preston and [/in-your-area/lancashire/lancaster Lancaster], it has only just been connected to the national waterway network by the [/canals-and-rivers/ribble-link Millennium Ribble Link].
A waterbus now runs on the canal in the summer months, resurrecting a 200-year old tradition. Enjoy one of a variety of cruises on offer, including Lancaster to Carnforth, Carnforth to Tewitfield, Lancaster country cruises and [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct] Cruises with [/services-directory/4235/lancaster-canal-packet-boats Lancaster Canal Packet Boats].
[/media/documents/22413.pdf Download a guide to Lancaster Canal]
[5] => The Lancaster Canal is unique. Being a contour canal (built along the natural lie of the land), it has 41 miles without locks. This is the longest stretch in the country, and in fact the only locks on the main length are derelict! These are at Tewitfield, the southernmost point of the Northern Reaches, and as such are part of the £50 million restoration scheme to reopen the 14 miles of canal to Kendal.
Though the canal was once busy with cargoes from Kendal, Preston and [/in-your-area/lancashire/lancaster Lancaster], it has only just been connected to the national waterway network by the [/canals-and-rivers/ribble-link Millennium Ribble Link].
A waterbus now runs on the canal in the summer months, resurrecting a 200-year old tradition. Enjoy one of a variety of cruises on offer, including Lancaster to Carnforth, Carnforth to Tewitfield, Lancaster country cruises and [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct] Cruises with [/services-directory/4235/lancaster-canal-packet-boats Lancaster Canal Packet Boats].
[/media/documents/22413.pdf Download a guide to Lancaster Canal]
[overview] => One of the most scenic canals now on the network, this gentle waterway offers wonderful views of the Silverdale coast, Forest of Bowland and rolling countryside of Wyre.
[6] => One of the most scenic canals now on the network, this gentle waterway offers wonderful views of the Silverdale coast, Forest of Bowland and rolling countryside of Wyre.
[published] => 1
[7] => 1
[metadata_id] =>
[8] =>
[geo_data_id] =>
[9] =>
[importance] => 10
[10] => 10
[min_easting] => 344501
[11] => 344501
[min_northing] => 430224
[12] => 430224
[max_easting] => 353982
[13] => 353982
[max_northing] => 485425
[14] => 485425
[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] => LC
[_min_easting:private] => 344501
[_max_easting:private] => 353982
[_min_northing:private] => 430224
[_max_northing:private] => 485425
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Lancaster Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/lancaster-canal
[_standfirst:protected] => One of the most scenic canals now on the network, this gentle waterway offers wonderful views of the Silverdale coast, Forest of Bowland and rolling countryside of Wyre.
[_description:protected] => The Lancaster Canal is unique. Being a contour canal (built along the natural lie of the land), it has 41 miles without locks. This is the longest stretch in the country, and in fact the only locks on the main length are derelict! These are at Tewitfield, the southernmost point of the Northern Reaches, and as such are part of the £50 million restoration scheme to reopen the 14 miles of canal to Kendal.
Though the canal was once busy with cargoes from Kendal, Preston and [/in-your-area/lancashire/lancaster Lancaster], it has only just been connected to the national waterway network by the [/canals-and-rivers/ribble-link Millennium Ribble Link].
A waterbus now runs on the canal in the summer months, resurrecting a 200-year old tradition. Enjoy one of a variety of cruises on offer, including Lancaster to Carnforth, Carnforth to Tewitfield, Lancaster country cruises and [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct] Cruises with [/services-directory/4235/lancaster-canal-packet-boats Lancaster Canal Packet Boats].
[/media/documents/22413.pdf Download a guide to Lancaster Canal]
[_id:protected] => 42
[_url_name] => lancaster-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] => LC
[_min_easting:private] => 344501
[_max_easting:private] => 353982
[_min_northing:private] => 430224
[_max_northing:private] => 485425
[_centre_easting:private] =>
[_centre_northing:private] =>
[_published:private] => 1
[_parent:private] =>
[_name:protected] => Lancaster Canal
[_urlname:protected] =>
[_basepath:protected] => /canals-and-rivers/lancaster-canal
[_standfirst:protected] => One of the most scenic canals now on the network, this gentle waterway offers wonderful views of the Silverdale coast, Forest of Bowland and rolling countryside of Wyre.
[_description:protected] => The Lancaster Canal is unique. Being a contour canal (built along the natural lie of the land), it has 41 miles without locks. This is the longest stretch in the country, and in fact the only locks on the main length are derelict! These are at Tewitfield, the southernmost point of the Northern Reaches, and as such are part of the £50 million restoration scheme to reopen the 14 miles of canal to Kendal.
Though the canal was once busy with cargoes from Kendal, Preston and [/in-your-area/lancashire/lancaster Lancaster], it has only just been connected to the national waterway network by the [/canals-and-rivers/ribble-link Millennium Ribble Link].
A waterbus now runs on the canal in the summer months, resurrecting a 200-year old tradition. Enjoy one of a variety of cruises on offer, including Lancaster to Carnforth, Carnforth to Tewitfield, Lancaster country cruises and [/in-your-area/lancashire/places-to-go/294/lune-aqueduct Lune Aqueduct] Cruises with [/services-directory/4235/lancaster-canal-packet-boats Lancaster Canal Packet Boats].
[/media/documents/22413.pdf Download a guide to Lancaster Canal]
[_id:protected] => 42
[_url_name] => lancaster-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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[36] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[46] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[57] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[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 id FROM waterway WHERE urlname = ? and published = 1
)
[69] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[70] => 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND w.waterway_id = 42 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 = 5) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 5)) AND i.nationwide = 1 ORDER BY i.name
)
)
[queryCounter] => 71
)
)
[_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_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_component WHERE component_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?