Wildlife near Hanwell
You'll find all sorts of wildlife on Britain's canals and rivers - from common sights such as mallards and moorhens, to the more shy and retiring residents of the riverbank, like the otter and water vole. And the good news is that half of the UK population live within five miles of the waterways, so there's nothing to stop you taking a walk along the towpath and spotting some waterside wildlife.
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(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-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(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-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(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-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] => 8
[_name:protected] => Wildlife
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
)
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 516926
[y] => 179343
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20753
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 35
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 517139
[_min_northing:private] => 167412
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 537320
[_centre_northing:private] => 183680
[_name:protected] => London
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/london
[_standfirst:protected] => "When a man is tired of London he is tired of life."
[_description:protected] => Quite right! But in fairness, there’s a lot by London's waterside to tire you out. There’s the infamous Tower, the [/in-your-area/london/places-to-go/287/london-eye London Eye], [/in-your-area/london/places-to-go/280/little-venice Little Venice], [/in-your-area/london/places-to-go/91/camden-lock-market Camden Town] and about 100 waterside pubs - but a peaceful stroll by the [/canals-and-rivers/regents-canal Regent's Canal] will take you worlds away from the big city bustle.
[/media/documents/22210.pdf Download a guide and map to West London’s canals].
[/media/documents/22216.pdf Download a guide and map to Central London's canals]
[/media/documents/22239.pdf Download a guide and map to the East End's canals and London Docklands]
[_id:protected] => 11
[_url_name] => london
)
[_easting:protected] => 516926
[_northing:protected] => 179343
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Hanwell
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/london/hanwell
[_standfirst:protected] => Enjoy a day-out in the countryside along the Grand Union Canal at the picturesque Hanwell Flight of Locks.
[_description:protected] => Hanwell Locks and Norwood Locks is a delightful place to spot [/features-and-articles/features/wildlife wildlife] and learn a bit of canal history. You can explore further afield, along the Brent River Park Walk, or take the [/canals-and-rivers/grand-union-canal Grand Union Canal] Walk all the way into [/in-your-area/warwickshire/birmingham Birmingham].
**Back in time**
William Jessop, chief engineer of the Grand Junction Canal, was a pioneer in his day. Here at Hanwell Locks, Jessop had the foresight to build locks which were wide enough to take two narrowboats at the same time.
**Hanwell Flight of Locks is now a Scheduled Ancient Monument.**
**What to see**
A canal is a wildlife corridor and a wonderful place to explore. Hanwell Flight and the River Brent provide a safe haven for birds, insects, small mammals such as water voles, and wild flowers. They are all here to see if you look carefully.
Find out more about [http://www.waterscape.com/features/wildlife/ waterway wildlife]
**Go for a walk along the canal**
A canal site changes over the years as people use it in different ways and these people leave a trail of history behind them. You can follow this history trail along the towpath and find evidence of the past.
There are [http://www.waterscape.com/features-and-articles/features/waterway-heritage/canal-cottages lock keepers’ cottages] beside many of the locks. Most of them are privately owned, so please respect the owner’s privacy. In the early nineteenth century, when the cottages were built, lock-keepers had a busy life making sure that the passage of boats up and down the flight ran smoothly.
Two of the cottages along the towpath at Hanwell Locks have been demolished. Can you see where they are? One of them was on an island on the River Brent where there is now a picnic area.
**Rope burns**
When your boat enters a lock, you hitch a rope around a bollard. As your boat nears the bollard, you take up the rope slack, keeping the boat close to the lock side. When your boat passes the bollard, you will need strength in your arms, legs and back as you let out some of the rope which judders and snaps tight around the bollard. This is how rope burns are made.
Bollards come in all shapes and sizes. Some are metal, others are made from tree trunks.
Read more about [http://www.waterscape.com/features-and-articles/features/waterway-heritage canal heritage]
Explore the area around Hanwell Locks with our detailed [/things-to-do/walking/routes/187/hanwell-flight-circular-walk-from-boston-manor-station circular walk]
**Go for a meal**
[/services-directory/2262/the-fox-hanwell The Fox] public house, near Lock 97, serves food.
Find a pub or restaurant in nearby Brentford with the Waterscape.com [/things-to-do/pubs-and-restaurants/reviews/london/brentford eating and drinking guide]
**Did you know..?**
Horses towing narrowboats could be dragged into the canal when their ropes became crossed on busy days. Boatmen would say that a horse ‘took a look’ when it was pulled into the canal. But how did it get out again? Look closely and you’ll find that what looks like a path into the canal is actually a way out of it.
Read more about [http://www.waterscape.com/features-and-articles/features/going-horseboating horseboating]
**Access and directions**
You can join the Grand Union Canal towpath at the bottom of Hanwell Locks from Green Lane, W7 and at Norwood Top Lock from Havelock Road.
Boston Manor on the Piccadilly Line is the nearest London Underground Station. The closest British Rail station is at Hanwell.
[_id:protected] => 12
[_url_name] => hanwell
)
[_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] => 8
[_name:protected] => Wildlife
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
)
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 516926
[y] => 179343
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20753
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 35
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 517139
[_min_northing:private] => 167412
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 537320
[_centre_northing:private] => 183680
[_name:protected] => London
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/london
[_standfirst:protected] => "When a man is tired of London he is tired of life."
[_description:protected] => Quite right! But in fairness, there’s a lot by London's waterside to tire you out. There’s the infamous Tower, the [/in-your-area/london/places-to-go/287/london-eye London Eye], [/in-your-area/london/places-to-go/280/little-venice Little Venice], [/in-your-area/london/places-to-go/91/camden-lock-market Camden Town] and about 100 waterside pubs - but a peaceful stroll by the [/canals-and-rivers/regents-canal Regent's Canal] will take you worlds away from the big city bustle.
[/media/documents/22210.pdf Download a guide and map to West London’s canals].
[/media/documents/22216.pdf Download a guide and map to Central London's canals]
[/media/documents/22239.pdf Download a guide and map to the East End's canals and London Docklands]
[_id:protected] => 11
[_url_name] => london
)
[_easting:protected] => 516926
[_northing:protected] => 179343
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Hanwell
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/london/hanwell
[_standfirst:protected] => Enjoy a day-out in the countryside along the Grand Union Canal at the picturesque Hanwell Flight of Locks.
[_description:protected] => Hanwell Locks and Norwood Locks is a delightful place to spot [/features-and-articles/features/wildlife wildlife] and learn a bit of canal history. You can explore further afield, along the Brent River Park Walk, or take the [/canals-and-rivers/grand-union-canal Grand Union Canal] Walk all the way into [/in-your-area/warwickshire/birmingham Birmingham].
**Back in time**
William Jessop, chief engineer of the Grand Junction Canal, was a pioneer in his day. Here at Hanwell Locks, Jessop had the foresight to build locks which were wide enough to take two narrowboats at the same time.
**Hanwell Flight of Locks is now a Scheduled Ancient Monument.**
**What to see**
A canal is a wildlife corridor and a wonderful place to explore. Hanwell Flight and the River Brent provide a safe haven for birds, insects, small mammals such as water voles, and wild flowers. They are all here to see if you look carefully.
Find out more about [http://www.waterscape.com/features/wildlife/ waterway wildlife]
**Go for a walk along the canal**
A canal site changes over the years as people use it in different ways and these people leave a trail of history behind them. You can follow this history trail along the towpath and find evidence of the past.
There are [http://www.waterscape.com/features-and-articles/features/waterway-heritage/canal-cottages lock keepers’ cottages] beside many of the locks. Most of them are privately owned, so please respect the owner’s privacy. In the early nineteenth century, when the cottages were built, lock-keepers had a busy life making sure that the passage of boats up and down the flight ran smoothly.
Two of the cottages along the towpath at Hanwell Locks have been demolished. Can you see where they are? One of them was on an island on the River Brent where there is now a picnic area.
**Rope burns**
When your boat enters a lock, you hitch a rope around a bollard. As your boat nears the bollard, you take up the rope slack, keeping the boat close to the lock side. When your boat passes the bollard, you will need strength in your arms, legs and back as you let out some of the rope which judders and snaps tight around the bollard. This is how rope burns are made.
Bollards come in all shapes and sizes. Some are metal, others are made from tree trunks.
Read more about [http://www.waterscape.com/features-and-articles/features/waterway-heritage canal heritage]
Explore the area around Hanwell Locks with our detailed [/things-to-do/walking/routes/187/hanwell-flight-circular-walk-from-boston-manor-station circular walk]
**Go for a meal**
[/services-directory/2262/the-fox-hanwell The Fox] public house, near Lock 97, serves food.
Find a pub or restaurant in nearby Brentford with the Waterscape.com [/things-to-do/pubs-and-restaurants/reviews/london/brentford eating and drinking guide]
**Did you know..?**
Horses towing narrowboats could be dragged into the canal when their ropes became crossed on busy days. Boatmen would say that a horse ‘took a look’ when it was pulled into the canal. But how did it get out again? Look closely and you’ll find that what looks like a path into the canal is actually a way out of it.
Read more about [http://www.waterscape.com/features-and-articles/features/going-horseboating horseboating]
**Access and directions**
You can join the Grand Union Canal towpath at the bottom of Hanwell Locks from Green Lane, W7 and at Norwood Top Lock from Havelock Road.
Boston Manor on the Piccadilly Line is the nearest London Underground Station. The closest British Rail station is at Hanwell.
[_id:protected] => 12
[_url_name] => hanwell
)
[_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] => 516926
[y] => 179343
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20753
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 35
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 517139
[_min_northing:private] => 167412
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 537320
[_centre_northing:private] => 183680
[_name:protected] => London
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/london
[_standfirst:protected] => "When a man is tired of London he is tired of life."
[_description:protected] => Quite right! But in fairness, there’s a lot by London's waterside to tire you out. There’s the infamous Tower, the [/in-your-area/london/places-to-go/287/london-eye London Eye], [/in-your-area/london/places-to-go/280/little-venice Little Venice], [/in-your-area/london/places-to-go/91/camden-lock-market Camden Town] and about 100 waterside pubs - but a peaceful stroll by the [/canals-and-rivers/regents-canal Regent's Canal] will take you worlds away from the big city bustle.
[/media/documents/22210.pdf Download a guide and map to West London’s canals].
[/media/documents/22216.pdf Download a guide and map to Central London's canals]
[/media/documents/22239.pdf Download a guide and map to the East End's canals and London Docklands]
[_id:protected] => 11
[_url_name] => london
)
[_easting:protected] => 516926
[_northing:protected] => 179343
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Hanwell
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/london/hanwell
[_standfirst:protected] => Enjoy a day-out in the countryside along the Grand Union Canal at the picturesque Hanwell Flight of Locks.
[_description:protected] => Hanwell Locks and Norwood Locks is a delightful place to spot [/features-and-articles/features/wildlife wildlife] and learn a bit of canal history. You can explore further afield, along the Brent River Park Walk, or take the [/canals-and-rivers/grand-union-canal Grand Union Canal] Walk all the way into [/in-your-area/warwickshire/birmingham Birmingham].
**Back in time**
William Jessop, chief engineer of the Grand Junction Canal, was a pioneer in his day. Here at Hanwell Locks, Jessop had the foresight to build locks which were wide enough to take two narrowboats at the same time.
**Hanwell Flight of Locks is now a Scheduled Ancient Monument.**
**What to see**
A canal is a wildlife corridor and a wonderful place to explore. Hanwell Flight and the River Brent provide a safe haven for birds, insects, small mammals such as water voles, and wild flowers. They are all here to see if you look carefully.
Find out more about [http://www.waterscape.com/features/wildlife/ waterway wildlife]
**Go for a walk along the canal**
A canal site changes over the years as people use it in different ways and these people leave a trail of history behind them. You can follow this history trail along the towpath and find evidence of the past.
There are [http://www.waterscape.com/features-and-articles/features/waterway-heritage/canal-cottages lock keepers’ cottages] beside many of the locks. Most of them are privately owned, so please respect the owner’s privacy. In the early nineteenth century, when the cottages were built, lock-keepers had a busy life making sure that the passage of boats up and down the flight ran smoothly.
Two of the cottages along the towpath at Hanwell Locks have been demolished. Can you see where they are? One of them was on an island on the River Brent where there is now a picnic area.
**Rope burns**
When your boat enters a lock, you hitch a rope around a bollard. As your boat nears the bollard, you take up the rope slack, keeping the boat close to the lock side. When your boat passes the bollard, you will need strength in your arms, legs and back as you let out some of the rope which judders and snaps tight around the bollard. This is how rope burns are made.
Bollards come in all shapes and sizes. Some are metal, others are made from tree trunks.
Read more about [http://www.waterscape.com/features-and-articles/features/waterway-heritage canal heritage]
Explore the area around Hanwell Locks with our detailed [/things-to-do/walking/routes/187/hanwell-flight-circular-walk-from-boston-manor-station circular walk]
**Go for a meal**
[/services-directory/2262/the-fox-hanwell The Fox] public house, near Lock 97, serves food.
Find a pub or restaurant in nearby Brentford with the Waterscape.com [/things-to-do/pubs-and-restaurants/reviews/london/brentford eating and drinking guide]
**Did you know..?**
Horses towing narrowboats could be dragged into the canal when their ropes became crossed on busy days. Boatmen would say that a horse ‘took a look’ when it was pulled into the canal. But how did it get out again? Look closely and you’ll find that what looks like a path into the canal is actually a way out of it.
Read more about [http://www.waterscape.com/features-and-articles/features/going-horseboating horseboating]
**Access and directions**
You can join the Grand Union Canal towpath at the bottom of Hanwell Locks from Green Lane, W7 and at Norwood Top Lock from Havelock Road.
Boston Manor on the Piccadilly Line is the nearest London Underground Station. The closest British Rail station is at Hanwell.
[_id:protected] => 12
[_url_name] => hanwell
)
[_preposition:private] => near
[_descriptor:private] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 8
[_name:protected] => Wildlife
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
)
[_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] => 2336
[_view_component_id:protected] => 82
[_instance_name:protected] => directory_page
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/london/hanwell/wildlife
[_path:private] => /in-your-area/london/hanwell/wildlife
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/london/hanwell/wildlife
[PHPSESSID] => eddee2de303f83969c3140dbee32aded
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 17
[page_id] => 2336
[view_name] => locations_wildlife
[title] => Wildlife %LOCATION_PREPOSITION% %LOCATION_NAME% %LOCATION_COUNTY_NAME% | Canals and Rivers | Waterscape.com
[keywords] =>
[description] =>
[layout_template] => Page/locations/location.tpl
[template] => Page/locations/wildlife.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Locations
[path] => /in-your-area/london/hanwell/wildlife
[location] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 516926
[y] => 179343
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20753
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 35
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 517139
[_min_northing:private] => 167412
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 537320
[_centre_northing:private] => 183680
[_name:protected] => London
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/london
[_standfirst:protected] => "When a man is tired of London he is tired of life."
[_description:protected] => Quite right! But in fairness, there’s a lot by London's waterside to tire you out. There’s the infamous Tower, the [/in-your-area/london/places-to-go/287/london-eye London Eye], [/in-your-area/london/places-to-go/280/little-venice Little Venice], [/in-your-area/london/places-to-go/91/camden-lock-market Camden Town] and about 100 waterside pubs - but a peaceful stroll by the [/canals-and-rivers/regents-canal Regent's Canal] will take you worlds away from the big city bustle.
[/media/documents/22210.pdf Download a guide and map to West London’s canals].
[/media/documents/22216.pdf Download a guide and map to Central London's canals]
[/media/documents/22239.pdf Download a guide and map to the East End's canals and London Docklands]
[_id:protected] => 11
[_url_name] => london
)
[_easting:protected] => 516926
[_northing:protected] => 179343
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Hanwell
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/london/hanwell
[_standfirst:protected] => Enjoy a day-out in the countryside along the Grand Union Canal at the picturesque Hanwell Flight of Locks.
[_description:protected] => Hanwell Locks and Norwood Locks is a delightful place to spot [/features-and-articles/features/wildlife wildlife] and learn a bit of canal history. You can explore further afield, along the Brent River Park Walk, or take the [/canals-and-rivers/grand-union-canal Grand Union Canal] Walk all the way into [/in-your-area/warwickshire/birmingham Birmingham].
**Back in time**
William Jessop, chief engineer of the Grand Junction Canal, was a pioneer in his day. Here at Hanwell Locks, Jessop had the foresight to build locks which were wide enough to take two narrowboats at the same time.
**Hanwell Flight of Locks is now a Scheduled Ancient Monument.**
**What to see**
A canal is a wildlife corridor and a wonderful place to explore. Hanwell Flight and the River Brent provide a safe haven for birds, insects, small mammals such as water voles, and wild flowers. They are all here to see if you look carefully.
Find out more about [http://www.waterscape.com/features/wildlife/ waterway wildlife]
**Go for a walk along the canal**
A canal site changes over the years as people use it in different ways and these people leave a trail of history behind them. You can follow this history trail along the towpath and find evidence of the past.
There are [http://www.waterscape.com/features-and-articles/features/waterway-heritage/canal-cottages lock keepers’ cottages] beside many of the locks. Most of them are privately owned, so please respect the owner’s privacy. In the early nineteenth century, when the cottages were built, lock-keepers had a busy life making sure that the passage of boats up and down the flight ran smoothly.
Two of the cottages along the towpath at Hanwell Locks have been demolished. Can you see where they are? One of them was on an island on the River Brent where there is now a picnic area.
**Rope burns**
When your boat enters a lock, you hitch a rope around a bollard. As your boat nears the bollard, you take up the rope slack, keeping the boat close to the lock side. When your boat passes the bollard, you will need strength in your arms, legs and back as you let out some of the rope which judders and snaps tight around the bollard. This is how rope burns are made.
Bollards come in all shapes and sizes. Some are metal, others are made from tree trunks.
Read more about [http://www.waterscape.com/features-and-articles/features/waterway-heritage canal heritage]
Explore the area around Hanwell Locks with our detailed [/things-to-do/walking/routes/187/hanwell-flight-circular-walk-from-boston-manor-station circular walk]
**Go for a meal**
[/services-directory/2262/the-fox-hanwell The Fox] public house, near Lock 97, serves food.
Find a pub or restaurant in nearby Brentford with the Waterscape.com [/things-to-do/pubs-and-restaurants/reviews/london/brentford eating and drinking guide]
**Did you know..?**
Horses towing narrowboats could be dragged into the canal when their ropes became crossed on busy days. Boatmen would say that a horse ‘took a look’ when it was pulled into the canal. But how did it get out again? Look closely and you’ll find that what looks like a path into the canal is actually a way out of it.
Read more about [http://www.waterscape.com/features-and-articles/features/going-horseboating horseboating]
**Access and directions**
You can join the Grand Union Canal towpath at the bottom of Hanwell Locks from Green Lane, W7 and at Norwood Top Lock from Havelock Road.
Boston Manor on the Piccadilly Line is the nearest London Underground Station. The closest British Rail station is at Hanwell.
[_id:protected] => 12
[_url_name] => hanwell
)
[preposition] => near
[section] => wildlife
[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] => 516926
[y] => 179343
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20753
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 35
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 517139
[_min_northing:private] => 167412
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 537320
[_centre_northing:private] => 183680
[_name:protected] => London
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/london
[_standfirst:protected] => "When a man is tired of London he is tired of life."
[_description:protected] => Quite right! But in fairness, there’s a lot by London's waterside to tire you out. There’s the infamous Tower, the [/in-your-area/london/places-to-go/287/london-eye London Eye], [/in-your-area/london/places-to-go/280/little-venice Little Venice], [/in-your-area/london/places-to-go/91/camden-lock-market Camden Town] and about 100 waterside pubs - but a peaceful stroll by the [/canals-and-rivers/regents-canal Regent's Canal] will take you worlds away from the big city bustle.
[/media/documents/22210.pdf Download a guide and map to West London’s canals].
[/media/documents/22216.pdf Download a guide and map to Central London's canals]
[/media/documents/22239.pdf Download a guide and map to the East End's canals and London Docklands]
[_id:protected] => 11
[_url_name] => london
)
[_easting:protected] => 516926
[_northing:protected] => 179343
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Hanwell
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/london/hanwell
[_standfirst:protected] => Enjoy a day-out in the countryside along the Grand Union Canal at the picturesque Hanwell Flight of Locks.
[_description:protected] => Hanwell Locks and Norwood Locks is a delightful place to spot [/features-and-articles/features/wildlife wildlife] and learn a bit of canal history. You can explore further afield, along the Brent River Park Walk, or take the [/canals-and-rivers/grand-union-canal Grand Union Canal] Walk all the way into [/in-your-area/warwickshire/birmingham Birmingham].
**Back in time**
William Jessop, chief engineer of the Grand Junction Canal, was a pioneer in his day. Here at Hanwell Locks, Jessop had the foresight to build locks which were wide enough to take two narrowboats at the same time.
**Hanwell Flight of Locks is now a Scheduled Ancient Monument.**
**What to see**
A canal is a wildlife corridor and a wonderful place to explore. Hanwell Flight and the River Brent provide a safe haven for birds, insects, small mammals such as water voles, and wild flowers. They are all here to see if you look carefully.
Find out more about [http://www.waterscape.com/features/wildlife/ waterway wildlife]
**Go for a walk along the canal**
A canal site changes over the years as people use it in different ways and these people leave a trail of history behind them. You can follow this history trail along the towpath and find evidence of the past.
There are [http://www.waterscape.com/features-and-articles/features/waterway-heritage/canal-cottages lock keepers’ cottages] beside many of the locks. Most of them are privately owned, so please respect the owner’s privacy. In the early nineteenth century, when the cottages were built, lock-keepers had a busy life making sure that the passage of boats up and down the flight ran smoothly.
Two of the cottages along the towpath at Hanwell Locks have been demolished. Can you see where they are? One of them was on an island on the River Brent where there is now a picnic area.
**Rope burns**
When your boat enters a lock, you hitch a rope around a bollard. As your boat nears the bollard, you take up the rope slack, keeping the boat close to the lock side. When your boat passes the bollard, you will need strength in your arms, legs and back as you let out some of the rope which judders and snaps tight around the bollard. This is how rope burns are made.
Bollards come in all shapes and sizes. Some are metal, others are made from tree trunks.
Read more about [http://www.waterscape.com/features-and-articles/features/waterway-heritage canal heritage]
Explore the area around Hanwell Locks with our detailed [/things-to-do/walking/routes/187/hanwell-flight-circular-walk-from-boston-manor-station circular walk]
**Go for a meal**
[/services-directory/2262/the-fox-hanwell The Fox] public house, near Lock 97, serves food.
Find a pub or restaurant in nearby Brentford with the Waterscape.com [/things-to-do/pubs-and-restaurants/reviews/london/brentford eating and drinking guide]
**Did you know..?**
Horses towing narrowboats could be dragged into the canal when their ropes became crossed on busy days. Boatmen would say that a horse ‘took a look’ when it was pulled into the canal. But how did it get out again? Look closely and you’ll find that what looks like a path into the canal is actually a way out of it.
Read more about [http://www.waterscape.com/features-and-articles/features/going-horseboating horseboating]
**Access and directions**
You can join the Grand Union Canal towpath at the bottom of Hanwell Locks from Green Lane, W7 and at Norwood Top Lock from Havelock Road.
Boston Manor on the Piccadilly Line is the nearest London Underground Station. The closest British Rail station is at Hanwell.
[_id:protected] => 12
[_url_name] => hanwell
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
)
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[98] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[99] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[101] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[102] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[103] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[104] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[106] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[107] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[108] => 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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND sqrt(pow(516926-m.easting,2)+pow(179343-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 = 8) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 8)) AND i.nationwide = 1 ORDER BY sqrt(pow(516926-m.easting,2)+pow(179343-m.northing,2)) ASC
)
)
[queryCounter] => 109
)
)
[_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 * FROM town WHERE town_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[10] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[15] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[21] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[31] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_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_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[47] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_component WHERE component_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 content_page WHERE page_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[54] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[55] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[57] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[58] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[60] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[63] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[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 content_page WHERE page_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[69] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[72] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[74] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[78] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[79] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[81] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[82] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[83] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[84] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[85] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[86] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[87] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[88] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[90] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[91] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[92] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[93] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[94] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[95] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[96] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?