Holidays near Birmingham
Discover the joys of a slower pace of life with a relaxing holiday by the water.
Book a boat, a cosy canalside cottage or a luxury hotel.
PDOException Object
(
[message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'i.nationwide' in 'where clause'
[string:private] =>
[code:protected] => 42S22
[file:protected] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line:protected] => 53
[trace:private] => Array
(
[0] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 53
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Database/RecordSet/Paged.php
[line] => 16
[function] => getUnlimitedQueryRowCount
[class] => Waterscape_Database_RecordSet_Paged
[type] => ->
[args] => Array
(
[0] => SELECT i.id, i.id AS service_id, i.name, i.phone, i.email_address, m.easting, m.northing, i.web_address, i.description, i.editorial_review, a.line_1, a.line_2, a.line_3, a.locality, a.town AS town, a.postcode, a.county AS county, sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) AS distance FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-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(405756-m.easting,2)+pow(285434-m.northing,2)) AS distance FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-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(405756-m.easting,2)+pow(285434-m.northing,2)) AS distance FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
[1] => 1
[2] => 9
)
)
[4] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 133
[function] => find
[class] => Waterscape_Directory_Finder_Abstract
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 3
[_name:protected] => Holidays
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 405756
[y] => 285434
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20743
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 31
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 387697
[_min_northing:private] => 297693
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 426980
[_centre_northing:private] => 266040
[_name:protected] => Warwickshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire
[_standfirst:protected] => Home of the Bard, Warwickshire is also renowned for its numerous waterways and scenic cruising.
[_description:protected] => [/in-your-area/warwickshire/birmingham Birmingham] is commonly known as the canal capital of the UK, but the waterway interest doesn’t finish at the city limits. Some of Britain’s most interesting rivers and canals wind through rural Warwickshire – and there’s a multitude of attractions and events to keep you occupied on dry land too.
[_id:protected] => 23
[_url_name] => warwickshire
)
[_easting:protected] => 405756
[_northing:protected] => 285434
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Birmingham
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire/birmingham
[_standfirst:protected] => Britain’s canal capital
[_description:protected] => Birmingham’s canals add green space and vibrancy to Britain’s second city. Take to the towpaths and enjoy a gloriously traffic-free journey to work - or find your own green shortcut through the centre and beat the crowds to the bars of [/in-your-area/warwickshire/places-to-go/649/brindleyplace Brindleyplace]. Follow our scenic canals to discover the best of Birmingham.
**Walking to work in Birmingham**
The [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] carves a green corridor past the university and the leafy streets of Edgbaston to the offices and shops near Broad Street. Why not swap the queuing traffic on the Bristol Road for a scenic stroll to work along the canal? Or get off the bus early and take to the towpath for your government recommended 20 minutes of exercise with a power-walk to the office. Handy canalside cafes can even provide that essential morning coffee en-route.
Commuting? Sidestep the suited throngs and enjoy a waterside walk from New Street Station: the [/canals-and-rivers/birmingham-and-fazeley-canal Birmingham & Fazeley Canal] is a peaceful pathway to St Paul’s Square and the ICC. And remember, the best thing about towpath walking is that you’ll never take the wrong turning.
**Canalside eating, drinking and shopping**
Birmingham is a fantastic place to shop – and to recuperate in a friendly bar afterwards. But if the crowds of Corporation Street get too much to bear, remember that the Midlands’ answer to Bond Street, the [/in-your-area/warwickshire/places-to-go/298/mailbox Mailbox], is just a short stroll along the Worcester & Birmingham Canal. Looking for something special? The famous Jewellery Quarter has produced beautiful rings, gems and trinkets on the banks of the Birmingham & Fazeley Canal for over 200 years.
And after all that shopping you’ll need a bite to eat. Between Brindleyplace, [/in-your-area/warwickshire/places-to-go/185/gas-street-basin Gas Street Basin] and Broad Street, Birmingham boasts countless canalside pubs, bars, cafes and restaurants where you can enjoy a quick snack, an after-work drink or a romantic dinner a deux. Find out more with our [http://www.waterscape.com/eatingdrinking/ eating and drinking pages].
**Days out by the canal**
Calling all chocoholics. The famous [/in-your-area/warwickshire/places-to-go/85/cadbury-world Cadbury World] offers a great (and tasty) day out for all the family – and any calories accidentally imbibed on the tour can be worked off with a walk along the Worcester & Birmingham Canal afterwards. Elsewhere, the [/in-your-area/warwickshire/places-to-go/336/national-sea-life-centre National Sea Life Centre] is enduringly popular in the heart of Brindleyplace and with galleries, historic houses, theatres and canal architecture all just a short drive away – you’re sure to find an outing to suit in waterside Birmingham.
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[_id:protected] => 2
[_url_name] => birmingham
)
[_range:private] =>
[_directory_type:private] => 1
[_page_number:private] => 1
[_page_limit:private] => 9
)
)
)
[5] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/DirectoryListingPage.php
[line] => 48
[function] => initItems
[class] => Waterscape_Component_DirectoryListingPage
[type] => ->
[args] => Array
(
[0] => Waterscape_Directory_Context_Request Object
(
[_descriptors:private] => Array
(
[0] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 3
[_name:protected] => Holidays
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 405756
[y] => 285434
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20743
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 31
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 387697
[_min_northing:private] => 297693
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 426980
[_centre_northing:private] => 266040
[_name:protected] => Warwickshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire
[_standfirst:protected] => Home of the Bard, Warwickshire is also renowned for its numerous waterways and scenic cruising.
[_description:protected] => [/in-your-area/warwickshire/birmingham Birmingham] is commonly known as the canal capital of the UK, but the waterway interest doesn’t finish at the city limits. Some of Britain’s most interesting rivers and canals wind through rural Warwickshire – and there’s a multitude of attractions and events to keep you occupied on dry land too.
[_id:protected] => 23
[_url_name] => warwickshire
)
[_easting:protected] => 405756
[_northing:protected] => 285434
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Birmingham
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire/birmingham
[_standfirst:protected] => Britain’s canal capital
[_description:protected] => Birmingham’s canals add green space and vibrancy to Britain’s second city. Take to the towpaths and enjoy a gloriously traffic-free journey to work - or find your own green shortcut through the centre and beat the crowds to the bars of [/in-your-area/warwickshire/places-to-go/649/brindleyplace Brindleyplace]. Follow our scenic canals to discover the best of Birmingham.
**Walking to work in Birmingham**
The [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] carves a green corridor past the university and the leafy streets of Edgbaston to the offices and shops near Broad Street. Why not swap the queuing traffic on the Bristol Road for a scenic stroll to work along the canal? Or get off the bus early and take to the towpath for your government recommended 20 minutes of exercise with a power-walk to the office. Handy canalside cafes can even provide that essential morning coffee en-route.
Commuting? Sidestep the suited throngs and enjoy a waterside walk from New Street Station: the [/canals-and-rivers/birmingham-and-fazeley-canal Birmingham & Fazeley Canal] is a peaceful pathway to St Paul’s Square and the ICC. And remember, the best thing about towpath walking is that you’ll never take the wrong turning.
**Canalside eating, drinking and shopping**
Birmingham is a fantastic place to shop – and to recuperate in a friendly bar afterwards. But if the crowds of Corporation Street get too much to bear, remember that the Midlands’ answer to Bond Street, the [/in-your-area/warwickshire/places-to-go/298/mailbox Mailbox], is just a short stroll along the Worcester & Birmingham Canal. Looking for something special? The famous Jewellery Quarter has produced beautiful rings, gems and trinkets on the banks of the Birmingham & Fazeley Canal for over 200 years.
And after all that shopping you’ll need a bite to eat. Between Brindleyplace, [/in-your-area/warwickshire/places-to-go/185/gas-street-basin Gas Street Basin] and Broad Street, Birmingham boasts countless canalside pubs, bars, cafes and restaurants where you can enjoy a quick snack, an after-work drink or a romantic dinner a deux. Find out more with our [http://www.waterscape.com/eatingdrinking/ eating and drinking pages].
**Days out by the canal**
Calling all chocoholics. The famous [/in-your-area/warwickshire/places-to-go/85/cadbury-world Cadbury World] offers a great (and tasty) day out for all the family – and any calories accidentally imbibed on the tour can be worked off with a walk along the Worcester & Birmingham Canal afterwards. Elsewhere, the [/in-your-area/warwickshire/places-to-go/336/national-sea-life-centre National Sea Life Centre] is enduringly popular in the heart of Brindleyplace and with galleries, historic houses, theatres and canal architecture all just a short drive away – you’re sure to find an outing to suit in waterside Birmingham.
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[_id:protected] => 2
[_url_name] => birmingham
)
[_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] => 405756
[y] => 285434
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20743
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 31
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 387697
[_min_northing:private] => 297693
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 426980
[_centre_northing:private] => 266040
[_name:protected] => Warwickshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire
[_standfirst:protected] => Home of the Bard, Warwickshire is also renowned for its numerous waterways and scenic cruising.
[_description:protected] => [/in-your-area/warwickshire/birmingham Birmingham] is commonly known as the canal capital of the UK, but the waterway interest doesn’t finish at the city limits. Some of Britain’s most interesting rivers and canals wind through rural Warwickshire – and there’s a multitude of attractions and events to keep you occupied on dry land too.
[_id:protected] => 23
[_url_name] => warwickshire
)
[_easting:protected] => 405756
[_northing:protected] => 285434
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Birmingham
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire/birmingham
[_standfirst:protected] => Britain’s canal capital
[_description:protected] => Birmingham’s canals add green space and vibrancy to Britain’s second city. Take to the towpaths and enjoy a gloriously traffic-free journey to work - or find your own green shortcut through the centre and beat the crowds to the bars of [/in-your-area/warwickshire/places-to-go/649/brindleyplace Brindleyplace]. Follow our scenic canals to discover the best of Birmingham.
**Walking to work in Birmingham**
The [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] carves a green corridor past the university and the leafy streets of Edgbaston to the offices and shops near Broad Street. Why not swap the queuing traffic on the Bristol Road for a scenic stroll to work along the canal? Or get off the bus early and take to the towpath for your government recommended 20 minutes of exercise with a power-walk to the office. Handy canalside cafes can even provide that essential morning coffee en-route.
Commuting? Sidestep the suited throngs and enjoy a waterside walk from New Street Station: the [/canals-and-rivers/birmingham-and-fazeley-canal Birmingham & Fazeley Canal] is a peaceful pathway to St Paul’s Square and the ICC. And remember, the best thing about towpath walking is that you’ll never take the wrong turning.
**Canalside eating, drinking and shopping**
Birmingham is a fantastic place to shop – and to recuperate in a friendly bar afterwards. But if the crowds of Corporation Street get too much to bear, remember that the Midlands’ answer to Bond Street, the [/in-your-area/warwickshire/places-to-go/298/mailbox Mailbox], is just a short stroll along the Worcester & Birmingham Canal. Looking for something special? The famous Jewellery Quarter has produced beautiful rings, gems and trinkets on the banks of the Birmingham & Fazeley Canal for over 200 years.
And after all that shopping you’ll need a bite to eat. Between Brindleyplace, [/in-your-area/warwickshire/places-to-go/185/gas-street-basin Gas Street Basin] and Broad Street, Birmingham boasts countless canalside pubs, bars, cafes and restaurants where you can enjoy a quick snack, an after-work drink or a romantic dinner a deux. Find out more with our [http://www.waterscape.com/eatingdrinking/ eating and drinking pages].
**Days out by the canal**
Calling all chocoholics. The famous [/in-your-area/warwickshire/places-to-go/85/cadbury-world Cadbury World] offers a great (and tasty) day out for all the family – and any calories accidentally imbibed on the tour can be worked off with a walk along the Worcester & Birmingham Canal afterwards. Elsewhere, the [/in-your-area/warwickshire/places-to-go/336/national-sea-life-centre National Sea Life Centre] is enduringly popular in the heart of Brindleyplace and with galleries, historic houses, theatres and canal architecture all just a short drive away – you’re sure to find an outing to suit in waterside Birmingham.
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[_id:protected] => 2
[_url_name] => birmingham
)
[_preposition:private] => near
[_descriptor:private] => Waterscape_Directory_Descriptor_Section Object
(
[_is_container:private] =>
[_parent:private] =>
[_id:protected] => 3
[_name:protected] => Holidays
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_business_manager:private] =>
[_location_manager:private] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_geo_point_mgr:private] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_town_manager:private] =>
[_limit:protected] =>
[_title:protected] =>
[_items:protected] =>
[_is_paginated:protected] => 1
[_component_id:protected] => 14
[_parent_id:protected] =>
[_template:protected] => Component/ListingPage.tpl
[_page_id:protected] => 1907
[_view_component_id:protected] => 86
[_instance_name:protected] => directory_page
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/warwickshire/birmingham/holidays
[_path:private] => /in-your-area/warwickshire/birmingham/holidays
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/warwickshire/birmingham/holidays
[PHPSESSID] => f556713ca4050b2dba91590d7c8bbfb0
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 20
[page_id] => 1907
[view_name] => locations_holidays
[title] => Canal Holidays %LOCATION_PREPOSITION% %LOCATION_NAME% %LOCATION_COUNTY_NAME% | Cottages and Hotels %LOCATION_PREPOSITION% %LOCATION_NAME% | Canals and Rivers
[keywords] =>
[description] =>
[layout_template] => Page/locations/location.tpl
[template] => Page/locations/holidays.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Locations
[path] => /in-your-area/warwickshire/birmingham/holidays
[location] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 405756
[y] => 285434
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20743
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 31
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 387697
[_min_northing:private] => 297693
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 426980
[_centre_northing:private] => 266040
[_name:protected] => Warwickshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire
[_standfirst:protected] => Home of the Bard, Warwickshire is also renowned for its numerous waterways and scenic cruising.
[_description:protected] => [/in-your-area/warwickshire/birmingham Birmingham] is commonly known as the canal capital of the UK, but the waterway interest doesn’t finish at the city limits. Some of Britain’s most interesting rivers and canals wind through rural Warwickshire – and there’s a multitude of attractions and events to keep you occupied on dry land too.
[_id:protected] => 23
[_url_name] => warwickshire
)
[_easting:protected] => 405756
[_northing:protected] => 285434
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Birmingham
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire/birmingham
[_standfirst:protected] => Britain’s canal capital
[_description:protected] => Birmingham’s canals add green space and vibrancy to Britain’s second city. Take to the towpaths and enjoy a gloriously traffic-free journey to work - or find your own green shortcut through the centre and beat the crowds to the bars of [/in-your-area/warwickshire/places-to-go/649/brindleyplace Brindleyplace]. Follow our scenic canals to discover the best of Birmingham.
**Walking to work in Birmingham**
The [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] carves a green corridor past the university and the leafy streets of Edgbaston to the offices and shops near Broad Street. Why not swap the queuing traffic on the Bristol Road for a scenic stroll to work along the canal? Or get off the bus early and take to the towpath for your government recommended 20 minutes of exercise with a power-walk to the office. Handy canalside cafes can even provide that essential morning coffee en-route.
Commuting? Sidestep the suited throngs and enjoy a waterside walk from New Street Station: the [/canals-and-rivers/birmingham-and-fazeley-canal Birmingham & Fazeley Canal] is a peaceful pathway to St Paul’s Square and the ICC. And remember, the best thing about towpath walking is that you’ll never take the wrong turning.
**Canalside eating, drinking and shopping**
Birmingham is a fantastic place to shop – and to recuperate in a friendly bar afterwards. But if the crowds of Corporation Street get too much to bear, remember that the Midlands’ answer to Bond Street, the [/in-your-area/warwickshire/places-to-go/298/mailbox Mailbox], is just a short stroll along the Worcester & Birmingham Canal. Looking for something special? The famous Jewellery Quarter has produced beautiful rings, gems and trinkets on the banks of the Birmingham & Fazeley Canal for over 200 years.
And after all that shopping you’ll need a bite to eat. Between Brindleyplace, [/in-your-area/warwickshire/places-to-go/185/gas-street-basin Gas Street Basin] and Broad Street, Birmingham boasts countless canalside pubs, bars, cafes and restaurants where you can enjoy a quick snack, an after-work drink or a romantic dinner a deux. Find out more with our [http://www.waterscape.com/eatingdrinking/ eating and drinking pages].
**Days out by the canal**
Calling all chocoholics. The famous [/in-your-area/warwickshire/places-to-go/85/cadbury-world Cadbury World] offers a great (and tasty) day out for all the family – and any calories accidentally imbibed on the tour can be worked off with a walk along the Worcester & Birmingham Canal afterwards. Elsewhere, the [/in-your-area/warwickshire/places-to-go/336/national-sea-life-centre National Sea Life Centre] is enduringly popular in the heart of Brindleyplace and with galleries, historic houses, theatres and canal architecture all just a short drive away – you’re sure to find an outing to suit in waterside Birmingham.
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[_id:protected] => 2
[_url_name] => birmingham
)
[preposition] => near
[section] => holidays
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_Town Object
(
[_geo_point:protected] => Waterscape_Model_GeoPoint Object
(
[_data_type:protected] => 22
[_coordinates:protected] => Array
(
[0] => Array
(
[x] => 405756
[y] => 285434
)
)
[_coordinates_size:protected] =>
[_id:protected] => 20743
)
[_class:protected] => 10
[_county:protected] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 31
[_os_country_code:private] => 064
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 387697
[_min_northing:private] => 297693
[_max_easting:private] => 655989
[_max_northing:private] => 657599
[_centre_easting:private] => 426980
[_centre_northing:private] => 266040
[_name:protected] => Warwickshire
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire
[_standfirst:protected] => Home of the Bard, Warwickshire is also renowned for its numerous waterways and scenic cruising.
[_description:protected] => [/in-your-area/warwickshire/birmingham Birmingham] is commonly known as the canal capital of the UK, but the waterway interest doesn’t finish at the city limits. Some of Britain’s most interesting rivers and canals wind through rural Warwickshire – and there’s a multitude of attractions and events to keep you occupied on dry land too.
[_id:protected] => 23
[_url_name] => warwickshire
)
[_easting:protected] => 405756
[_northing:protected] => 285434
[_reference_name:protected] =>
[_location_type:protected] => 2
[_name:protected] => Birmingham
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/warwickshire/birmingham
[_standfirst:protected] => Britain’s canal capital
[_description:protected] => Birmingham’s canals add green space and vibrancy to Britain’s second city. Take to the towpaths and enjoy a gloriously traffic-free journey to work - or find your own green shortcut through the centre and beat the crowds to the bars of [/in-your-area/warwickshire/places-to-go/649/brindleyplace Brindleyplace]. Follow our scenic canals to discover the best of Birmingham.
**Walking to work in Birmingham**
The [/canals-and-rivers/worcester-and-birmingham-canal Worcester & Birmingham Canal] carves a green corridor past the university and the leafy streets of Edgbaston to the offices and shops near Broad Street. Why not swap the queuing traffic on the Bristol Road for a scenic stroll to work along the canal? Or get off the bus early and take to the towpath for your government recommended 20 minutes of exercise with a power-walk to the office. Handy canalside cafes can even provide that essential morning coffee en-route.
Commuting? Sidestep the suited throngs and enjoy a waterside walk from New Street Station: the [/canals-and-rivers/birmingham-and-fazeley-canal Birmingham & Fazeley Canal] is a peaceful pathway to St Paul’s Square and the ICC. And remember, the best thing about towpath walking is that you’ll never take the wrong turning.
**Canalside eating, drinking and shopping**
Birmingham is a fantastic place to shop – and to recuperate in a friendly bar afterwards. But if the crowds of Corporation Street get too much to bear, remember that the Midlands’ answer to Bond Street, the [/in-your-area/warwickshire/places-to-go/298/mailbox Mailbox], is just a short stroll along the Worcester & Birmingham Canal. Looking for something special? The famous Jewellery Quarter has produced beautiful rings, gems and trinkets on the banks of the Birmingham & Fazeley Canal for over 200 years.
And after all that shopping you’ll need a bite to eat. Between Brindleyplace, [/in-your-area/warwickshire/places-to-go/185/gas-street-basin Gas Street Basin] and Broad Street, Birmingham boasts countless canalside pubs, bars, cafes and restaurants where you can enjoy a quick snack, an after-work drink or a romantic dinner a deux. Find out more with our [http://www.waterscape.com/eatingdrinking/ eating and drinking pages].
**Days out by the canal**
Calling all chocoholics. The famous [/in-your-area/warwickshire/places-to-go/85/cadbury-world Cadbury World] offers a great (and tasty) day out for all the family – and any calories accidentally imbibed on the tour can be worked off with a walk along the Worcester & Birmingham Canal afterwards. Elsewhere, the [/in-your-area/warwickshire/places-to-go/336/national-sea-life-centre National Sea Life Centre] is enduringly popular in the heart of Brindleyplace and with galleries, historic houses, theatres and canal architecture all just a short drive away – you’re sure to find an outing to suit in waterside Birmingham.
[/media/documents/20798.pdf Download a Guide and map to Birmingham and the West Midlands’ Canals]
[_id:protected] => 2
[_url_name] => birmingham
)
[_na_office_manager:private] => Waterscape_Service_NavigationAuthorityOfficeManager Object
(
[_navigation_authority_office_dao:private] => Waterscape_Dao_NavigationAuthorityOffice Object
(
[_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_navigation_authority_dao:private] => Waterscape_Dao_NavigationAuthority Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
[_stoppage_manager:private] => Waterscape_Service_StoppageManager Object
(
[_stoppage_dao:private] => Waterscape_Dao_Stoppage Object
(
[_waterway_mgr:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_navigation_authority_region_mgr:private] => Waterscape_Service_NavigationAuthorityRegionManager Object
(
[_navigation_authority_region_dao:private] => Waterscape_Dao_NavigationAuthorityRegion Object
(
[_db:protected] =>
)
)
[_stoppage_type_mgr:private] => Waterscape_Service_StoppageTypeManager Object
(
[_stoppage_type_dao:private] => Waterscape_Dao_StoppageType Object
(
[_db:protected] =>
)
)
[_stoppage_business_description_mgr:private] => Waterscape_Service_StoppageBusinessDescriptionManager Object
(
[_stoppage_business_description_dao:private] => Waterscape_Dao_StoppageBusinessDescription Object
(
[_db:protected] =>
)
)
[_criteria:private] => Array
(
)
[_raw_criteria:private] =>
[_sql_strings:private] => Array
(
)
[_sql_values:private] => Array
(
)
[_search_data_by:private] => Array
(
[all] => 0
[stoppage] => s
[restriction] => r
[opening_times] => o
[booking_details] => b
[advice] => a
[towpath_closure_only] => t
)
[_str_types_selected:private] =>
[_stoppage_type:private] =>
[_db:protected] =>
)
)
[_route_manager:private] => Waterscape_Service_RouteManager Object
(
[_route_dao:private] => Waterscape_Dao_Route Object
(
[_route_type_manager:private] => Waterscape_Service_RouteTypeManager Object
(
[_route_type_dao:private] => Waterscape_Dao_RouteType Object
(
[_db:protected] =>
)
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_waypoint_manager:private] => Waterscape_Service_WaypointManager Object
(
[_waypoint_dao:private] => Waterscape_Dao_Waypoint Object
(
[_metadata_mgr:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_geo_point_mgr:private] =>
[_geo_data_type_manager:private] => Waterscape_Service_GeoDataTypeManager Object
(
[_geo_data_dao:private] => Waterscape_Dao_GeoDataType Object
(
[_db:protected] =>
)
)
[_db:protected] =>
[_geo_point_manager] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_geo_point_mgr:private] => Waterscape_Service_GeoPointManager Object
(
[_geo_point_dao:private] => Waterscape_Dao_GeoPoint Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
)
[_media_manager:private] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_mediatype_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_media_type_manager:private] => Waterscape_Service_MediaTypeManager Object
(
[_media_type_dao:private] => Waterscape_Dao_MediaType Object
(
[_media_class_dao:private] => Waterscape_Dao_MediaClass Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[17] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[22] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[24] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[28] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[34] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[40] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[42] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[54] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[55] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[60] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[63] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[65] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[67] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[68] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[69] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[70] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[71] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[72] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[75] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[76] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[78] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[80] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[82] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[83] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[84] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[85] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[86] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[87] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[88] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[89] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[91] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[92] => Array
(
[sql] => SELECT category_id, name FROM category where name = ?
)
[93] => Array
(
[sql] => SELECT attribute_id, name FROM attribute where name = ?
)
[94] => Array
(
[sql] => SELECT section_id FROM section WHERE name = ?
)
[95] => Array
(
[sql] => SELECT section_id, name, container, parent FROM section where section_id = ?
)
[96] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[97] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[99] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[100] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[101] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[102] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[103] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[104] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[105] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[106] => Array
(
[sql] => SELECT count(*) AS row_count FROM service_provider i INNER JOIN address a ON a.address_id = i.address LEFT JOIN metadata m on i.metadata_id = m.metadata_id WHERE 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) <= 16000 OR 1=1 AND i.id IN (SELECT item_id FROM service_provider_category WHERE category_id IN (SELECT category_id FROM category_section WHERE section_id = 3) UNION SELECT item_id FROM service_provider_attribute WHERE attribute_id IN (SELECT attribute_id FROM attribute_section WHERE section_id = 3)) AND i.nationwide = 1 ORDER BY sqrt(pow(405756-m.easting,2)+pow(285434-m.northing,2)) ASC
)
)
[queryCounter] => 107
)
)
[_db:protected] =>
)
)
)
[_rating_manager:private] => Waterscape_Service_RouteRatingManager Object
(
[_route_rating_dao:private] => Waterscape_Dao_RouteRating Object
(
[_db:protected] =>
)
)
[_metadata_manager:private] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
[_waterway_manager:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
)
[_view_manager:private] => Waterscape_Service_ViewManager Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[7] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[8] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[9] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ? AND county_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[12] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content