Close

Select an option to filter your content

Close
Back
object(Zend_Db_Select)#560 (4) { ["_bind":protected]=> array(0) { } ["_adapter":protected]=> object(Fb_Db_Adapter_Mysqli)#75 (12) { ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt":protected]=> object(Zend_Db_Statement_Mysqli)#79 (12) { ["_keys":protected]=> array(4) { [0]=> string(2) "id" [1]=> string(6) "typeId" [2]=> string(4) "path" [3]=> string(5) "title" } ["_values":protected]=> array(4) { [0]=> &int(105) [1]=> &string(20) "Award.Award.NewsPost" [2]=> &string(28) "/news/award-awards-finalists" [3]=> &string(23) "AWARD Awards Finalists " } ["_meta":protected]=> object(mysqli_result)#78 (5) { ["current_field"]=> int(0) ["field_count"]=> int(4) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(0) } ["_stmt":protected]=> object(mysqli_stmt)#520 (10) { ["affected_rows"]=> int(1) ["insert_id"]=> int(0) ["num_rows"]=> int(1) ["param_count"]=> int(0) ["field_count"]=> int(4) ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["sqlstate"]=> string(5) "00000" ["id"]=> int(2) } ["_adapter":protected]=> *RECURSION* ["_fetchMode":protected]=> int(5) ["_attribute":protected]=> array(0) { } ["_bindColumn":protected]=> array(0) { } ["_bindParam":protected]=> array(0) { } ["_sqlSplit":protected]=> array(1) { [0]=> string(485) "SELECT ., ., ., . FROM LEFT JOIN ON cms_contentobject.id = cms_contentobject_trans .id AND cms_contentobject_trans.locale= LEFT JOIN AS ON cms_contentobject.id = cms_contentobject_trans_source.id AND cms_contentobject_trans_source.locale=cms_contentobject_trans_source.sourceLocale AND (cms_contentobject_trans.translationId IS NULL) INNER JOIN AS ON node.linkId = cms_contentobject.id and cms_contentobject.isActive=1 and node.isActive=1 WHERE (path = ) ORDER BY asc LIMIT 1" } ["_sqlParam":protected]=> array(1) { [0]=> string(485) "SELECT ., ., ., . FROM LEFT JOIN ON cms_contentobject.id = cms_contentobject_trans .id AND cms_contentobject_trans.locale= LEFT JOIN AS ON cms_contentobject.id = cms_contentobject_trans_source.id AND cms_contentobject_trans_source.locale=cms_contentobject_trans_source.sourceLocale AND (cms_contentobject_trans.translationId IS NULL) INNER JOIN AS ON node.linkId = cms_contentobject.id and cms_contentobject.isActive=1 and node.isActive=1 WHERE (path = ) ORDER BY asc LIMIT 1" } ["_queryId":protected]=> NULL } ["_defaultStmtClass":protected]=> string(24) "Zend_Db_Statement_Mysqli" ["_config":protected]=> array(8) { ["host"]=> string(9) "localhost" ["username"]=> string(15) "awardonl_dbuser" ["password"]=> string(12) "EUI}b1!IcK8n" ["dbname"]=> string(16) "awardonl_website" ["charset"]=> NULL ["persistent"]=> bool(false) ["options"]=> array(3) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) ["fetchMode"]=> int(2) } ["driver_options"]=> array(0) { } } ["_fetchMode":protected]=> int(5) ["_profiler":protected]=> object(Zend_Db_Profiler)#76 (4) { ["_queryProfiles":protected]=> array(0) { } ["_enabled":protected]=> bool(false) ["_filterElapsedSecs":protected]=> NULL ["_filterTypes":protected]=> NULL } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(mysqli)#77 (19) { ["affected_rows"]=> int(5) ["client_info"]=> string(15) "10.0.31-MariaDB" ["client_version"]=> int(100031) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(6) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(15) "10.0.32-MariaDB" ["server_version"]=> int(100032) ["stat"]=> string(154) "Uptime: 1638775 Threads: 2 Questions: 180739094 Slow queries: 30 Opens: 4163011 Flush tables: 1809 Open tables: 400 Queries per second avg: 110.289" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(2327630) ["warning_count"]=> int(0) } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } ["_parts":protected]=> array(11) { ["distinct"]=> bool(false) ["columns"]=> array(47) { [0]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(2) "id" [2]=> NULL } [1]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(6) "typeId" [2]=> NULL } [2]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(8) "isActive" [2]=> NULL } [3]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(7) "urlPath" [2]=> NULL } [4]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "publishDate" [2]=> NULL } [5]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(10) "expiryDate" [2]=> NULL } [6]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "dateCreated" [2]=> NULL } [7]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "createdById" [2]=> NULL } [8]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "dateModified" [2]=> NULL } [9]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "modifiedById" [2]=> NULL } [10]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(6) "status" [2]=> NULL } [11]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(8) "featured" [2]=> NULL } [12]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(4) "home" [2]=> NULL } [13]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(9) "sortOrder" [2]=> NULL } [14]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(7) "assetId" [2]=> NULL } [15]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(15) "commentsEnabled" [2]=> NULL } [16]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(17) "commentsModerated" [2]=> NULL } [17]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(18) "commentsExpiryDate" [2]=> NULL } [18]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(14) "ratingsEnabled" [2]=> NULL } [19]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "ratingsCount" [2]=> NULL } [20]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(10) "ratingsAvg" [2]=> NULL } [21]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(17) "ratingsExpiryDate" [2]=> NULL } [22]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "voteEnabled" [2]=> NULL } [23]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(9) "voteCount" [2]=> NULL } [24]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(14) "voteExpiryDate" [2]=> NULL } [25]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(8) "cssClass" [2]=> NULL } [26]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(5) "cssId" [2]=> NULL } [27]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(13) "submittedById" [2]=> NULL } [28]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(7) "indexed" [2]=> NULL } [29]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "hasChildren" [2]=> NULL } [30]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(14) "showInPageTree" [2]=> NULL } [31]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "migrationId" [2]=> NULL } [32]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "migrationUrl" [2]=> NULL } [33]=> array(3) { [0]=> string(10) "award_news" [1]=> string(18) "homepageBlockStyle" [2]=> NULL } [34]=> array(3) { [0]=> string(23) "cms_contentobject_trans" [1]=> string(13) "translationId" [2]=> NULL } [35]=> array(3) { [0]=> string(23) "cms_contentobject_trans" [1]=> string(6) "locale" [2]=> NULL } [36]=> array(3) { [0]=> string(23) "cms_contentobject_trans" [1]=> string(5) "title" [2]=> NULL } [37]=> array(3) { [0]=> string(23) "cms_contentobject_trans" [1]=> string(10) "shortTitle" [2]=> NULL } [38]=> array(3) { [0]=> string(23) "cms_contentobject_trans" [1]=> string(8) "keywords" [2]=> NULL } [39]=> array(3) { [0]=> string(23) "cms_contentobject_trans" [1]=> string(8) "subTitle" [2]=> NULL } [40]=> array(3) { [0]=> string(23) "cms_contentobject_trans" [1]=> string(5) "intro" [2]=> NULL } [41]=> array(3) { [0]=> string(23) "cms_contentobject_trans" [1]=> string(4) "body" [2]=> NULL } [42]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#550 (1) { ["_expression":protected]=> string(90) "COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale)" } [2]=> string(12) "sourceLocale" } [43]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#553 (1) { ["_expression":protected]=> string(201) "CASE WHEN COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale) != cms_contentobject_trans.locale OR cms_contentobject_trans.translationId IS NULL THEN 1 ELSE 0 END" } [2]=> string(13) "isTranslation" } [44]=> array(3) { [0]=> string(16) "award_news_trans" [1]=> string(6) "locale" [2]=> NULL } [45]=> array(3) { [0]=> string(16) "award_news_trans" [1]=> string(12) "sourceLocale" [2]=> NULL } [46]=> array(3) { [0]=> string(16) "award_news_trans" [1]=> string(8) "category" [2]=> NULL } } ["union"]=> array(0) { } ["from"]=> array(5) { ["cms_contentobject"]=> array(4) { ["joinType"]=> string(4) "from" ["schema"]=> NULL ["tableName"]=> string(17) "cms_contentobject" ["joinCondition"]=> NULL } ["award_news"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(10) "award_news" ["joinCondition"]=> string(40) "award_news.`id` = cms_contentobject.`id`" } ["cms_contentobject_trans"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(23) "cms_contentobject_trans" ["joinCondition"]=> string(90) "cms_contentobject.id = cms_contentobject_trans .id AND cms_contentobject_trans.locale='en'" } ["cms_contentobject_trans_source"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(23) "cms_contentobject_trans" ["joinCondition"]=> string(194) "cms_contentobject.id = cms_contentobject_trans_source.id AND cms_contentobject_trans_source.locale=cms_contentobject_trans_source.sourceLocale AND (cms_contentobject_trans.translationId IS NULL)" } ["award_news_trans"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(16) "award_news_trans" ["joinCondition"]=> string(70) "cms_contentobject_trans.translationId = award_news_trans.translationId" } } ["where"]=> array(1) { [0]=> string(31) "(cms_contentobject.`id` = 105 )" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(0) { } ["limitcount"]=> NULL ["limitoffset"]=> NULL ["forupdate"]=> bool(false) } ["_tableCols":protected]=> array(0) { } } object(Zend_Db_Select)#711 (4) { ["_bind":protected]=> array(0) { } ["_adapter":protected]=> object(Fb_Db_Adapter_Mysqli)#75 (12) { ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt":protected]=> object(Zend_Db_Statement_Mysqli)#642 (12) { ["_keys":protected]=> array(14) { [0]=> string(2) "id" [1]=> string(10) "sourcePath" [2]=> string(9) "sourceUrl" [3]=> string(11) "previewPath" [4]=> string(10) "previewUrl" [5]=> string(5) "width" [6]=> string(6) "height" [7]=> string(9) "assetType" [8]=> string(8) "isActive" [9]=> string(13) "translationId" [10]=> string(6) "locale" [11]=> string(12) "sourceLocale" [12]=> string(5) "title" [13]=> string(13) "isTranslation" } ["_values":protected]=> array(14) { [0]=> &NULL [1]=> &NULL [2]=> &NULL [3]=> &NULL [4]=> &NULL [5]=> &int(0) [6]=> &int(0) [7]=> &NULL [8]=> &int(0) [9]=> &NULL [10]=> &NULL [11]=> &NULL [12]=> &NULL [13]=> &NULL } ["_meta":protected]=> object(mysqli_result)#781 (5) { ["current_field"]=> int(0) ["field_count"]=> int(14) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(0) } ["_stmt":protected]=> object(mysqli_stmt)#542 (10) { ["affected_rows"]=> int(0) ["insert_id"]=> int(0) ["num_rows"]=> int(0) ["param_count"]=> int(0) ["field_count"]=> int(14) ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["sqlstate"]=> string(5) "00000" ["id"]=> int(6) } ["_adapter":protected]=> *RECURSION* ["_fetchMode":protected]=> int(5) ["_attribute":protected]=> array(0) { } ["_bindColumn":protected]=> array(0) { } ["_bindParam":protected]=> array(0) { } ["_sqlSplit":protected]=> array(1) { [0]=> string(815) "SELECT ., ., ., ., ., ., ., ., ., ., ., COALESCE(cms_asset_trans.sourceLocale,cms_asset_trans_source.sourceLocale) AS , COALESCE(cms_asset_trans.title,cms_asset_trans_source.title) AS , CASE WHEN COALESCE(cms_asset_trans.sourceLocale,cms_asset_trans_source.sourceLocale) != cms_asset_trans.locale or cms_asset_trans.translationId IS NULL THEN 1 ELSE 0 END AS FROM LEFT JOIN ON cms_asset.id = cms_asset_trans .id AND cms_asset_trans.locale= LEFT JOIN AS ON cms_asset.id = cms_asset_trans_source.id AND cms_asset_trans_source.locale=cms_asset_trans_source.sourceLocale AND (cms_asset_trans.translationId IS NULL) INNER JOIN ON cms_asset_object.assetId = cms_asset.id WHERE (cms_asset.isActive = 1 ) AND (cms_asset_object.rel=) AND (cms_asset_object.typeId=) AND (cms_asset_object.objectId=105) ORDER BY . asc" } ["_sqlParam":protected]=> array(1) { [0]=> string(815) "SELECT ., ., ., ., ., ., ., ., ., ., ., COALESCE(cms_asset_trans.sourceLocale,cms_asset_trans_source.sourceLocale) AS , COALESCE(cms_asset_trans.title,cms_asset_trans_source.title) AS , CASE WHEN COALESCE(cms_asset_trans.sourceLocale,cms_asset_trans_source.sourceLocale) != cms_asset_trans.locale or cms_asset_trans.translationId IS NULL THEN 1 ELSE 0 END AS FROM LEFT JOIN ON cms_asset.id = cms_asset_trans .id AND cms_asset_trans.locale= LEFT JOIN AS ON cms_asset.id = cms_asset_trans_source.id AND cms_asset_trans_source.locale=cms_asset_trans_source.sourceLocale AND (cms_asset_trans.translationId IS NULL) INNER JOIN ON cms_asset_object.assetId = cms_asset.id WHERE (cms_asset.isActive = 1 ) AND (cms_asset_object.rel=) AND (cms_asset_object.typeId=) AND (cms_asset_object.objectId=105) ORDER BY . asc" } ["_queryId":protected]=> NULL } ["_defaultStmtClass":protected]=> string(24) "Zend_Db_Statement_Mysqli" ["_config":protected]=> array(8) { ["host"]=> string(9) "localhost" ["username"]=> string(15) "awardonl_dbuser" ["password"]=> string(12) "EUI}b1!IcK8n" ["dbname"]=> string(16) "awardonl_website" ["charset"]=> NULL ["persistent"]=> bool(false) ["options"]=> array(3) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) ["fetchMode"]=> int(2) } ["driver_options"]=> array(0) { } } ["_fetchMode":protected]=> int(5) ["_profiler":protected]=> object(Zend_Db_Profiler)#76 (4) { ["_queryProfiles":protected]=> array(0) { } ["_enabled":protected]=> bool(false) ["_filterElapsedSecs":protected]=> NULL ["_filterTypes":protected]=> NULL } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(mysqli)#77 (19) { ["affected_rows"]=> int(10) ["client_info"]=> string(15) "10.0.31-MariaDB" ["client_version"]=> int(100031) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(6) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(15) "10.0.32-MariaDB" ["server_version"]=> int(100032) ["stat"]=> string(154) "Uptime: 1638775 Threads: 2 Questions: 180739210 Slow queries: 30 Opens: 4163012 Flush tables: 1809 Open tables: 400 Queries per second avg: 110.289" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(2327630) ["warning_count"]=> int(0) } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } ["_parts":protected]=> array(11) { ["distinct"]=> bool(false) ["columns"]=> array(43) { [0]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(2) "id" [2]=> NULL } [1]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(6) "typeId" [2]=> NULL } [2]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(8) "isActive" [2]=> NULL } [3]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(7) "urlPath" [2]=> NULL } [4]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "publishDate" [2]=> NULL } [5]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(10) "expiryDate" [2]=> NULL } [6]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "dateCreated" [2]=> NULL } [7]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "createdById" [2]=> NULL } [8]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "dateModified" [2]=> NULL } [9]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "modifiedById" [2]=> NULL } [10]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(6) "status" [2]=> NULL } [11]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(8) "featured" [2]=> NULL } [12]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(4) "home" [2]=> NULL } [13]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(9) "sortOrder" [2]=> NULL } [14]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(7) "assetId" [2]=> NULL } [15]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(15) "commentsEnabled" [2]=> NULL } [16]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(17) "commentsModerated" [2]=> NULL } [17]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(18) "commentsExpiryDate" [2]=> NULL } [18]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(14) "ratingsEnabled" [2]=> NULL } [19]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "ratingsCount" [2]=> NULL } [20]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(10) "ratingsAvg" [2]=> NULL } [21]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(17) "ratingsExpiryDate" [2]=> NULL } [22]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "voteEnabled" [2]=> NULL } [23]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(9) "voteCount" [2]=> NULL } [24]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(14) "voteExpiryDate" [2]=> NULL } [25]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(8) "cssClass" [2]=> NULL } [26]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(5) "cssId" [2]=> NULL } [27]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(13) "submittedById" [2]=> NULL } [28]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(7) "indexed" [2]=> NULL } [29]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "hasChildren" [2]=> NULL } [30]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(14) "showInPageTree" [2]=> NULL } [31]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "migrationId" [2]=> NULL } [32]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "migrationUrl" [2]=> NULL } [33]=> array(3) { [0]=> string(23) "cms_contentobject_trans" [1]=> string(13) "translationId" [2]=> NULL } [34]=> array(3) { [0]=> string(23) "cms_contentobject_trans" [1]=> string(6) "locale" [2]=> NULL } [35]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#792 (1) { ["_expression":protected]=> string(90) "COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale)" } [2]=> string(12) "sourceLocale" } [36]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#593 (1) { ["_expression":protected]=> string(76) "COALESCE(cms_contentobject_trans.title,cms_contentobject_trans_source.title)" } [2]=> string(5) "title" } [37]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#520 (1) { ["_expression":protected]=> string(86) "COALESCE(cms_contentobject_trans.shortTitle,cms_contentobject_trans_source.shortTitle)" } [2]=> string(10) "shortTitle" } [38]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#655 (1) { ["_expression":protected]=> string(82) "COALESCE(cms_contentobject_trans.keywords,cms_contentobject_trans_source.keywords)" } [2]=> string(8) "keywords" } [39]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#749 (1) { ["_expression":protected]=> string(82) "COALESCE(cms_contentobject_trans.subTitle,cms_contentobject_trans_source.subTitle)" } [2]=> string(8) "subTitle" } [40]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#618 (1) { ["_expression":protected]=> string(76) "COALESCE(cms_contentobject_trans.intro,cms_contentobject_trans_source.intro)" } [2]=> string(5) "intro" } [41]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#623 (1) { ["_expression":protected]=> string(74) "COALESCE(cms_contentobject_trans.body,cms_contentobject_trans_source.body)" } [2]=> string(4) "body" } [42]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#589 (1) { ["_expression":protected]=> string(201) "CASE WHEN COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale) != cms_contentobject_trans.locale or cms_contentobject_trans.translationId IS NULL THEN 1 ELSE 0 END" } [2]=> string(13) "isTranslation" } } ["union"]=> array(0) { } ["from"]=> array(3) { ["cms_contentobject"]=> array(4) { ["joinType"]=> string(4) "from" ["schema"]=> NULL ["tableName"]=> string(17) "cms_contentobject" ["joinCondition"]=> NULL } ["cms_contentobject_trans"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(23) "cms_contentobject_trans" ["joinCondition"]=> string(90) "cms_contentobject.id = cms_contentobject_trans .id AND cms_contentobject_trans.locale='en'" } ["cms_contentobject_trans_source"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(23) "cms_contentobject_trans" ["joinCondition"]=> string(194) "cms_contentobject.id = cms_contentobject_trans_source.id AND cms_contentobject_trans_source.locale=cms_contentobject_trans_source.sourceLocale AND (cms_contentobject_trans.translationId IS NULL)" } } ["where"]=> array(1) { [0]=> string(33) "(cms_contentobject.isActive = 1 )" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(0) { } ["limitcount"]=> NULL ["limitoffset"]=> NULL ["forupdate"]=> bool(false) } ["_tableCols":protected]=> array(0) { } } object(Zend_Db_Select)#623 (4) { ["_bind":protected]=> array(0) { } ["_adapter":protected]=> object(Fb_Db_Adapter_Mysqli)#75 (12) { ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt":protected]=> object(Zend_Db_Statement_Mysqli)#542 (12) { ["_keys":protected]=> array(35) { [0]=> string(2) "id" [1]=> string(6) "typeId" [2]=> string(7) "assetId" [3]=> string(6) "parent" [4]=> string(3) "rel" [5]=> string(8) "isActive" [6]=> string(9) "sortOrder" [7]=> string(3) "url" [8]=> string(12) "internalLink" [9]=> string(13) "startDateTime" [10]=> string(11) "endDateTime" [11]=> string(4) "date" [12]=> string(13) "translationId" [13]=> string(6) "locale" [14]=> string(12) "sourceLocale" [15]=> string(5) "title" [16]=> string(8) "subTitle" [17]=> string(9) "linkTitle" [18]=> string(4) "text" [19]=> string(13) "isTranslation" [20]=> string(8) "asset_id" [21]=> string(16) "asset_sourcePath" [22]=> string(15) "asset_sourceUrl" [23]=> string(17) "asset_previewPath" [24]=> string(16) "asset_previewUrl" [25]=> string(11) "asset_width" [26]=> string(12) "asset_height" [27]=> string(15) "asset_assetType" [28]=> string(14) "asset_isActive" [29]=> string(19) "asset_translationId" [30]=> string(12) "asset_locale" [31]=> string(18) "asset_sourceLocale" [32]=> string(11) "asset_title" [33]=> string(19) "asset_isTranslation" [34]=> string(22) "internalLink_node_path" } ["_values":protected]=> array(35) { [0]=> &NULL [1]=> &NULL [2]=> &NULL [3]=> &int(0) [4]=> &NULL [5]=> &int(0) [6]=> &int(0) [7]=> &NULL [8]=> &int(0) [9]=> &NULL [10]=> &NULL [11]=> &NULL [12]=> &NULL [13]=> &NULL [14]=> &NULL [15]=> &NULL [16]=> &NULL [17]=> &NULL [18]=> &NULL [19]=> &NULL [20]=> &NULL [21]=> &NULL [22]=> &NULL [23]=> &NULL [24]=> &NULL [25]=> &int(0) [26]=> &int(0) [27]=> &NULL [28]=> &int(0) [29]=> &NULL [30]=> &NULL [31]=> &NULL [32]=> &NULL [33]=> &NULL [34]=> &NULL } ["_meta":protected]=> object(mysqli_result)#642 (5) { ["current_field"]=> int(0) ["field_count"]=> int(35) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(0) } ["_stmt":protected]=> object(mysqli_stmt)#531 (10) { ["affected_rows"]=> int(0) ["insert_id"]=> int(0) ["num_rows"]=> int(0) ["param_count"]=> int(0) ["field_count"]=> int(35) ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["sqlstate"]=> string(5) "00000" ["id"]=> int(7) } ["_adapter":protected]=> *RECURSION* ["_fetchMode":protected]=> int(5) ["_attribute":protected]=> array(0) { } ["_bindColumn":protected]=> array(0) { } ["_bindParam":protected]=> array(0) { } ["_sqlSplit":protected]=> array(1) { [0]=> string(4244) "SELECT ., ., ., ., ., ., ., ., ., ., ., ., ., ., COALESCE(cms_promotile_trans.sourceLocale,cms_promotile_trans_source.sourceLocale) AS , COALESCE(cms_promotile_trans.title,cms_promotile_trans_source.title) AS , COALESCE(cms_promotile_trans.subTitle,cms_promotile_trans_source.subTitle) AS , COALESCE(cms_promotile_trans.linkTitle,cms_promotile_trans_source.linkTitle) AS , COALESCE(cms_promotile_trans.text,cms_promotile_trans_source.text) AS , CASE WHEN COALESCE(cms_promotile_trans.sourceLocale,cms_promotile_trans_source.sourceLocale) != cms_promotile_trans.locale or cms_promotile_trans.translationId IS NULL THEN 1 ELSE 0 END AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS FROM LEFT JOIN ON cms_promotile.id = cms_promotile_trans .id AND cms_promotile_trans.locale= LEFT JOIN AS ON cms_promotile.id = cms_promotile_trans_source.id AND cms_promotile_trans_source.locale=cms_promotile_trans_source.sourceLocale AND (cms_promotile_trans.translationId IS NULL) LEFT JOIN (SELECT ., ., ., ., ., ., ., ., ., ., ., COALESCE(cms_asset_trans.sourceLocale,cms_asset_trans_source.sourceLocale) AS , COALESCE(cms_asset_trans.title,cms_asset_trans_source.title) AS , CASE WHEN COALESCE(cms_asset_trans.sourceLocale,cms_asset_trans_source.sourceLocale) != cms_asset_trans.locale or cms_asset_trans.translationId IS NULL THEN 1 ELSE 0 END AS FROM LEFT JOIN ON cms_asset.id = cms_asset_trans .id AND cms_asset_trans.locale= LEFT JOIN AS ON cms_asset.id = cms_asset_trans_source.id AND cms_asset_trans_source.locale=cms_asset_trans_source.sourceLocale AND (cms_asset_trans.translationId IS NULL)) AS ON cms_promotile.assetId=asset_join.id LEFT JOIN (SELECT ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale) AS , COALESCE(cms_contentobject_trans.title,cms_contentobject_trans_source.title) AS , COALESCE(cms_contentobject_trans.shortTitle,cms_contentobject_trans_source.shortTitle) AS , COALESCE(cms_contentobject_trans.keywords,cms_contentobject_trans_source.keywords) AS , COALESCE(cms_contentobject_trans.subTitle,cms_contentobject_trans_source.subTitle) AS , COALESCE(cms_contentobject_trans.intro,cms_contentobject_trans_source.intro) AS , COALESCE(cms_contentobject_trans.body,cms_contentobject_trans_source.body) AS , CASE WHEN COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale) != cms_contentobject_trans.locale or cms_contentobject_trans.translationId IS NULL THEN 1 ELSE 0 END AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , ., . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , COALESCE(asset_join_cms_asset_trans.sourceLocale,asset_join_cms_asset_trans_source.sourceLocale) AS , COALESCE(asset_join_cms_asset_trans.title,asset_join_cms_asset_trans_source.title) AS , CASE WHEN COALESCE(asset_join_cms_asset_trans.sourceLocale,asset_join_cms_asset_trans_source.sourceLocale) != asset_join_cms_asset_trans.locale or asset_join_cms_asset_trans.translationId IS NULL THEN 1 ELSE 0 END AS FROM LEFT JOIN ON cms_contentobject.id = cms_contentobject_trans .id AND cms_contentobject_trans.locale= LEFT JOIN AS ON cms_contentobject.id = cms_contentobject_trans_source.id AND cms_contentobject_trans_source.locale=cms_contentobject_trans_source.sourceLocale AND (cms_contentobject_trans.translationId IS NULL) LEFT JOIN ON cms_contenttreenode.linkId = cms_contentobject.id LEFT JOIN AS ON cms_contentobject.assetId=asset_join.id AND (asset_join.isActive = 1 ) LEFT JOIN AS ON asset_join.id = asset_join_cms_asset_trans.id AND asset_join_cms_asset_trans.locale= LEFT JOIN AS ON asset_join.id = asset_join_cms_asset_trans_source.id AND asset_join_cms_asset_trans_source.locale=asset_join_cms_asset_trans_source.sourceLocale AND (asset_join_cms_asset_trans.translationId IS NULL) WHERE (cms_contentobject.isActive = 1 )) AS ON cms_promotile.internalLink=co_join.id WHERE (cms_promotile.rel = ) AND (cms_promotile.parent = 105 ) AND (cms_promotile.isActive = 1 ) AND (cms_promotile.typeId = ) ORDER BY . asc" } ["_sqlParam":protected]=> array(1) { [0]=> string(4244) "SELECT ., ., ., ., ., ., ., ., ., ., ., ., ., ., COALESCE(cms_promotile_trans.sourceLocale,cms_promotile_trans_source.sourceLocale) AS , COALESCE(cms_promotile_trans.title,cms_promotile_trans_source.title) AS , COALESCE(cms_promotile_trans.subTitle,cms_promotile_trans_source.subTitle) AS , COALESCE(cms_promotile_trans.linkTitle,cms_promotile_trans_source.linkTitle) AS , COALESCE(cms_promotile_trans.text,cms_promotile_trans_source.text) AS , CASE WHEN COALESCE(cms_promotile_trans.sourceLocale,cms_promotile_trans_source.sourceLocale) != cms_promotile_trans.locale or cms_promotile_trans.translationId IS NULL THEN 1 ELSE 0 END AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS FROM LEFT JOIN ON cms_promotile.id = cms_promotile_trans .id AND cms_promotile_trans.locale= LEFT JOIN AS ON cms_promotile.id = cms_promotile_trans_source.id AND cms_promotile_trans_source.locale=cms_promotile_trans_source.sourceLocale AND (cms_promotile_trans.translationId IS NULL) LEFT JOIN (SELECT ., ., ., ., ., ., ., ., ., ., ., COALESCE(cms_asset_trans.sourceLocale,cms_asset_trans_source.sourceLocale) AS , COALESCE(cms_asset_trans.title,cms_asset_trans_source.title) AS , CASE WHEN COALESCE(cms_asset_trans.sourceLocale,cms_asset_trans_source.sourceLocale) != cms_asset_trans.locale or cms_asset_trans.translationId IS NULL THEN 1 ELSE 0 END AS FROM LEFT JOIN ON cms_asset.id = cms_asset_trans .id AND cms_asset_trans.locale= LEFT JOIN AS ON cms_asset.id = cms_asset_trans_source.id AND cms_asset_trans_source.locale=cms_asset_trans_source.sourceLocale AND (cms_asset_trans.translationId IS NULL)) AS ON cms_promotile.assetId=asset_join.id LEFT JOIN (SELECT ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale) AS , COALESCE(cms_contentobject_trans.title,cms_contentobject_trans_source.title) AS , COALESCE(cms_contentobject_trans.shortTitle,cms_contentobject_trans_source.shortTitle) AS , COALESCE(cms_contentobject_trans.keywords,cms_contentobject_trans_source.keywords) AS , COALESCE(cms_contentobject_trans.subTitle,cms_contentobject_trans_source.subTitle) AS , COALESCE(cms_contentobject_trans.intro,cms_contentobject_trans_source.intro) AS , COALESCE(cms_contentobject_trans.body,cms_contentobject_trans_source.body) AS , CASE WHEN COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale) != cms_contentobject_trans.locale or cms_contentobject_trans.translationId IS NULL THEN 1 ELSE 0 END AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , ., . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , COALESCE(asset_join_cms_asset_trans.sourceLocale,asset_join_cms_asset_trans_source.sourceLocale) AS , COALESCE(asset_join_cms_asset_trans.title,asset_join_cms_asset_trans_source.title) AS , CASE WHEN COALESCE(asset_join_cms_asset_trans.sourceLocale,asset_join_cms_asset_trans_source.sourceLocale) != asset_join_cms_asset_trans.locale or asset_join_cms_asset_trans.translationId IS NULL THEN 1 ELSE 0 END AS FROM LEFT JOIN ON cms_contentobject.id = cms_contentobject_trans .id AND cms_contentobject_trans.locale= LEFT JOIN AS ON cms_contentobject.id = cms_contentobject_trans_source.id AND cms_contentobject_trans_source.locale=cms_contentobject_trans_source.sourceLocale AND (cms_contentobject_trans.translationId IS NULL) LEFT JOIN ON cms_contenttreenode.linkId = cms_contentobject.id LEFT JOIN AS ON cms_contentobject.assetId=asset_join.id AND (asset_join.isActive = 1 ) LEFT JOIN AS ON asset_join.id = asset_join_cms_asset_trans.id AND asset_join_cms_asset_trans.locale= LEFT JOIN AS ON asset_join.id = asset_join_cms_asset_trans_source.id AND asset_join_cms_asset_trans_source.locale=asset_join_cms_asset_trans_source.sourceLocale AND (asset_join_cms_asset_trans.translationId IS NULL) WHERE (cms_contentobject.isActive = 1 )) AS ON cms_promotile.internalLink=co_join.id WHERE (cms_promotile.rel = ) AND (cms_promotile.parent = 105 ) AND (cms_promotile.isActive = 1 ) AND (cms_promotile.typeId = ) ORDER BY . asc" } ["_queryId":protected]=> NULL } ["_defaultStmtClass":protected]=> string(24) "Zend_Db_Statement_Mysqli" ["_config":protected]=> array(8) { ["host"]=> string(9) "localhost" ["username"]=> string(15) "awardonl_dbuser" ["password"]=> string(12) "EUI}b1!IcK8n" ["dbname"]=> string(16) "awardonl_website" ["charset"]=> NULL ["persistent"]=> bool(false) ["options"]=> array(3) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) ["fetchMode"]=> int(2) } ["driver_options"]=> array(0) { } } ["_fetchMode":protected]=> int(5) ["_profiler":protected]=> object(Zend_Db_Profiler)#76 (4) { ["_queryProfiles":protected]=> array(0) { } ["_enabled":protected]=> bool(false) ["_filterElapsedSecs":protected]=> NULL ["_filterTypes":protected]=> NULL } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(mysqli)#77 (19) { ["affected_rows"]=> int(10) ["client_info"]=> string(15) "10.0.31-MariaDB" ["client_version"]=> int(100031) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(6) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(15) "10.0.32-MariaDB" ["server_version"]=> int(100032) ["stat"]=> string(154) "Uptime: 1638775 Threads: 2 Questions: 180739230 Slow queries: 30 Opens: 4163012 Flush tables: 1809 Open tables: 400 Queries per second avg: 110.289" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(2327630) ["warning_count"]=> int(0) } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } ["_parts":protected]=> array(11) { ["distinct"]=> bool(false) ["columns"]=> array(43) { [0]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(2) "id" [2]=> NULL } [1]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(6) "typeId" [2]=> NULL } [2]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(8) "isActive" [2]=> NULL } [3]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(7) "urlPath" [2]=> NULL } [4]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "publishDate" [2]=> NULL } [5]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(10) "expiryDate" [2]=> NULL } [6]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "dateCreated" [2]=> NULL } [7]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "createdById" [2]=> NULL } [8]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "dateModified" [2]=> NULL } [9]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "modifiedById" [2]=> NULL } [10]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(6) "status" [2]=> NULL } [11]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(8) "featured" [2]=> NULL } [12]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(4) "home" [2]=> NULL } [13]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(9) "sortOrder" [2]=> NULL } [14]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(7) "assetId" [2]=> NULL } [15]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(15) "commentsEnabled" [2]=> NULL } [16]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(17) "commentsModerated" [2]=> NULL } [17]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(18) "commentsExpiryDate" [2]=> NULL } [18]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(14) "ratingsEnabled" [2]=> NULL } [19]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "ratingsCount" [2]=> NULL } [20]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(10) "ratingsAvg" [2]=> NULL } [21]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(17) "ratingsExpiryDate" [2]=> NULL } [22]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "voteEnabled" [2]=> NULL } [23]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(9) "voteCount" [2]=> NULL } [24]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(14) "voteExpiryDate" [2]=> NULL } [25]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(8) "cssClass" [2]=> NULL } [26]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(5) "cssId" [2]=> NULL } [27]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(13) "submittedById" [2]=> NULL } [28]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(7) "indexed" [2]=> NULL } [29]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "hasChildren" [2]=> NULL } [30]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(14) "showInPageTree" [2]=> NULL } [31]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "migrationId" [2]=> NULL } [32]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "migrationUrl" [2]=> NULL } [33]=> array(3) { [0]=> string(23) "cms_contentobject_trans" [1]=> string(13) "translationId" [2]=> NULL } [34]=> array(3) { [0]=> string(23) "cms_contentobject_trans" [1]=> string(6) "locale" [2]=> NULL } [35]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#589 (1) { ["_expression":protected]=> string(90) "COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale)" } [2]=> string(12) "sourceLocale" } [36]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#609 (1) { ["_expression":protected]=> string(76) "COALESCE(cms_contentobject_trans.title,cms_contentobject_trans_source.title)" } [2]=> string(5) "title" } [37]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#546 (1) { ["_expression":protected]=> string(86) "COALESCE(cms_contentobject_trans.shortTitle,cms_contentobject_trans_source.shortTitle)" } [2]=> string(10) "shortTitle" } [38]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#557 (1) { ["_expression":protected]=> string(82) "COALESCE(cms_contentobject_trans.keywords,cms_contentobject_trans_source.keywords)" } [2]=> string(8) "keywords" } [39]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#549 (1) { ["_expression":protected]=> string(82) "COALESCE(cms_contentobject_trans.subTitle,cms_contentobject_trans_source.subTitle)" } [2]=> string(8) "subTitle" } [40]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#526 (1) { ["_expression":protected]=> string(76) "COALESCE(cms_contentobject_trans.intro,cms_contentobject_trans_source.intro)" } [2]=> string(5) "intro" } [41]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#512 (1) { ["_expression":protected]=> string(74) "COALESCE(cms_contentobject_trans.body,cms_contentobject_trans_source.body)" } [2]=> string(4) "body" } [42]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#534 (1) { ["_expression":protected]=> string(201) "CASE WHEN COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale) != cms_contentobject_trans.locale or cms_contentobject_trans.translationId IS NULL THEN 1 ELSE 0 END" } [2]=> string(13) "isTranslation" } } ["union"]=> array(0) { } ["from"]=> array(3) { ["cms_contentobject"]=> array(4) { ["joinType"]=> string(4) "from" ["schema"]=> NULL ["tableName"]=> string(17) "cms_contentobject" ["joinCondition"]=> NULL } ["cms_contentobject_trans"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(23) "cms_contentobject_trans" ["joinCondition"]=> string(90) "cms_contentobject.id = cms_contentobject_trans .id AND cms_contentobject_trans.locale='en'" } ["cms_contentobject_trans_source"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(23) "cms_contentobject_trans" ["joinCondition"]=> string(194) "cms_contentobject.id = cms_contentobject_trans_source.id AND cms_contentobject_trans_source.locale=cms_contentobject_trans_source.sourceLocale AND (cms_contentobject_trans.translationId IS NULL)" } } ["where"]=> array(1) { [0]=> string(33) "(cms_contentobject.isActive = 1 )" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(0) { } ["limitcount"]=> NULL ["limitoffset"]=> NULL ["forupdate"]=> bool(false) } ["_tableCols":protected]=> array(0) { } } object(Zend_Db_Select)#512 (4) { ["_bind":protected]=> array(0) { } ["_adapter":protected]=> object(Fb_Db_Adapter_Mysqli)#75 (12) { ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt":protected]=> object(Zend_Db_Statement_Mysqli)#531 (12) { ["_keys":protected]=> array(35) { [0]=> string(2) "id" [1]=> string(6) "typeId" [2]=> string(7) "assetId" [3]=> string(6) "parent" [4]=> string(3) "rel" [5]=> string(8) "isActive" [6]=> string(9) "sortOrder" [7]=> string(3) "url" [8]=> string(12) "internalLink" [9]=> string(13) "startDateTime" [10]=> string(11) "endDateTime" [11]=> string(4) "date" [12]=> string(13) "translationId" [13]=> string(6) "locale" [14]=> string(12) "sourceLocale" [15]=> string(5) "title" [16]=> string(8) "subTitle" [17]=> string(9) "linkTitle" [18]=> string(4) "text" [19]=> string(13) "isTranslation" [20]=> string(8) "asset_id" [21]=> string(16) "asset_sourcePath" [22]=> string(15) "asset_sourceUrl" [23]=> string(17) "asset_previewPath" [24]=> string(16) "asset_previewUrl" [25]=> string(11) "asset_width" [26]=> string(12) "asset_height" [27]=> string(15) "asset_assetType" [28]=> string(14) "asset_isActive" [29]=> string(19) "asset_translationId" [30]=> string(12) "asset_locale" [31]=> string(18) "asset_sourceLocale" [32]=> string(11) "asset_title" [33]=> string(19) "asset_isTranslation" [34]=> string(22) "internalLink_node_path" } ["_values":protected]=> array(35) { [0]=> &NULL [1]=> &NULL [2]=> &NULL [3]=> &int(0) [4]=> &NULL [5]=> &int(0) [6]=> &int(0) [7]=> &NULL [8]=> &int(0) [9]=> &NULL [10]=> &NULL [11]=> &NULL [12]=> &NULL [13]=> &NULL [14]=> &NULL [15]=> &NULL [16]=> &NULL [17]=> &NULL [18]=> &NULL [19]=> &NULL [20]=> &NULL [21]=> &NULL [22]=> &NULL [23]=> &NULL [24]=> &NULL [25]=> &int(0) [26]=> &int(0) [27]=> &NULL [28]=> &int(0) [29]=> &NULL [30]=> &NULL [31]=> &NULL [32]=> &NULL [33]=> &NULL [34]=> &NULL } ["_meta":protected]=> object(mysqli_result)#542 (5) { ["current_field"]=> int(0) ["field_count"]=> int(35) ["lengths"]=> NULL ["num_rows"]=> int(0) ["type"]=> int(0) } ["_stmt":protected]=> object(mysqli_stmt)#570 (10) { ["affected_rows"]=> int(0) ["insert_id"]=> int(0) ["num_rows"]=> int(0) ["param_count"]=> int(0) ["field_count"]=> int(35) ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["sqlstate"]=> string(5) "00000" ["id"]=> int(8) } ["_adapter":protected]=> *RECURSION* ["_fetchMode":protected]=> int(5) ["_attribute":protected]=> array(0) { } ["_bindColumn":protected]=> array(0) { } ["_bindParam":protected]=> array(0) { } ["_sqlSplit":protected]=> array(1) { [0]=> string(4244) "SELECT ., ., ., ., ., ., ., ., ., ., ., ., ., ., COALESCE(cms_promotile_trans.sourceLocale,cms_promotile_trans_source.sourceLocale) AS , COALESCE(cms_promotile_trans.title,cms_promotile_trans_source.title) AS , COALESCE(cms_promotile_trans.subTitle,cms_promotile_trans_source.subTitle) AS , COALESCE(cms_promotile_trans.linkTitle,cms_promotile_trans_source.linkTitle) AS , COALESCE(cms_promotile_trans.text,cms_promotile_trans_source.text) AS , CASE WHEN COALESCE(cms_promotile_trans.sourceLocale,cms_promotile_trans_source.sourceLocale) != cms_promotile_trans.locale or cms_promotile_trans.translationId IS NULL THEN 1 ELSE 0 END AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS FROM LEFT JOIN ON cms_promotile.id = cms_promotile_trans .id AND cms_promotile_trans.locale= LEFT JOIN AS ON cms_promotile.id = cms_promotile_trans_source.id AND cms_promotile_trans_source.locale=cms_promotile_trans_source.sourceLocale AND (cms_promotile_trans.translationId IS NULL) LEFT JOIN (SELECT ., ., ., ., ., ., ., ., ., ., ., COALESCE(cms_asset_trans.sourceLocale,cms_asset_trans_source.sourceLocale) AS , COALESCE(cms_asset_trans.title,cms_asset_trans_source.title) AS , CASE WHEN COALESCE(cms_asset_trans.sourceLocale,cms_asset_trans_source.sourceLocale) != cms_asset_trans.locale or cms_asset_trans.translationId IS NULL THEN 1 ELSE 0 END AS FROM LEFT JOIN ON cms_asset.id = cms_asset_trans .id AND cms_asset_trans.locale= LEFT JOIN AS ON cms_asset.id = cms_asset_trans_source.id AND cms_asset_trans_source.locale=cms_asset_trans_source.sourceLocale AND (cms_asset_trans.translationId IS NULL)) AS ON cms_promotile.assetId=asset_join.id LEFT JOIN (SELECT ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale) AS , COALESCE(cms_contentobject_trans.title,cms_contentobject_trans_source.title) AS , COALESCE(cms_contentobject_trans.shortTitle,cms_contentobject_trans_source.shortTitle) AS , COALESCE(cms_contentobject_trans.keywords,cms_contentobject_trans_source.keywords) AS , COALESCE(cms_contentobject_trans.subTitle,cms_contentobject_trans_source.subTitle) AS , COALESCE(cms_contentobject_trans.intro,cms_contentobject_trans_source.intro) AS , COALESCE(cms_contentobject_trans.body,cms_contentobject_trans_source.body) AS , CASE WHEN COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale) != cms_contentobject_trans.locale or cms_contentobject_trans.translationId IS NULL THEN 1 ELSE 0 END AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , ., . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , COALESCE(asset_join_cms_asset_trans.sourceLocale,asset_join_cms_asset_trans_source.sourceLocale) AS , COALESCE(asset_join_cms_asset_trans.title,asset_join_cms_asset_trans_source.title) AS , CASE WHEN COALESCE(asset_join_cms_asset_trans.sourceLocale,asset_join_cms_asset_trans_source.sourceLocale) != asset_join_cms_asset_trans.locale or asset_join_cms_asset_trans.translationId IS NULL THEN 1 ELSE 0 END AS FROM LEFT JOIN ON cms_contentobject.id = cms_contentobject_trans .id AND cms_contentobject_trans.locale= LEFT JOIN AS ON cms_contentobject.id = cms_contentobject_trans_source.id AND cms_contentobject_trans_source.locale=cms_contentobject_trans_source.sourceLocale AND (cms_contentobject_trans.translationId IS NULL) LEFT JOIN ON cms_contenttreenode.linkId = cms_contentobject.id LEFT JOIN AS ON cms_contentobject.assetId=asset_join.id AND (asset_join.isActive = 1 ) LEFT JOIN AS ON asset_join.id = asset_join_cms_asset_trans.id AND asset_join_cms_asset_trans.locale= LEFT JOIN AS ON asset_join.id = asset_join_cms_asset_trans_source.id AND asset_join_cms_asset_trans_source.locale=asset_join_cms_asset_trans_source.sourceLocale AND (asset_join_cms_asset_trans.translationId IS NULL) WHERE (cms_contentobject.isActive = 1 )) AS ON cms_promotile.internalLink=co_join.id WHERE (cms_promotile.rel = ) AND (cms_promotile.parent = 105 ) AND (cms_promotile.isActive = 1 ) AND (cms_promotile.typeId = ) ORDER BY . asc" } ["_sqlParam":protected]=> array(1) { [0]=> string(4244) "SELECT ., ., ., ., ., ., ., ., ., ., ., ., ., ., COALESCE(cms_promotile_trans.sourceLocale,cms_promotile_trans_source.sourceLocale) AS , COALESCE(cms_promotile_trans.title,cms_promotile_trans_source.title) AS , COALESCE(cms_promotile_trans.subTitle,cms_promotile_trans_source.subTitle) AS , COALESCE(cms_promotile_trans.linkTitle,cms_promotile_trans_source.linkTitle) AS , COALESCE(cms_promotile_trans.text,cms_promotile_trans_source.text) AS , CASE WHEN COALESCE(cms_promotile_trans.sourceLocale,cms_promotile_trans_source.sourceLocale) != cms_promotile_trans.locale or cms_promotile_trans.translationId IS NULL THEN 1 ELSE 0 END AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS FROM LEFT JOIN ON cms_promotile.id = cms_promotile_trans .id AND cms_promotile_trans.locale= LEFT JOIN AS ON cms_promotile.id = cms_promotile_trans_source.id AND cms_promotile_trans_source.locale=cms_promotile_trans_source.sourceLocale AND (cms_promotile_trans.translationId IS NULL) LEFT JOIN (SELECT ., ., ., ., ., ., ., ., ., ., ., COALESCE(cms_asset_trans.sourceLocale,cms_asset_trans_source.sourceLocale) AS , COALESCE(cms_asset_trans.title,cms_asset_trans_source.title) AS , CASE WHEN COALESCE(cms_asset_trans.sourceLocale,cms_asset_trans_source.sourceLocale) != cms_asset_trans.locale or cms_asset_trans.translationId IS NULL THEN 1 ELSE 0 END AS FROM LEFT JOIN ON cms_asset.id = cms_asset_trans .id AND cms_asset_trans.locale= LEFT JOIN AS ON cms_asset.id = cms_asset_trans_source.id AND cms_asset_trans_source.locale=cms_asset_trans_source.sourceLocale AND (cms_asset_trans.translationId IS NULL)) AS ON cms_promotile.assetId=asset_join.id LEFT JOIN (SELECT ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale) AS , COALESCE(cms_contentobject_trans.title,cms_contentobject_trans_source.title) AS , COALESCE(cms_contentobject_trans.shortTitle,cms_contentobject_trans_source.shortTitle) AS , COALESCE(cms_contentobject_trans.keywords,cms_contentobject_trans_source.keywords) AS , COALESCE(cms_contentobject_trans.subTitle,cms_contentobject_trans_source.subTitle) AS , COALESCE(cms_contentobject_trans.intro,cms_contentobject_trans_source.intro) AS , COALESCE(cms_contentobject_trans.body,cms_contentobject_trans_source.body) AS , CASE WHEN COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale) != cms_contentobject_trans.locale or cms_contentobject_trans.translationId IS NULL THEN 1 ELSE 0 END AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , ., . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , . AS , COALESCE(asset_join_cms_asset_trans.sourceLocale,asset_join_cms_asset_trans_source.sourceLocale) AS , COALESCE(asset_join_cms_asset_trans.title,asset_join_cms_asset_trans_source.title) AS , CASE WHEN COALESCE(asset_join_cms_asset_trans.sourceLocale,asset_join_cms_asset_trans_source.sourceLocale) != asset_join_cms_asset_trans.locale or asset_join_cms_asset_trans.translationId IS NULL THEN 1 ELSE 0 END AS FROM LEFT JOIN ON cms_contentobject.id = cms_contentobject_trans .id AND cms_contentobject_trans.locale= LEFT JOIN AS ON cms_contentobject.id = cms_contentobject_trans_source.id AND cms_contentobject_trans_source.locale=cms_contentobject_trans_source.sourceLocale AND (cms_contentobject_trans.translationId IS NULL) LEFT JOIN ON cms_contenttreenode.linkId = cms_contentobject.id LEFT JOIN AS ON cms_contentobject.assetId=asset_join.id AND (asset_join.isActive = 1 ) LEFT JOIN AS ON asset_join.id = asset_join_cms_asset_trans.id AND asset_join_cms_asset_trans.locale= LEFT JOIN AS ON asset_join.id = asset_join_cms_asset_trans_source.id AND asset_join_cms_asset_trans_source.locale=asset_join_cms_asset_trans_source.sourceLocale AND (asset_join_cms_asset_trans.translationId IS NULL) WHERE (cms_contentobject.isActive = 1 )) AS ON cms_promotile.internalLink=co_join.id WHERE (cms_promotile.rel = ) AND (cms_promotile.parent = 105 ) AND (cms_promotile.isActive = 1 ) AND (cms_promotile.typeId = ) ORDER BY . asc" } ["_queryId":protected]=> NULL } ["_defaultStmtClass":protected]=> string(24) "Zend_Db_Statement_Mysqli" ["_config":protected]=> array(8) { ["host"]=> string(9) "localhost" ["username"]=> string(15) "awardonl_dbuser" ["password"]=> string(12) "EUI}b1!IcK8n" ["dbname"]=> string(16) "awardonl_website" ["charset"]=> NULL ["persistent"]=> bool(false) ["options"]=> array(3) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) ["fetchMode"]=> int(2) } ["driver_options"]=> array(0) { } } ["_fetchMode":protected]=> int(5) ["_profiler":protected]=> object(Zend_Db_Profiler)#76 (4) { ["_queryProfiles":protected]=> array(0) { } ["_enabled":protected]=> bool(false) ["_filterElapsedSecs":protected]=> NULL ["_filterTypes":protected]=> NULL } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(mysqli)#77 (19) { ["affected_rows"]=> int(10) ["client_info"]=> string(15) "10.0.31-MariaDB" ["client_version"]=> int(100031) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(6) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(15) "10.0.32-MariaDB" ["server_version"]=> int(100032) ["stat"]=> string(154) "Uptime: 1638775 Threads: 3 Questions: 180739258 Slow queries: 30 Opens: 4163022 Flush tables: 1809 Open tables: 400 Queries per second avg: 110.289" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(2327630) ["warning_count"]=> int(0) } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } ["_parts":protected]=> array(11) { ["distinct"]=> bool(false) ["columns"]=> array(43) { [0]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(2) "id" [2]=> NULL } [1]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(6) "typeId" [2]=> NULL } [2]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(8) "isActive" [2]=> NULL } [3]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(7) "urlPath" [2]=> NULL } [4]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "publishDate" [2]=> NULL } [5]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(10) "expiryDate" [2]=> NULL } [6]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "dateCreated" [2]=> NULL } [7]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "createdById" [2]=> NULL } [8]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "dateModified" [2]=> NULL } [9]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "modifiedById" [2]=> NULL } [10]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(6) "status" [2]=> NULL } [11]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(8) "featured" [2]=> NULL } [12]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(4) "home" [2]=> NULL } [13]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(9) "sortOrder" [2]=> NULL } [14]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(7) "assetId" [2]=> NULL } [15]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(15) "commentsEnabled" [2]=> NULL } [16]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(17) "commentsModerated" [2]=> NULL } [17]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(18) "commentsExpiryDate" [2]=> NULL } [18]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(14) "ratingsEnabled" [2]=> NULL } [19]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "ratingsCount" [2]=> NULL } [20]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(10) "ratingsAvg" [2]=> NULL } [21]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(17) "ratingsExpiryDate" [2]=> NULL } [22]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "voteEnabled" [2]=> NULL } [23]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(9) "voteCount" [2]=> NULL } [24]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(14) "voteExpiryDate" [2]=> NULL } [25]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(8) "cssClass" [2]=> NULL } [26]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(5) "cssId" [2]=> NULL } [27]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(13) "submittedById" [2]=> NULL } [28]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(7) "indexed" [2]=> NULL } [29]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "hasChildren" [2]=> NULL } [30]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(14) "showInPageTree" [2]=> NULL } [31]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(11) "migrationId" [2]=> NULL } [32]=> array(3) { [0]=> string(17) "cms_contentobject" [1]=> string(12) "migrationUrl" [2]=> NULL } [33]=> array(3) { [0]=> string(23) "cms_contentobject_trans" [1]=> string(13) "translationId" [2]=> NULL } [34]=> array(3) { [0]=> string(23) "cms_contentobject_trans" [1]=> string(6) "locale" [2]=> NULL } [35]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#534 (1) { ["_expression":protected]=> string(90) "COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale)" } [2]=> string(12) "sourceLocale" } [36]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#525 (1) { ["_expression":protected]=> string(76) "COALESCE(cms_contentobject_trans.title,cms_contentobject_trans_source.title)" } [2]=> string(5) "title" } [37]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#677 (1) { ["_expression":protected]=> string(86) "COALESCE(cms_contentobject_trans.shortTitle,cms_contentobject_trans_source.shortTitle)" } [2]=> string(10) "shortTitle" } [38]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#711 (1) { ["_expression":protected]=> string(82) "COALESCE(cms_contentobject_trans.keywords,cms_contentobject_trans_source.keywords)" } [2]=> string(8) "keywords" } [39]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#727 (1) { ["_expression":protected]=> string(82) "COALESCE(cms_contentobject_trans.subTitle,cms_contentobject_trans_source.subTitle)" } [2]=> string(8) "subTitle" } [40]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#754 (1) { ["_expression":protected]=> string(76) "COALESCE(cms_contentobject_trans.intro,cms_contentobject_trans_source.intro)" } [2]=> string(5) "intro" } [41]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#599 (1) { ["_expression":protected]=> string(74) "COALESCE(cms_contentobject_trans.body,cms_contentobject_trans_source.body)" } [2]=> string(4) "body" } [42]=> array(3) { [0]=> string(30) "cms_contentobject_trans_source" [1]=> object(Zend_Db_Expr)#732 (1) { ["_expression":protected]=> string(201) "CASE WHEN COALESCE(cms_contentobject_trans.sourceLocale,cms_contentobject_trans_source.sourceLocale) != cms_contentobject_trans.locale or cms_contentobject_trans.translationId IS NULL THEN 1 ELSE 0 END" } [2]=> string(13) "isTranslation" } } ["union"]=> array(0) { } ["from"]=> array(3) { ["cms_contentobject"]=> array(4) { ["joinType"]=> string(4) "from" ["schema"]=> NULL ["tableName"]=> string(17) "cms_contentobject" ["joinCondition"]=> NULL } ["cms_contentobject_trans"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(23) "cms_contentobject_trans" ["joinCondition"]=> string(90) "cms_contentobject.id = cms_contentobject_trans .id AND cms_contentobject_trans.locale='en'" } ["cms_contentobject_trans_source"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(23) "cms_contentobject_trans" ["joinCondition"]=> string(194) "cms_contentobject.id = cms_contentobject_trans_source.id AND cms_contentobject_trans_source.locale=cms_contentobject_trans_source.sourceLocale AND (cms_contentobject_trans.translationId IS NULL)" } } ["where"]=> array(1) { [0]=> string(33) "(cms_contentobject.isActive = 1 )" } ["group"]=> array(0) { } ["having"]=> array(0) { } ["order"]=> array(0) { } ["limitcount"]=> NULL ["limitoffset"]=> NULL ["forupdate"]=> bool(false) } ["_tableCols":protected]=> array(0) { } }

The Communications Council today announces the first set of finalists in the 35th AWARD Awards, across four categories: Film & Video, Craft in Film, Radio and Design.

The Communications Council today announces the first set of finalists in the 35th AWARD Awards, across four categories: Film & Video, Craft in Film, Radio and Design.

The full list of finalists can be accessed here.

Agencies with the most finalists in a category include Clemenger BBDO for Film & Video, The Sweet Shop for Craft in Film, DDB Sydney for Radio, and Re in Design.

Chairmen in each of the categories were: Steve Cochran (Colenso BBDO) for Film & Video, Paul Middleditch (Plaza Films) for Craft in Film, Paul Reardon (Whybin\TBWA) for Radio, and Michaela Webb (Round Studio) for Design.

Finalists for additional categories will be announced upon completion of judging. 

The awards presentation event will take place on Thursday 25th March at Sydney Town Hall, in Sydney. Tickets are available here.

AWARD thanks all Judges for their time and dedication to the awards. A full list of judges can be found here.