SELECT yak_portal_news.news_key As News_Key ,(yak_portal_news.news_type) As News_Type,(yak_portal_news.last_modified) As News_LastModified,(yak_portal_news.is_fullpage) As Is_FullPage,(yak_portal_news.is_html_menu) As Is_HtmlMenu,(yak_portal_news.credit_value) As Credit_Value,(yak_portal_news_last_hits.hit_count) As Hit_Count,(yak_portal_news.longitude) As Longitude,(yak_portal_news.latitude) As Latitude,(yak_portal_news.date_event_begin) As Date_EventBegin,(yak_portal_news.date_event_end) As Date_EventEnd,(yak_portal_news.date_posted) As Date_Posted,(yak_portal_news.date_visible) As Date_Visible,(yak_portal_news.posted_by_id) As Posted_ById,(yak_portal_news.display_only_for_language) As Display_Only_For_Language,(IFNULL(yak_portal_news_content.associated_domain_name,yak_portal_news.associated_domain_name)) As Associated_Domain_Name,(yak_portal_news_content.language) As Language,(yak_portal_news_content.keywords) As Keywords,(yak_portal_news_content.last_modified) As NewsContent_LastModified,(yak_portal_news_content_runtime.title) As TitleRuntime,(yak_portal_news_content_runtime.header) As HeaderRuntime,(yak_portal_news_content_runtime.content) As ContentRuntime,(yak_portal_news_content_runtime.title_html_menu) As TitleHtmlMenuRuntime,(yak_portal_news_content_runtime.title_html_menu_rollover) As TitleHtmlMenuRolloverRuntime,(yak_portal_news_content_runtime.title_html_menu_selected) As TitleHtmlMenuSelectedRuntime,(yak_portal_news_content.content) As ContentSource FROM (SELECT yak_portal_news.news_key FROM yak_portal_news LEFT JOIN yak_acl ON yak_portal_news.news_key = yak_acl.item_key WHERE is_visible='1' AND ( is_validated='1' ) AND news_type IN ('dynamic') AND (TO_DAYS(NOW()) - TO_DAYS(IFNULL(date_visible,date_posted)) <= '36500') AND ( yak_acl.component_name='webportal' AND yak_acl.item_type='news' ) AND (date_visible IS NULL OR date_visible <= NOW()) AND (display_only_for_language IS NULL OR display_only_for_language='english' ) GROUP BY yak_portal_news.news_key ORDER BY IFNULL(date_visible,date_posted) DESC LIMIT 0,200 ) As q1 LEFT JOIN yak_portal_news ON yak_portal_news.news_key = q1.news_key LEFT JOIN yak_portal_news_content ON yak_portal_news_content.news_key = q1.news_key LEFT JOIN yak_portal_news_content_runtime ON (yak_portal_news_content_runtime.news_key = yak_portal_news_content.news_key AND yak_portal_news_content_runtime.language = yak_portal_news_content.language ) LEFT JOIN yak_portal_news_last_hits ON (yak_portal_news_last_hits.news_key = yak_portal_news_content.news_key AND yak_portal_news_last_hits.language = yak_portal_news_content.language ) LEFT JOIN yak_portal_languages ON yak_portal_news_content.language = yak_portal_languages.language LEFT JOIN yak_portal_languages_priority ON yak_portal_news_content.language = yak_portal_languages_priority.language WHERE IFNULL(yak_portal_languages.is_active,'1')='1' AND IFNULL(current_language,'english') = 'english' AND yak_portal_languages_priority.priority = (SELECT MIN(yak_portal_languages_priority.priority) FROM yak_portal_news_content LEFT JOIN yak_portal_languages ON yak_portal_news_content.language=yak_portal_languages.language LEFT JOIN yak_portal_languages_priority ON yak_portal_news_content.language=yak_portal_languages_priority.language WHERE yak_portal_news_content.news_key =yak_portal_news.news_key AND current_language='english' AND yak_portal_languages.is_active='1') GROUP BY yak_portal_news.news_key ORDER BY IFNULL(date_visible,date_posted) DESC
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'YAK_moncv.yak_portal_news_last_hits.hit_count' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by