Monthly Archive
-
The Author:
- Email:
mil[at]cantonese.hk - Location:
Hong Kong
- Email:
-
Categories:
- Cantonese (39)
- Hong Kong (5)
- Language (10)
- Learning (20)
- MP3 - Monologues (22)
- Transcripts (3)
-
Archives:
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
med-tech solutions med-tech solutions forum