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

Archive for May, 2009

Monday, May 25th, 2009

3.5 years learning

Hope you can understand… just talking out of my head without any rehearsal. I know I sound very foreign, but at least I tried.

7 Comments » - Posted in Learning by 馬先生

Tuesday, May 19th, 2009

Greg Smith - Cantonese speaking Westerner

I don’t normally watch Pearl, however, I unintentionally came across a great video of Greg Smith who has lived in Hong Kong for 2 decades. After watching it on TV, I downloaded it from RTHK website, and then uploaded to Youtube for your enjoyment. Coincidentally, I think he looks like 大山 a famous Beijing […]

4 Comments » - Posted in Cantonese by 馬先生