Holidays near Leeds
Discover the joys of a slower pace of life with a relaxing holiday by the water.
Book a boat, a cosy canalside cottage or a luxury hotel.
PDOException Object
(
[message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.nationwide' in 'where clause'
[string:private] =>
[code:protected] => 42S22
[file:protected] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line:protected] => 53
[trace:private] => Array
(
[0] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 53
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 16
[function] => getUnlimitedQueryRowCount
[class] => Waterscape_Database_RecordSet_Paged
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county, sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) AS distance FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
[1] => Array
(
)
)
)
[2] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database.php
[line] => 136
[function] => __construct
[class] => Waterscape_Database_RecordSet_Paged
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county, sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) AS distance FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
[1] => Array
(
)
[2] => 1
[3] => 9
)
)
[3] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Directory/Finder/Abstract.php
[line] => 62
[function] => getPagedRecordSet
[class] => Waterscape_Database
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county, sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) AS distance FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
[1] => 1
[2] => 9
)
)
[4] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 133
[function] => find
[class] => Waterscape_Directory_Finder_Abstract
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 3
[_name:protected] => Holidays
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 427512
[y] => 433898
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20757
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 4
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 396065
[_min_northing:private] => 436596
[_max_easting:private] => 542342
[_max_northing:private] => 519226
[_centre_easting:private] => 440430
[_centre_northing:private] => 428620
[_name:protected] => Yorkshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/yorkshire
[_standfirst:protected] => A multitude of waterways flow through the bustling cities and peaceful dales of Yorkshire.
[_description:protected] => From the mighty [/canals-and-rivers/river-humber Humber] to the scenic [/canals-and-rivers/river-ouse-yorkshire Ouse] and the trans-Pennine [/canals-and-rivers/leeds-and-liverpool-canal Leeds & Liverpool Canal], Yorkshire’s waterways combine rural appeal with historic purpose. Tourists flock to [/in-your-area/yorkshire/york York], walkers love the Dales and pleasure boats are part of the scenery.
Find out more about [http://www.yorkshire.com Yorkshire].
[_id:protected] => 34
[_url_name] => yorkshire
)
[_easting:protected] => 427512
[_northing:protected] => 433898
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Leeds
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/yorkshire/leeds
[_standfirst:protected] => Newly emerging as a centre for commerce and leisure, Leeds is an attractive city on the banks of the River Aire.
[_description:protected] => Not for nothing has Leeds been christened the ‘capital of the north’; it’s bustling streets, chic boutiques and stylish bars create an air of confidence which is reminiscent of [/in-your-area/london London] or [/in-your-area/lowlands/edinburgh Edinburgh]. Through it all threads the peaceful River Aire, an attractive green corridor where residents and commuters can relax.
**Walking to work in Leeds**
The [/canals-and-rivers/leeds-and-liverpool-canal Leeds & Liverpool Canal], the [/canals-and-rivers/aire-and-calder-navigation Aire & Calder Navigation] and the [/canals-and-rivers/river-aire River Aire] are convenient traffic-free pathways through Leeds. Residents lucky enough to work in their home city should consider leaving the car at home and walking to work along the towpath - you’ll benefit from the exercise and are likely to get to work calmer and happier without having spent the morning stuck in traffic. Commuters arriving at Leeds station can take to the towpaths as soon as they leave the train, and follow the Leeds & Liverpool Canal out towards the Aireside Centre or the Aire & Calder Navigation to Warehouse Hill.
Leeds is a very cycle-friendly town, and parts of the towpath are wide enough to accommodate cyclists as well as other users – but remember to dismount under bridges.
**Out and about in Leeds**
Take a day to hit the many shops the city centre has to offer. From chic boutiques to high street and designer stores, there’s something for everyone, whatever your taste or size of your wallet. Many shops are on traffic-free streets, so you can meander around to your hearts content. And after a busy shopping expedition, head to one of the city’s stylish bars or cosy pubs to rest your legs.
If shopping isn’t your thing, take a walk along the River Aire, which gently winds its way through the city centre and out into the midst of West Yorkshire countryside.
[http://www.leedsinitiative.org/environment/page.aspx?id=3206&ekmensel=cdb9b7c3_84_224_3206_1 Aire Action Leeds] are working to create better waterways in Leeds for people and [/features-and-articles/features/wildlife wildlife].
[_id:protected] => 16
[_url_name] => leeds
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] => 1
[_page_limit:private] => 9
)
)
)
[5] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 48
[function] => initItems
[class] => Waterscape_Component_DirectoryListingPage
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 3
[_name:protected] => Holidays
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 427512
[y] => 433898
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20757
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 4
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 396065
[_min_northing:private] => 436596
[_max_easting:private] => 542342
[_max_northing:private] => 519226
[_centre_easting:private] => 440430
[_centre_northing:private] => 428620
[_name:protected] => Yorkshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/yorkshire
[_standfirst:protected] => A multitude of waterways flow through the bustling cities and peaceful dales of Yorkshire.
[_description:protected] => From the mighty [/canals-and-rivers/river-humber Humber] to the scenic [/canals-and-rivers/river-ouse-yorkshire Ouse] and the trans-Pennine [/canals-and-rivers/leeds-and-liverpool-canal Leeds & Liverpool Canal], Yorkshire’s waterways combine rural appeal with historic purpose. Tourists flock to [/in-your-area/yorkshire/york York], walkers love the Dales and pleasure boats are part of the scenery.
Find out more about [http://www.yorkshire.com Yorkshire].
[_id:protected] => 34
[_url_name] => yorkshire
)
[_easting:protected] => 427512
[_northing:protected] => 433898
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Leeds
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/yorkshire/leeds
[_standfirst:protected] => Newly emerging as a centre for commerce and leisure, Leeds is an attractive city on the banks of the River Aire.
[_description:protected] => Not for nothing has Leeds been christened the ‘capital of the north’; it’s bustling streets, chic boutiques and stylish bars create an air of confidence which is reminiscent of [/in-your-area/london London] or [/in-your-area/lowlands/edinburgh Edinburgh]. Through it all threads the peaceful River Aire, an attractive green corridor where residents and commuters can relax.
**Walking to work in Leeds**
The [/canals-and-rivers/leeds-and-liverpool-canal Leeds & Liverpool Canal], the [/canals-and-rivers/aire-and-calder-navigation Aire & Calder Navigation] and the [/canals-and-rivers/river-aire River Aire] are convenient traffic-free pathways through Leeds. Residents lucky enough to work in their home city should consider leaving the car at home and walking to work along the towpath - you’ll benefit from the exercise and are likely to get to work calmer and happier without having spent the morning stuck in traffic. Commuters arriving at Leeds station can take to the towpaths as soon as they leave the train, and follow the Leeds & Liverpool Canal out towards the Aireside Centre or the Aire & Calder Navigation to Warehouse Hill.
Leeds is a very cycle-friendly town, and parts of the towpath are wide enough to accommodate cyclists as well as other users – but remember to dismount under bridges.
**Out and about in Leeds**
Take a day to hit the many shops the city centre has to offer. From chic boutiques to high street and designer stores, there’s something for everyone, whatever your taste or size of your wallet. Many shops are on traffic-free streets, so you can meander around to your hearts content. And after a busy shopping expedition, head to one of the city’s stylish bars or cosy pubs to rest your legs.
If shopping isn’t your thing, take a walk along the River Aire, which gently winds its way through the city centre and out into the midst of West Yorkshire countryside.
[http://www.leedsinitiative.org/environment/page.aspx?id=3206&ekmensel=cdb9b7c3_84_224_3206_1 Aire Action Leeds] are working to create better waterways in Leeds for people and [/features-and-articles/features/wildlife wildlife].
[_id:protected] => 16
[_url_name] => leeds
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] => 1
[_page_limit:private] => 9
)
)
)
[6] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Renderer/Component/HtmlRenderer.php
[line] => 18
[function] => fetch
[class] => Waterscape_Component_DirectoryListingPage
[type] => ->
[args] => Array
(
)
)
[7] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Smarty.php
[line] => 262
[function] => render
[class] => Waterscape_Renderer_Component_HtmlRenderer
[type] => ->
[args] => Array
(
[0] => Waterscape_Component_DirectoryListingPage Object
(
[_is_location_page:private] => 1
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 427512
[y] => 433898
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20757
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 4
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 396065
[_min_northing:private] => 436596
[_max_easting:private] => 542342
[_max_northing:private] => 519226
[_centre_easting:private] => 440430
[_centre_northing:private] => 428620
[_name:protected] => Yorkshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/yorkshire
[_standfirst:protected] => A multitude of waterways flow through the bustling cities and peaceful dales of Yorkshire.
[_description:protected] => From the mighty [/canals-and-rivers/river-humber Humber] to the scenic [/canals-and-rivers/river-ouse-yorkshire Ouse] and the trans-Pennine [/canals-and-rivers/leeds-and-liverpool-canal Leeds & Liverpool Canal], Yorkshire’s waterways combine rural appeal with historic purpose. Tourists flock to [/in-your-area/yorkshire/york York], walkers love the Dales and pleasure boats are part of the scenery.
Find out more about [http://www.yorkshire.com Yorkshire].
[_id:protected] => 34
[_url_name] => yorkshire
)
[_easting:protected] => 427512
[_northing:protected] => 433898
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Leeds
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/yorkshire/leeds
[_standfirst:protected] => Newly emerging as a centre for commerce and leisure, Leeds is an attractive city on the banks of the River Aire.
[_description:protected] => Not for nothing has Leeds been christened the ‘capital of the north’; it’s bustling streets, chic boutiques and stylish bars create an air of confidence which is reminiscent of [/in-your-area/london London] or [/in-your-area/lowlands/edinburgh Edinburgh]. Through it all threads the peaceful River Aire, an attractive green corridor where residents and commuters can relax.
**Walking to work in Leeds**
The [/canals-and-rivers/leeds-and-liverpool-canal Leeds & Liverpool Canal], the [/canals-and-rivers/aire-and-calder-navigation Aire & Calder Navigation] and the [/canals-and-rivers/river-aire River Aire] are convenient traffic-free pathways through Leeds. Residents lucky enough to work in their home city should consider leaving the car at home and walking to work along the towpath - you’ll benefit from the exercise and are likely to get to work calmer and happier without having spent the morning stuck in traffic. Commuters arriving at Leeds station can take to the towpaths as soon as they leave the train, and follow the Leeds & Liverpool Canal out towards the Aireside Centre or the Aire & Calder Navigation to Warehouse Hill.
Leeds is a very cycle-friendly town, and parts of the towpath are wide enough to accommodate cyclists as well as other users – but remember to dismount under bridges.
**Out and about in Leeds**
Take a day to hit the many shops the city centre has to offer. From chic boutiques to high street and designer stores, there’s something for everyone, whatever your taste or size of your wallet. Many shops are on traffic-free streets, so you can meander around to your hearts content. And after a busy shopping expedition, head to one of the city’s stylish bars or cosy pubs to rest your legs.
If shopping isn’t your thing, take a walk along the River Aire, which gently winds its way through the city centre and out into the midst of West Yorkshire countryside.
[http://www.leedsinitiative.org/environment/page.aspx?id=3206&ekmensel=cdb9b7c3_84_224_3206_1 Aire Action Leeds] are working to create better waterways in Leeds for people and [/features-and-articles/features/wildlife wildlife].
[_id:protected] => 16
[_url_name] => leeds
)
[_preposition:private] => near
[_descriptor:private] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 3
[_name:protected] => Holidays
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_business_manager:private] =>
[_location_manager:private] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_geo_point_mgr:private] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_town_manager:private] =>
[_limit:protected] =>
[_title:protected] =>
[_items:protected] =>
[_is_paginated:protected] => 1
[_component_id:protected] => 14
[_parent_id:protected] =>
[_template:protected] => Component/ListingPage.tpl
[_page_id:protected] => 2509
[_view_component_id:protected] => 86
[_instance_name:protected] => directory_page
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/yorkshire/leeds/holidays
[_path:private] => /in-your-area/yorkshire/leeds/holidays
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/yorkshire/leeds/holidays
[PHPSESSID] => b564e3bd64899df372a334b994ec2713
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 20
[page_id] => 2509
[view_name] => locations_holidays
[title] => Canal Holidays %LOCATION_PREPOSITION% %LOCATION_NAME% %LOCATION_COUNTY_NAME% | Cottages and Hotels %LOCATION_PREPOSITION% %LOCATION_NAME% | Canals and Rivers
[keywords] =>
[description] =>
[layout_template] => Page/locations/location.tpl
[template] => Page/locations/holidays.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Locations
[path] => /in-your-area/yorkshire/leeds/holidays
[location] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 427512
[y] => 433898
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20757
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 4
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 396065
[_min_northing:private] => 436596
[_max_easting:private] => 542342
[_max_northing:private] => 519226
[_centre_easting:private] => 440430
[_centre_northing:private] => 428620
[_name:protected] => Yorkshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/yorkshire
[_standfirst:protected] => A multitude of waterways flow through the bustling cities and peaceful dales of Yorkshire.
[_description:protected] => From the mighty [/canals-and-rivers/river-humber Humber] to the scenic [/canals-and-rivers/river-ouse-yorkshire Ouse] and the trans-Pennine [/canals-and-rivers/leeds-and-liverpool-canal Leeds & Liverpool Canal], Yorkshire’s waterways combine rural appeal with historic purpose. Tourists flock to [/in-your-area/yorkshire/york York], walkers love the Dales and pleasure boats are part of the scenery.
Find out more about [http://www.yorkshire.com Yorkshire].
[_id:protected] => 34
[_url_name] => yorkshire
)
[_easting:protected] => 427512
[_northing:protected] => 433898
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Leeds
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/yorkshire/leeds
[_standfirst:protected] => Newly emerging as a centre for commerce and leisure, Leeds is an attractive city on the banks of the River Aire.
[_description:protected] => Not for nothing has Leeds been christened the ‘capital of the north’; it’s bustling streets, chic boutiques and stylish bars create an air of confidence which is reminiscent of [/in-your-area/london London] or [/in-your-area/lowlands/edinburgh Edinburgh]. Through it all threads the peaceful River Aire, an attractive green corridor where residents and commuters can relax.
**Walking to work in Leeds**
The [/canals-and-rivers/leeds-and-liverpool-canal Leeds & Liverpool Canal], the [/canals-and-rivers/aire-and-calder-navigation Aire & Calder Navigation] and the [/canals-and-rivers/river-aire River Aire] are convenient traffic-free pathways through Leeds. Residents lucky enough to work in their home city should consider leaving the car at home and walking to work along the towpath - you’ll benefit from the exercise and are likely to get to work calmer and happier without having spent the morning stuck in traffic. Commuters arriving at Leeds station can take to the towpaths as soon as they leave the train, and follow the Leeds & Liverpool Canal out towards the Aireside Centre or the Aire & Calder Navigation to Warehouse Hill.
Leeds is a very cycle-friendly town, and parts of the towpath are wide enough to accommodate cyclists as well as other users – but remember to dismount under bridges.
**Out and about in Leeds**
Take a day to hit the many shops the city centre has to offer. From chic boutiques to high street and designer stores, there’s something for everyone, whatever your taste or size of your wallet. Many shops are on traffic-free streets, so you can meander around to your hearts content. And after a busy shopping expedition, head to one of the city’s stylish bars or cosy pubs to rest your legs.
If shopping isn’t your thing, take a walk along the River Aire, which gently winds its way through the city centre and out into the midst of West Yorkshire countryside.
[http://www.leedsinitiative.org/environment/page.aspx?id=3206&ekmensel=cdb9b7c3_84_224_3206_1 Aire Action Leeds] are working to create better waterways in Leeds for people and [/features-and-articles/features/wildlife wildlife].
[_id:protected] => 16
[_url_name] => leeds
)
[preposition] => near
[section] => holidays
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 427512
[y] => 433898
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20757
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 4
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 396065
[_min_northing:private] => 436596
[_max_easting:private] => 542342
[_max_northing:private] => 519226
[_centre_easting:private] => 440430
[_centre_northing:private] => 428620
[_name:protected] => Yorkshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/yorkshire
[_standfirst:protected] => A multitude of waterways flow through the bustling cities and peaceful dales of Yorkshire.
[_description:protected] => From the mighty [/canals-and-rivers/river-humber Humber] to the scenic [/canals-and-rivers/river-ouse-yorkshire Ouse] and the trans-Pennine [/canals-and-rivers/leeds-and-liverpool-canal Leeds & Liverpool Canal], Yorkshire’s waterways combine rural appeal with historic purpose. Tourists flock to [/in-your-area/yorkshire/york York], walkers love the Dales and pleasure boats are part of the scenery.
Find out more about [http://www.yorkshire.com Yorkshire].
[_id:protected] => 34
[_url_name] => yorkshire
)
[_easting:protected] => 427512
[_northing:protected] => 433898
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Leeds
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/yorkshire/leeds
[_standfirst:protected] => Newly emerging as a centre for commerce and leisure, Leeds is an attractive city on the banks of the River Aire.
[_description:protected] => Not for nothing has Leeds been christened the ‘capital of the north’; it’s bustling streets, chic boutiques and stylish bars create an air of confidence which is reminiscent of [/in-your-area/london London] or [/in-your-area/lowlands/edinburgh Edinburgh]. Through it all threads the peaceful River Aire, an attractive green corridor where residents and commuters can relax.
**Walking to work in Leeds**
The [/canals-and-rivers/leeds-and-liverpool-canal Leeds & Liverpool Canal], the [/canals-and-rivers/aire-and-calder-navigation Aire & Calder Navigation] and the [/canals-and-rivers/river-aire River Aire] are convenient traffic-free pathways through Leeds. Residents lucky enough to work in their home city should consider leaving the car at home and walking to work along the towpath - you’ll benefit from the exercise and are likely to get to work calmer and happier without having spent the morning stuck in traffic. Commuters arriving at Leeds station can take to the towpaths as soon as they leave the train, and follow the Leeds & Liverpool Canal out towards the Aireside Centre or the Aire & Calder Navigation to Warehouse Hill.
Leeds is a very cycle-friendly town, and parts of the towpath are wide enough to accommodate cyclists as well as other users – but remember to dismount under bridges.
**Out and about in Leeds**
Take a day to hit the many shops the city centre has to offer. From chic boutiques to high street and designer stores, there’s something for everyone, whatever your taste or size of your wallet. Many shops are on traffic-free streets, so you can meander around to your hearts content. And after a busy shopping expedition, head to one of the city’s stylish bars or cosy pubs to rest your legs.
If shopping isn’t your thing, take a walk along the River Aire, which gently winds its way through the city centre and out into the midst of West Yorkshire countryside.
[http://www.leedsinitiative.org/environment/page.aspx?id=3206&ekmensel=cdb9b7c3_84_224_3206_1 Aire Action Leeds] are working to create better waterways in Leeds for people and [/features-and-articles/features/wildlife wildlife].
[_id:protected] => 16
[_url_name] => leeds
)
[_na_office_manager:private] => Waterscape_Service_NavigationAuthorityOfficeManager Object
(
[_navigation_authority_office_dao:private] => Waterscape_Dao_NavigationAuthorityOffice Object
(
[_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_navigation_authority_dao:private] => Waterscape_Dao_NavigationAuthority Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
[_stoppage_manager:private] => Waterscape_Service_StoppageManager Object
(
[_stoppage_dao:private] => Waterscape_Dao_Stoppage Object
(
[_waterway_mgr:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion Object
(
[_db:protected] =>
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType Object
(
[_db:protected] =>
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription Object
(
[_db:protected] =>
)
)
[_criteria:private] => Array
(
)
[_raw_criteria:private] =>
[_sql_strings:private] => Array
(
)
[_sql_values:private] => Array
(
)
[_search_data_by:private] => Array
(
[all] => 0
[stoppage] => s
[restriction] => r
[opening_times] => o
[booking_details] => b
[advice] => a
[towpath_closure_only] => t
)
[_str_types_selected:private] =>
[_stoppage_type:private] =>
[_db:protected] =>
)
)
[_route_manager:private] => Waterscape_Service_RouteManager Object
(
[_route_dao:private] => Waterscape_Dao_Route Object
(
[_route_type_manager:private] => Waterscape_Service_RouteTypeManager Object
(
[_route_type_dao:private] => Waterscape_Dao_RouteType Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_waypoint_manager:private] => Waterscape_Service_WaypointManager Object
(
[_waypoint_dao:private] => Waterscape_Dao_Waypoint Object
(
[_metadata_mgr:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_geo_point_mgr:private] =>
[_geo_data_type_manager:private] => Waterscape_Service_GeoDataTypeManager Object
(
[_geo_data_dao:private] => Waterscape_Dao_GeoDataType Object
(
[_db:protected] =>
)
)
[_db:protected] =>
[_geo_point_manager] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_geo_point_mgr:private] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
[_media_manager:private] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(427512-m.easting,2)+pow(433898-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_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] =>
)
)
)
[_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 town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?