Exception Object
(
[message:protected] => Element with key 'kids_and_teachers' does not exist in hashtable
[string:private] =>
[code:protected] => 0
[file:protected] => /home/waterscape/public_html/waterscape/lib/Waterscape/Util/Hashtable.php
[line:protected] => 85
[trace:private] => Array
(
[0] => Array
(
[file] => /home/waterscape/public_html/waterscape/lib/Waterscape/Smarty.php
[line] => 254
[function] => get
[class] => Waterscape_Util_Hashtable
[type] => ->
[args] => Array
(
[0] => kids_and_teachers
)
)
[1] => Array
(
[file] => /home/waterscape/public_html/waterscape/var/smarty/templates_c/%%90^90F^90FF85F0%%NavigationMenu.tpl.php
[line] => 68
[function] => smartyFunctionComponent
[class] => Waterscape_Smarty
[type] => ->
[args] => Array
(
[0] => Array
(
[name] => kids_and_teachers
)
[1] => Waterscape_Smarty Object
(
[_is_for_print:private] =>
[_is_text_only:private] =>
[template_dir] => /home/waterscape/public_html/waterscape/var/smarty/templates/
[compile_dir] => /home/waterscape/public_html/waterscape/var/smarty/templates_c/
[config_dir] => /home/waterscape/public_html/waterscape/var/smarty/configs/
[plugins_dir] => Array
(
[0] => plugins
)
[debugging] =>
[error_reporting] =>
[debug_tpl] =>
[debugging_ctrl] => NONE
[compile_check] => 1
[force_compile] =>
[caching] => 0
[cache_dir] => /home/waterscape/public_html/waterscape/var/smarty/cache/
[cache_lifetime] => 3600
[cache_modified_check] =>
[php_handling] => 0
[security] =>
[secure_dir] => Array
(
)
[security_settings] => Array
(
[PHP_HANDLING] =>
[IF_FUNCS] => Array
(
[0] => array
[1] => list
[2] => isset
[3] => empty
[4] => count
[5] => sizeof
[6] => in_array
[7] => is_array
[8] => true
[9] => false
[10] => null
)
[INCLUDE_ANY] =>
[PHP_TAGS] =>
[MODIFIER_FUNCS] => Array
(
[0] => count
)
[ALLOW_CONSTANTS] =>
)
[trusted_dir] => Array
(
)
[left_delimiter] => {
[right_delimiter] => }
[request_vars_order] => EGPCS
[request_use_auto_globals] => 1
[compile_id] =>
[use_sub_dirs] =>
[default_modifiers] => Array
(
)
[default_resource_type] => file
[cache_handler_func] =>
[autoload_filters] => Array
(
)
[config_overwrite] => 1
[config_booleanize] => 1
[config_read_hidden] =>
[config_fix_newlines] => 1
[default_template_handler_func] =>
[compiler_file] => Smarty_Compiler.class.php
[compiler_class] => Smarty_Compiler
[config_class] => Config_File
[_tpl_vars] => Array
(
[page_title] => Places to Go | Discover local attractions along Britain's Canals, Rivers and Lakes
[page_description] => Places to Go - Discover attractions and places to go along Britain's canals, rivers and lakes. Find local attractions and ideas for great days out from Waterscape.com
[page_keywords] => places to go, discover attractions, great days out, local attractions, search places to go, UK Canals, River, boating, waterscape.com
[page_metadata] => Waterscape_Model_Metadata Object
(
[_title:private] =>
[_description:private] =>
[_keywords:private] =>
[_alt_text:private] =>
[_author:private] =>
[_language:private] => en-GB
[_source:private] =>
[_relation:private] =>
[_format:private] =>
[_identifier:private] =>
[_publisher:private] =>
[_coverage:private] =>
[_rights:private] =>
[_contributor:private] =>
[_easting:private] => 0
[_northing:private] => 0
[_created:private] => 2007-10-12 02:00:56
[_updated:private] => 2008-10-22 03:30:11
[_indexed:private] => 2010-03-18T03:30:25+00:00
[_geo_data_id:private] =>
[_geo_data_type:private] => point
[_id:protected] => 43561
)
[response] => Waterscape_Response Object
(
[_store:private] => Array
(
[view_id] => 67
[page_id] => 726160
[view_name] => activities_section_homepage
[title] => %SECTION_NAME% | Activities | Waterscape.com
[keywords] =>
[description] =>
[layout_template] => Layouts/twocol_contentright.tpl
[template] => Page/activities/activity_section.tpl
[dynamic] =>
[published] => 1
[command_id] =>
[command_class] => Waterscape_Controller_Activities
[path] => /things-to-do/places-to-go
[menu_components] => Array
(
[0] => latest_news
[1] => latest_events
[2] => kids_and_teachers
)
[PLACEHOLDER_SECTION_NAME] => Places to go
)
[_count:private] => 15
)
[request] => Waterscape_Request Object
(
[_mapping_path:private] => /things-to-do/places-to-go
[_path:private] => /things-to-do/places-to-go
[_get:private] => Array
(
[safe] => Array
(
)
[raw] => Array
(
)
)
[_store:private] => Array
(
[frontcontroller_request_path] => things-to-do/places-to-go
[PHPSESSID] => e1b2c50243761de1852fef0a0a141b0a
[query_string] =>
)
[_count:private] => 1
[_post] => Array
(
)
)
[components] => Waterscape_Util_Hashtable Object
(
[_store:private] => Array
(
[title_header_image] => Waterscape_Component_ActivityHeaderImage Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[55] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[65] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[67] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[69] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[70] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[75] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[80] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[82] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[83] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[84] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[85] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[88] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[91] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[93] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[94] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[103] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[104] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[106] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[108] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[109] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[110] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[111] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[112] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[113] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[116] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[117] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[118] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[119] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[121] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[122] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[123] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[124] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[125] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[126] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[130] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[131] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[133] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[134] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[136] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[137] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[138] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[139] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[140] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[142] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[143] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[144] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[145] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[146] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[148] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[150] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[151] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[152] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[153] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[154] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[155] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[156] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[157] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[158] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[159] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[160] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[161] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[162] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[163] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[164] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[165] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[166] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[167] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[168] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[169] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[170] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[171] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[172] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[173] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[174] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[175] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[176] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[177] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[178] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[179] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[180] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[181] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[182] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[183] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[184] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[185] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[186] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[187] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[188] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[189] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[190] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[191] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[192] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[193] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[194] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[195] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[196] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[197] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[198] => Array
(
[sql] => SELECT news_id FROM news n INNER JOIN content_page p ON p.page_id = n.page_id INNER JOIN metadata m ON m.metadata_id = p.metadata_id WHERE headline != "" AND p.is_published = 1 ORDER BY m.created DESC LIMIT 3
)
[199] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[200] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[201] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[202] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[203] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[204] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[205] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[206] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[207] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[208] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[209] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[210] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[211] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[212] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[213] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[214] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[215] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[216] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[217] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[218] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[219] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[220] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[221] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[222] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[223] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[224] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[225] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[226] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[227] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[228] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN content_page p ON e.page_id = p.page_id INNER JOIN metadata m on p.metadata_id = m.metadata_id WHERE m.created <= NOW() AND e.newsletter_feature = 1 AND (unix_timestamp(e.start_date) >= unix_timestamp(curdate())) AND (unix_timestamp(e.end_date) >= unix_timestamp(curdate())) AND p.is_published = 1 ORDER BY e.start_date ASC LIMIT 3
)
[229] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[230] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[231] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[232] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[233] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[234] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[235] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[236] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[237] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[238] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[239] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[240] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[241] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[242] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[243] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[244] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[245] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[246] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[247] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[248] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[249] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[250] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[251] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[252] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[253] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[254] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[255] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[256] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[257] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[258] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[259] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[260] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[261] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[262] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[263] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[264] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[265] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[266] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[267] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[268] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[269] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[270] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[271] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[272] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[273] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[274] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
)
[queryCounter] => 275
)
[_page_manager:protected] => Waterscape_Service_PageManager Object
(
[_page_dao:private] => Waterscape_Dao_Page Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[55] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[65] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[67] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[69] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[70] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[75] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[80] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[82] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[83] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[84] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[85] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[88] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[91] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[93] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[94] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[103] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[104] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[106] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[108] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[109] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[110] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[111] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[112] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[113] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[116] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[117] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[118] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[119] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[121] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[122] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[123] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[124] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[125] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[126] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[130] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[131] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[133] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[134] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[136] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[137] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[138] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[139] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[140] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[142] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[143] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[144] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[145] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[146] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[148] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[150] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[151] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[152] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[153] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[154] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[155] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[156] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[157] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[158] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[159] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[160] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[161] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[162] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[163] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[164] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[165] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[166] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[167] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[168] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[169] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[170] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[171] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[172] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[173] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[174] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[175] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[176] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[177] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[178] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[179] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[180] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[181] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[182] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[183] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[184] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[185] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[186] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[187] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[188] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[189] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[190] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[191] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[192] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[193] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[194] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[195] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[196] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[197] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[198] => Array
(
[sql] => SELECT news_id FROM news n INNER JOIN content_page p ON p.page_id = n.page_id INNER JOIN metadata m ON m.metadata_id = p.metadata_id WHERE headline != "" AND p.is_published = 1 ORDER BY m.created DESC LIMIT 3
)
[199] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[200] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[201] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[202] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[203] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[204] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[205] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[206] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[207] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[208] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[209] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[210] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[211] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[212] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[213] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[214] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[215] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[216] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[217] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[218] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[219] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[220] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[221] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[222] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[223] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[224] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[225] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[226] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[227] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[228] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN content_page p ON e.page_id = p.page_id INNER JOIN metadata m on p.metadata_id = m.metadata_id WHERE m.created <= NOW() AND e.newsletter_feature = 1 AND (unix_timestamp(e.start_date) >= unix_timestamp(curdate())) AND (unix_timestamp(e.end_date) >= unix_timestamp(curdate())) AND p.is_published = 1 ORDER BY e.start_date ASC LIMIT 3
)
[229] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[230] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[231] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[232] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[233] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[234] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[235] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[236] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[237] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[238] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[239] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[240] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[241] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[242] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[243] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[244] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[245] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[246] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[247] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[248] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[249] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[250] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[251] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[252] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[253] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[254] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[255] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[256] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[257] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[258] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[259] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[260] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[261] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[262] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[263] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[264] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[265] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[266] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[267] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[268] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[269] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[270] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[271] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[272] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[273] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[274] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
)
[queryCounter] => 275
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[55] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[65] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[67] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[69] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[70] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[75] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[80] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[82] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[83] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[84] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[85] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[88] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[91] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[93] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[94] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[103] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[104] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[106] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[108] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[109] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[110] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[111] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[112] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[113] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[116] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[117] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[118] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[119] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[121] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[122] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[123] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[124] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[125] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[126] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[130] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[131] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[133] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[134] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[136] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[137] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[138] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[139] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[140] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[142] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[143] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[144] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[145] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[146] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[148] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[150] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[151] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[152] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[153] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[154] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[155] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[156] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[157] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[158] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[159] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[160] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[161] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[162] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[163] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[164] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[165] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[166] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[167] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[168] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[169] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[170] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[171] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[172] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[173] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[174] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[175] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[176] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[177] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[178] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[179] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[180] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[181] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[182] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[183] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[184] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[185] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[186] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[187] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[188] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[189] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[190] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[191] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[192] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[193] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[194] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[195] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[196] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[197] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[198] => Array
(
[sql] => SELECT news_id FROM news n INNER JOIN content_page p ON p.page_id = n.page_id INNER JOIN metadata m ON m.metadata_id = p.metadata_id WHERE headline != "" AND p.is_published = 1 ORDER BY m.created DESC LIMIT 3
)
[199] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[200] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[201] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[202] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[203] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[204] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[205] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[206] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[207] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[208] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[209] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[210] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[211] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[212] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[213] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[214] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[215] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[216] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[217] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[218] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[219] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[220] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[221] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[222] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[223] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[224] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[225] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[226] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[227] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[228] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN content_page p ON e.page_id = p.page_id INNER JOIN metadata m on p.metadata_id = m.metadata_id WHERE m.created <= NOW() AND e.newsletter_feature = 1 AND (unix_timestamp(e.start_date) >= unix_timestamp(curdate())) AND (unix_timestamp(e.end_date) >= unix_timestamp(curdate())) AND p.is_published = 1 ORDER BY e.start_date ASC LIMIT 3
)
[229] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[230] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[231] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[232] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[233] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[234] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[235] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[236] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[237] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[238] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[239] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[240] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[241] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[242] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[243] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[244] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[245] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[246] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[247] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[248] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[249] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[250] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[251] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[252] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[253] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[254] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[255] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[256] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[257] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[258] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[259] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[260] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[261] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[262] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[263] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[264] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[265] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[266] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[267] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[268] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[269] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[270] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[271] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[272] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[273] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[274] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
)
[queryCounter] => 275
)
)
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[55] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[65] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[67] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[69] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[70] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[75] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[80] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[82] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[83] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[84] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[85] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[88] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[91] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[93] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[94] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[103] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[104] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[106] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[108] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[109] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[110] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[111] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[112] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[113] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[116] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[117] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[118] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[119] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[121] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[122] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[123] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[124] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[125] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[126] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[130] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[131] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[133] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[134] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[136] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[137] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[138] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[139] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[140] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[142] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[143] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[144] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[145] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[146] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[148] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[150] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[151] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[152] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[153] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[154] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[155] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[156] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[157] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[158] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[159] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[160] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[161] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[162] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[163] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[164] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[165] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[166] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[167] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[168] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[169] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[170] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[171] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[172] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[173] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[174] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[175] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[176] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[177] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[178] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[179] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[180] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[181] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[182] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[183] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[184] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[185] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[186] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[187] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[188] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[189] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[190] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[191] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[192] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[193] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[194] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[195] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[196] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[197] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[198] => Array
(
[sql] => SELECT news_id FROM news n INNER JOIN content_page p ON p.page_id = n.page_id INNER JOIN metadata m ON m.metadata_id = p.metadata_id WHERE headline != "" AND p.is_published = 1 ORDER BY m.created DESC LIMIT 3
)
[199] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[200] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[201] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[202] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[203] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[204] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[205] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[206] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[207] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[208] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[209] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[210] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[211] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[212] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[213] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[214] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[215] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[216] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[217] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[218] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[219] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[220] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[221] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[222] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[223] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[224] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[225] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[226] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[227] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[228] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN content_page p ON e.page_id = p.page_id INNER JOIN metadata m on p.metadata_id = m.metadata_id WHERE m.created <= NOW() AND e.newsletter_feature = 1 AND (unix_timestamp(e.start_date) >= unix_timestamp(curdate())) AND (unix_timestamp(e.end_date) >= unix_timestamp(curdate())) AND p.is_published = 1 ORDER BY e.start_date ASC LIMIT 3
)
[229] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[230] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[231] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[232] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[233] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[234] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[235] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[236] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[237] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[238] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[239] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[240] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[241] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[242] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[243] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[244] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[245] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[246] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[247] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[248] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[249] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[250] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[251] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[252] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[253] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[254] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[255] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[256] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[257] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[258] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[259] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[260] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[261] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[262] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[263] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[264] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[265] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[266] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[267] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[268] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[269] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[270] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[271] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[272] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[273] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[274] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
)
[queryCounter] => 275
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[55] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[65] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[67] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[69] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[70] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[75] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[80] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[82] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[83] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[84] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[85] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[88] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[91] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[93] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[94] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[103] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[104] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[106] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[108] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[109] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[110] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[111] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[112] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[113] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[116] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[117] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[118] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[119] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[121] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[122] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[123] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[124] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[125] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[126] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[130] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[131] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[133] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[134] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[136] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[137] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[138] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[139] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[140] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[142] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[143] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[144] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[145] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[146] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[148] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[150] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[151] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[152] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[153] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[154] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[155] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[156] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[157] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[158] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[159] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[160] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[161] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[162] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[163] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[164] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[165] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[166] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[167] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[168] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[169] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[170] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[171] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[172] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[173] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[174] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[175] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[176] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[177] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[178] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[179] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[180] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[181] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[182] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[183] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[184] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[185] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[186] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[187] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[188] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[189] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[190] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[191] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[192] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[193] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[194] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[195] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[196] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[197] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[198] => Array
(
[sql] => SELECT news_id FROM news n INNER JOIN content_page p ON p.page_id = n.page_id INNER JOIN metadata m ON m.metadata_id = p.metadata_id WHERE headline != "" AND p.is_published = 1 ORDER BY m.created DESC LIMIT 3
)
[199] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[200] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[201] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[202] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[203] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[204] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[205] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[206] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[207] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[208] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[209] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[210] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[211] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[212] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[213] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[214] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[215] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[216] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[217] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[218] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[219] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[220] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[221] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[222] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[223] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[224] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[225] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[226] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[227] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[228] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN content_page p ON e.page_id = p.page_id INNER JOIN metadata m on p.metadata_id = m.metadata_id WHERE m.created <= NOW() AND e.newsletter_feature = 1 AND (unix_timestamp(e.start_date) >= unix_timestamp(curdate())) AND (unix_timestamp(e.end_date) >= unix_timestamp(curdate())) AND p.is_published = 1 ORDER BY e.start_date ASC LIMIT 3
)
[229] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[230] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[231] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[232] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[233] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[234] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[235] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[236] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[237] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[238] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[239] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[240] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[241] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[242] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[243] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[244] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[245] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[246] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[247] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[248] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[249] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[250] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[251] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[252] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[253] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[254] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[255] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[256] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[257] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[258] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[259] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[260] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[261] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[262] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[263] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[264] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[265] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[266] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[267] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[268] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[269] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[270] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[271] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[272] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[273] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[274] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
)
[queryCounter] => 275
)
)
[_view_manager:private] => Waterscape_Service_ViewManager Object
(
[_view_dao:private] => Waterscape_Dao_View Object
(
[_metadata_dao:private] => Waterscape_Dao_Metadata Object
(
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[55] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[65] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[67] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[69] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[70] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[75] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[80] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[82] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[83] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[84] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[85] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[88] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[91] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[93] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[94] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[103] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[104] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[106] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[108] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[109] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[110] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[111] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[112] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[113] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[116] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[117] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[118] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[119] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[121] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[122] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[123] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[124] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[125] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[126] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[130] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[131] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[133] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[134] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[136] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[137] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[138] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[139] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[140] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[142] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[143] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[144] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[145] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[146] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[148] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[150] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[151] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[152] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[153] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[154] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[155] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[156] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[157] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[158] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[159] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[160] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[161] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[162] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[163] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[164] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[165] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[166] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[167] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[168] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[169] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[170] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[171] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[172] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[173] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[174] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[175] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[176] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[177] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[178] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[179] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[180] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[181] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[182] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[183] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[184] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[185] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[186] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[187] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[188] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[189] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[190] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[191] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[192] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[193] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[194] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[195] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[196] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[197] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[198] => Array
(
[sql] => SELECT news_id FROM news n INNER JOIN content_page p ON p.page_id = n.page_id INNER JOIN metadata m ON m.metadata_id = p.metadata_id WHERE headline != "" AND p.is_published = 1 ORDER BY m.created DESC LIMIT 3
)
[199] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[200] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[201] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[202] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[203] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[204] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[205] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[206] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[207] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[208] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[209] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[210] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[211] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[212] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[213] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[214] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[215] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[216] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[217] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[218] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[219] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[220] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?
)
[221] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[222] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[223] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[224] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[225] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN news_waterway n ON n.waterway_id = w.id WHERE n.news_id = ?
)
[226] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[227] => Array
(
[sql] => SELECT navigation_authority_region_id FROM news_navigation_authority_region WHERE news_id = ?
)
[228] => Array
(
[sql] => SELECT e.event_id FROM event e INNER JOIN content_page p ON e.page_id = p.page_id INNER JOIN metadata m on p.metadata_id = m.metadata_id WHERE m.created <= NOW() AND e.newsletter_feature = 1 AND (unix_timestamp(e.start_date) >= unix_timestamp(curdate())) AND (unix_timestamp(e.end_date) >= unix_timestamp(curdate())) AND p.is_published = 1 ORDER BY e.start_date ASC LIMIT 3
)
[229] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[230] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[231] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[232] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[233] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[234] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[235] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[236] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[237] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[238] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[239] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[240] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[241] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[242] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[243] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[244] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[245] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[246] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[247] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[248] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[249] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[250] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[251] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[252] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[253] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[254] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[255] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[256] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[257] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[258] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[259] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[260] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
[261] => Array
(
[sql] => SELECT * FROM event e INNER JOIN content_page p on p.page_id = e.page_id INNER JOIN metadata m on m.metadata_id = p.metadata_id WHERE event_id = ?
)
[262] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[263] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[264] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[265] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[266] => Array
(
[sql] => SELECT * FROM address WHERE address_id = ?
)
[267] => Array
(
[sql] => SELECT * FROM town WHERE town_id = ?
)
[268] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[269] => Array
(
[sql] => SELECT id, data_type, x, y, AsText(data) AS geo_data FROM geo_point WHERE id = ?
)
[270] => Array
(
[sql] => SELECT * FROM county WHERE county_id = ?
)
[271] => Array
(
[sql] => SELECT * FROM country WHERE country_id = ?
)
[272] => Array
(
[sql] => SELECT media_id FROM event_media WHERE event_id = ?
)
[273] => Array
(
[sql] => SELECT waterway_id FROM waterway w INNER JOIN event_waterway ew ON ew.waterway_id = w.id WHERE ew.event_id = ?
)
[274] => Array
(
[sql] => SELECT * FROM waterway w LEFT JOIN waterway_parent AS p ON w.id = p.waterway_id WHERE id = ?
)
)
[queryCounter] => 275
)
)
[_db:protected] => Waterscape_Database Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SELECT id FROM url_mapping where alias REGEXP ?
)
[1] => Array
(
[sql] => SELECT * FROM content_view WHERE ? LIKE replace(path, "*", "%") AND application_handler = 1
)
[2] => Array
(
[sql] => SELECT * FROM content_view v INNER JOIN content_page p ON v.view_id = p.view_id WHERE p.path = ? AND p.is_published > 0
)
[3] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[4] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[5] => Array
(
[sql] => SELECT * FROM content_view_component WHERE view_id = ?
)
[6] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[7] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[8] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[9] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[10] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[11] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[12] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[13] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[14] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[15] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[16] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[17] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[18] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[19] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[20] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[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_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[24] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[25] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[26] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[27] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[28] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[29] => Array
(
[sql] => SELECT * FROM content_view_component_configuration WHERE view_component_id = ? AND config_key = ?
)
[30] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[31] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[32] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[33] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[34] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[35] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[36] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[37] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[38] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[39] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[40] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[41] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[42] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[43] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[44] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[45] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[46] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[47] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[48] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[49] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[50] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[51] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[52] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[53] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[54] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[55] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[56] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[57] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[58] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[59] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[60] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[61] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[62] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[63] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[64] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[65] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[66] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[67] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[68] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[69] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[70] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[71] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[72] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[73] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[74] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[75] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[76] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[77] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[78] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[79] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[80] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[81] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[82] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[83] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[84] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[85] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[86] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[87] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[88] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[89] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[90] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[91] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[92] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[93] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[94] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[95] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[96] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[97] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[98] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[99] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[100] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[101] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[102] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[103] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[104] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[105] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[106] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[107] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[108] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[109] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[110] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[111] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[112] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[113] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[114] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[115] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[116] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[117] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[118] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[119] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[120] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[121] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[122] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[123] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[124] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[125] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[126] => Array
(
[sql] => SELECT * FROM media WHERE media_id = ?
)
[127] => Array
(
[sql] => SELECT * FROM media_type WHERE media_type_id = ?
)
[128] => Array
(
[sql] => SELECT * FROM media_class WHERE media_class_id = ?
)
[129] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[130] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[131] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[132] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[133] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[134] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[135] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[136] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[137] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[138] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[139] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[140] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[141] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[142] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[143] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[144] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[145] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[146] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[147] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[148] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[149] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[150] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[151] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[152] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[153] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[154] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[155] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[156] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[157] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[158] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[159] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[160] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[161] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[162] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[163] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[164] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[165] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[166] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[167] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[168] => Array
(
[sql] => SELECT * FROM content_view_component v INNER JOIN content_component c ON c.component_id = v.component_id WHERE v.view_component_id = ?
)
[169] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[170] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[171] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type <> ?
)
[172] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[173] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[174] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[175] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[176] => Array
(
[sql] => SELECT * FROM link WHERE link_id = ?
)
[177] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[178] => Array
(
[sql] => SELECT * FROM content_component_configuration WHERE component_id = ? AND config_type = ?
)
[179] => Array
(
[sql] => SELECT component_id FROM content_component WHERE class_name = ?
)
[180] => Array
(
[sql] => SELECT * FROM content_component WHERE component_id = ?
)
[181] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[182] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[183] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[184] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[185] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[186] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[187] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[188] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[189] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[190] => Array
(
[sql] => SELECT * FROM cache_db WHERE md5query = :md5q
)
[191] => Array
(
[sql] => SELECT page_id FROM content_page WHERE path = ?
)
[192] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[193] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[194] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[195] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[196] => Array
(
[sql] => SELECT view_component_id FROM content_view_component WHERE view_id = ? AND instance_name = ? AND component_id = ?
)
[197] => Array
(
[sql] => SELECT * FROM content_page_component_configuration WHERE view_component_id = ? AND page_id = ? AND config_key = ?
)
[198] => Array
(
[sql] => SELECT news_id FROM news n INNER JOIN content_page p ON p.page_id = n.page_id INNER JOIN metadata m ON m.metadata_id = p.metadata_id WHERE headline != "" AND p.is_published = 1 ORDER BY m.created DESC LIMIT 3
)
[199] => Array
(
[sql] => SELECT * FROM news n INNER JOIN content_page p ON p.page_id = n.page_id WHERE news_id = ?
)
[200] => Array
(
[sql] => SELECT * FROM content_page WHERE page_id = ?
)
[201] => Array
(
[sql] => SELECT * FROM content_view WHERE view_id = ?
)
[202] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[203] => Array
(
[sql] => SELECT * FROM metadata WHERE metadata_id = ?
)
[204] => Array
(
[sql] => SELECT media_id FROM news_media WHERE news_id = ?