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(106) [1]=> &string(20) "Award.Award.NewsPost" [2]=> &string(32) "/news/award-awards-finalists-106" [3]=> &string(43) "AWARD Awards 3rd Set of Finalists Announced" } ["_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: 1638767 Threads: 2 Questions: 180731498 Slow queries: 30 Opens: 4162979 Flush tables: 1809 Open tables: 400 Queries per second avg: 110.285" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(2327615) ["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` = 106 )" } ["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=106) 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=106) 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: 1638767 Threads: 2 Questions: 180731524 Slow queries: 30 Opens: 4162979 Flush tables: 1809 Open tables: 400 Queries per second avg: 110.285" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(2327615) ["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 = 106 ) 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 = 106 ) 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: 1638767 Threads: 2 Questions: 180731536 Slow queries: 30 Opens: 4162979 Flush tables: 1809 Open tables: 400 Queries per second avg: 110.285" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(2327615) ["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 = 106 ) 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 = 106 ) 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: 1638767 Threads: 2 Questions: 180731548 Slow queries: 30 Opens: 4162979 Flush tables: 1809 Open tables: 400 Queries per second avg: 110.285" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(2327615) ["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 third set of finalists in the 35th AWARD Awards, across four categories: Direct Marketing, Print, Poster & Outdoor, and Print Craft.

The Communications Council today announces the third set of finalists in the 35th AWARD Awards, across four categories: Direct Marketing, Print, Poster & Outdoor, and Print Craft.

A full list of finalists to date can be accessed here

Agencies with the most finalists in a category include BMF Advertising Sydney and DDB Group New Zealand for Direct Marketing, Creative Juice\Bangkok for Print, Leo Burnett Sydney for Poster & Outdoor, and Clemenger BBDO Melbourne and Droga5 for Print Craft.

Chairmen in each of the categories were: Steve Coll (Havas Worldwide) for Direct Marketing, Ben Welsh (M&C Saatchi) for Print and Poster & Outdoor, and Grant Rutherford (Publicis Mojo) for Print Craft.

The last set of finalists will be announced upon completion of judging on 24th March. 

The awards presentation event will take place on Thursday 27th 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.