WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'cantehk_wrdp1.wp_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
Download - 01:00min
Produced by: 馬太太
Transcribed by: 鄺慧明
上個月一艘烏克蘭嘅大型補給船同一艘中國貨船相撞之後沉沒，除咗七個船員獲救之外，十八個船員失蹤。
soeng6 go3 jyut6 jat1 sau2 wu1 hak1 laan4 ge3 daai6 jing4 bou2 kap1 syun4 tung4 jat1 sau2 zung1 gwok3 fo3 syun4 soeng1 zong6 zi1 hau6 cam4 mut6, ceoi4 zo2 cat1 go3 syun4 jyun4 wok6 gau3 zi1 ngoi6, sap6 baat3 go3 syun4 jyun4 sat1 zung1.
Last month, a large Ukrainian supply […]
Hong KongWordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'cantehk_wrdp1.wp_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC