Forthcoming events in Lowlands
PDOException Object
(
[message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.event_type' in 'where clause'
[string:private] =>
[code:protected] => 42S22
[file:protected] => /home/waterscape/public_html/waterscape/lib/Waterscape/Dao/Event.php
[line:protected] => 428
[trace:private] => Array
(
[0] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Dao/Event.php
[line] => 428
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
[0] => 43
)
)
)
[1] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Dao/Event.php
[line] => 347
[function] => findByCounty
[class] => Waterscape_Dao_Event
[type] => ->
[args] => Array
(
[0] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 39
[_os_country_code:private] => 179
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 352903
[_min_northing:private] => 868189
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 284980
[_centre_northing:private] => 680960
[_name:protected] => Lowlands
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lowlands
[_standfirst:protected] => Golden eagles soar above the land of Braveheart and Mary Queen of Scots.
[_description:protected] => Ancient castles, a turbulent history, and the innovative 21st century [/in-your-area/lowlands/places-to-go/496/the-falkirk-wheel Falkirk Wheel] - welcome to the Scottish Lowlands. Cruise the [/canals-and-rivers/union-canal Union Canal] into the heart of Edinburgh, stroll around the picturesque Loch Lomond or don your walking boots and explore the wild Trossachs.
++Photograph & Art Competition Winners 2008
The results are in! To find the full list of winners click [/features-and-articles/features/scottish-canals-photography-competition-2008 here].
View some [http://www.images-scotland.com images of Scotland]
[_id:protected] => 43
[_url_name] => lowlands
)
[1] =>
[2] => 1
)
)
[2] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Dao/Event.php
[line] => 631
[function] => findByLocation
[class] => Waterscape_Dao_Event
[type] => ->
[args] => Array
(
[0] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 39
[_os_country_code:private] => 179
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 352903
[_min_northing:private] => 868189
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 284980
[_centre_northing:private] => 680960
[_name:protected] => Lowlands
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lowlands
[_standfirst:protected] => Golden eagles soar above the land of Braveheart and Mary Queen of Scots.
[_description:protected] => Ancient castles, a turbulent history, and the innovative 21st century [/in-your-area/lowlands/places-to-go/496/the-falkirk-wheel Falkirk Wheel] - welcome to the Scottish Lowlands. Cruise the [/canals-and-rivers/union-canal Union Canal] into the heart of Edinburgh, stroll around the picturesque Loch Lomond or don your walking boots and explore the wild Trossachs.
++Photograph & Art Competition Winners 2008
The results are in! To find the full list of winners click [/features-and-articles/features/scottish-canals-photography-competition-2008 here].
View some [http://www.images-scotland.com images of Scotland]
[_id:protected] => 43
[_url_name] => lowlands
)
[1] =>
[2] => 1
)
)
[3] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Service/EventManager.php
[line] => 122
[function] => findUpcomingByLocation
[class] => Waterscape_Dao_Event
[type] => ->
[args] => Array
(
[0] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 39
[_os_country_code:private] => 179
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 352903
[_min_northing:private] => 868189
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 284980
[_centre_northing:private] => 680960
[_name:protected] => Lowlands
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lowlands
[_standfirst:protected] => Golden eagles soar above the land of Braveheart and Mary Queen of Scots.
[_description:protected] => Ancient castles, a turbulent history, and the innovative 21st century [/in-your-area/lowlands/places-to-go/496/the-falkirk-wheel Falkirk Wheel] - welcome to the Scottish Lowlands. Cruise the [/canals-and-rivers/union-canal Union Canal] into the heart of Edinburgh, stroll around the picturesque Loch Lomond or don your walking boots and explore the wild Trossachs.
++Photograph & Art Competition Winners 2008
The results are in! To find the full list of winners click [/features-and-articles/features/scottish-canals-photography-competition-2008 here].
View some [http://www.images-scotland.com images of Scotland]
[_id:protected] => 43
[_url_name] => lowlands
)
[1] =>
)
)
[4] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/EventList.php
[line] => 47
[function] => getUpcomingByLocation
[class] => Waterscape_Service_EventManager
[type] => ->
[args] => Array
(
[0] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 39
[_os_country_code:private] => 179
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 352903
[_min_northing:private] => 868189
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 284980
[_centre_northing:private] => 680960
[_name:protected] => Lowlands
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lowlands
[_standfirst:protected] => Golden eagles soar above the land of Braveheart and Mary Queen of Scots.
[_description:protected] => Ancient castles, a turbulent history, and the innovative 21st century [/in-your-area/lowlands/places-to-go/496/the-falkirk-wheel Falkirk Wheel] - welcome to the Scottish Lowlands. Cruise the [/canals-and-rivers/union-canal Union Canal] into the heart of Edinburgh, stroll around the picturesque Loch Lomond or don your walking boots and explore the wild Trossachs.
++Photograph & Art Competition Winners 2008
The results are in! To find the full list of winners click [/features-and-articles/features/scottish-canals-photography-competition-2008 here].
View some [http://www.images-scotland.com images of Scotland]
[_id:protected] => 43
[_url_name] => lowlands
)
)
)
[5] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Component/EventList.php
[line] => 21
[function] => initItems
[class] => Waterscape_Component_EventList
[type] => ->
[args] => Array
(
)
)
[6] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Renderer/Component/HtmlRenderer.php
[line] => 18
[function] => fetch
[class] => Waterscape_Component_EventList
[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_EventList Object
(
[_event_manager:private] => Waterscape_Service_EventManager Object
(
[_event_dao:private] => Waterscape_Dao_Event 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_db:protected] =>
)
[_page_dao:private] => Waterscape_Dao_Page Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_db:protected] =>
)
[_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_db:protected] =>
)
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
)
[_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] =>
)
[_geo_point_mgr:private] =>
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
)
[_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] =>
)
)
)
[_limit:protected] =>
[_title:protected] =>
[_items:protected] =>
[_is_paginated:protected] => 1
[_component_id:protected] => 37
[_parent_id:protected] =>
[_template:protected] => Component/EventList.tpl
[_page_id:protected] => 1855
[_view_component_id:protected] => 299
[_instance_name:protected] => event_list
[_request:protected] => Waterscape_Request Object
(
[_mapping_path:private] => /in-your-area/lowlands/events
[_path:private] => /in-your-area/lowlands/events
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => in-your-area/lowlands/events
[PHPSESSID] => d337fbe420d5825cac5f41ac75c53cdc
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[_response:protected] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 115
[page_id] => 1855
[view_name] => county_events
[title] => Events, festivals & family fun
%LOCATION_PREPOSITION% %LOCATION_NAME% | Canals & Rivers | Waterscape.com
[keywords] =>
[description] =>
[layout_template] => Layouts/twocol_contentright.tpl
[template] => Page/locations/events.tpl
[dynamic] =>
[published] => 0
[command_id] =>
[command_class] => Waterscape_Controller_Locations
[path] => /in-your-area/lowlands/events
[location] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 39
[_os_country_code:private] => 179
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 352903
[_min_northing:private] => 868189
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 284980
[_centre_northing:private] => 680960
[_name:protected] => Lowlands
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lowlands
[_standfirst:protected] => Golden eagles soar above the land of Braveheart and Mary Queen of Scots.
[_description:protected] => Ancient castles, a turbulent history, and the innovative 21st century [/in-your-area/lowlands/places-to-go/496/the-falkirk-wheel Falkirk Wheel] - welcome to the Scottish Lowlands. Cruise the [/canals-and-rivers/union-canal Union Canal] into the heart of Edinburgh, stroll around the picturesque Loch Lomond or don your walking boots and explore the wild Trossachs.
++Photograph & Art Competition Winners 2008
The results are in! To find the full list of winners click [/features-and-articles/features/scottish-canals-photography-competition-2008 here].
View some [http://www.images-scotland.com images of Scotland]
[_id:protected] => 43
[_url_name] => lowlands
)
[preposition] => in
[section] => events
[primary_navigation] => Waterscape_Component_LocationNavigationMenu Object
(
[_location:private] => Waterscape_Model_County Object
(
[_location_type:protected] => 1
[_geo_data_id:private] => 39
[_os_country_code:private] => 179
[_easting:private] =>
[_northing:private] =>
[_min_easting:private] => 352903
[_min_northing:private] => 868189
[_max_easting:private] => 655989
[_max_northing:private] => 976907
[_centre_easting:private] => 284980
[_centre_northing:private] => 680960
[_name:protected] => Lowlands
[_urlname:protected] =>
[_basepath:protected] => /in-your-area/lowlands
[_standfirst:protected] => Golden eagles soar above the land of Braveheart and Mary Queen of Scots.
[_description:protected] => Ancient castles, a turbulent history, and the innovative 21st century [/in-your-area/lowlands/places-to-go/496/the-falkirk-wheel Falkirk Wheel] - welcome to the Scottish Lowlands. Cruise the [/canals-and-rivers/union-canal Union Canal] into the heart of Edinburgh, stroll around the picturesque Loch Lomond or don your walking boots and explore the wild Trossachs.
++Photograph & Art Competition Winners 2008
The results are in! To find the full list of winners click [/features-and-articles/features/scottish-canals-photography-competition-2008 here].
View some [http://www.images-scotland.com images of Scotland]
[_id:protected] => 43
[_url_name] => lowlands
)
[_na_office_manager:private] => Waterscape_Service_NavigationAuthorityOfficeManager Object
(
[_navigation_authority_office_dao:private] => Waterscape_Dao_NavigationAuthorityOffice Object
(
[_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_navigation_authority_dao:private] => Waterscape_Dao_NavigationAuthority Object
(
[_db:protected] =>
)
[_db:protected] =>
)
)
[_stoppage_manager:private] => Waterscape_Service_StoppageManager Object
(
[_stoppage_dao:private] => Waterscape_Dao_Stoppage Object
(
[_waterway_mgr:private] => Waterscape_Service_WaterwayManager Object
(
[_waterway_dao:private] => Waterscape_Dao_Waterway Object
(
[_db:protected] =>
)
)
[_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] =>
)
)
)
)
[_town_manager:private] => Waterscape_Service_TownManager Object
(
[_town_dao:private] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] => 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
)
[_business_manager:private] => Waterscape_Service_BusinessManager Object
(
[_business_dao:private] => Waterscape_Dao_Business Object
(
[_address_manager:protected] => Waterscape_Service_StreetAddressManager Object
(
[_street_address_dao:private] => Waterscape_Dao_StreetAddress Object
(
[_db:protected] =>
[_town_dao] => Waterscape_Dao_Town Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_geo_point_mgr:private] =>
[_db:protected] =>
)
[_county_dao] => Waterscape_Dao_County Object
(
[_db:protected] =>
)
[_country_dao] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
)
[_metadata_manager:protected] => Waterscape_Service_MetadataManager Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] =>
)
)
[_attribute_manager:protected] => Waterscape_Service_AttributeManager Object
(
[_attribute_dao:private] => Waterscape_Dao_Attribute Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_category_manager:protected] => Waterscape_Service_CategoryManager Object
(
[_category_dao:private] => Waterscape_Dao_Category Object
(
[_section_manager:private] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_db:protected] =>
)
)
[_section_manager:protected] => Waterscape_Service_SectionManager Object
(
[_section_dao:private] => Waterscape_Dao_Section Object
(
[_db:protected] =>
)
)
[_location_manager:protected] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
)
[_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] =>
)
[_geo_point_mgr:private] =>
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
)
[_postcode_manager:private] => Waterscape_Service_PostcodeManager Object
(
[_postcode_dao:private] => Waterscape_Dao_Postcode Object
(
[_db:protected] =>
)
)
[_postcode_district_manager:private] => Waterscape_Service_PostcodeDistrictManager Object
(
[_postcode_district_dao:private] => Waterscape_Dao_PostcodeDistrict Object
(
[_db:protected] =>
)
)
)
[_media_manager:protected] => Waterscape_Service_MediaManager Object
(
[_media_dao:private] => Waterscape_Dao_Media Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_db:protected] =>
)
)
)
[_db:protected] =>
)
)
[_menu_id:protected] =>
[_menu_items:protected] =>
[_display_class:protected] =>
[_html_class:protected] =>
[_html_id:protected] =>
[_menu_components:protected] =>
[_page_manager:protected] => Waterscape_Service_PageManager Object
(
[_page_dao:private] => Waterscape_Dao_Page Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[4] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
[_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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[39] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[40] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[42] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[46] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[47] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[49] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[50] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[52] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[53] => Array
(
[sql] => SELECT town_id FROM town WHERE urlname = ?
)
[54] => Array
(
[sql] => SELECT county_id FROM county WHERE urlname = ?
)
[55] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[56] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN address a ON e.address = a.address_id INNER JOIN content_page p ON p.page_id = e.page_id WHERE a.county = ? AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() OR e.event_type = 2 AND p.is_published = 1 AND e.end_date >= curdate() and e.start_date >= curdate() ORDER BY e.start_date ASC
)
)
[queryCounter] => 57
)
)
)
)
[_location_manager:protected] => Waterscape_Service_LocationManager Object
(
[_country_manager:private] => Waterscape_Service_CountryManager Object
(
[_country_dao:private] => Waterscape_Dao_Country Object
(
[_db:protected] =>
)
)
[_county_manager:private] => Waterscape_Service_CountyManager Object
(
[_county_dao:private] => Waterscape_Dao_County Object
(
[_db:protected] => 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 county_id FROM county WHERE urlname = ?
)
[5] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[8] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[14] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[15] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[17] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[18] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[19] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[20] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[21] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[22] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[23] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[26] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[27] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[29] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[30] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[31] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[36] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[38] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?