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

Transcripts

Archived Posts from this Category

Sat 4 Aug 2007

Transcript: Sweet and sour friendship

Posted by 馬先生 under Transcripts
[7] Comments


Download - 10:21min

Read Transcript
Read Transcript

 

Sun 15 Apr 2007

Transcript: Chinese New Year

Posted by 馬先生 under Transcripts
[3] Comments

I decided to have a go at writing a transcript of a video clip I found on Youtube. I thought there were lots of useful vocabulary and structure that I should remember for next year.

Video: 3:28min
Chinese New Year

 
Read Transcript
Read Transcript

 

Thu 22 Feb 2007

Transcript: Little Librarian

Posted by 馬先生 under Transcripts
[9] Comments


Download - 09:38min

Read Transcript
Read Transcript