request:
SELECT
          jp_weblog_content.*,
          jp_weblog_content.date as mysql_date,
          DATE_FORMAT(jp_weblog_content.date, '%c') AS month,
          DATE_FORMAT(jp_weblog_content.date, '%Y') AS year,
          UNIX_TIMESTAMP(jp_weblog_content.date) AS date
          FROM jp_weblog_content
          LEFT JOIN jp_weblog_catassign 
           ON jp_weblog_content.id = jp_weblog_catassign.content_id
            WHERE jp_weblog_catassign.cat_id = '6'
            AND YEAR(jp_weblog_content.date) = '2011'
          ORDER BY mysql_date DESC;
response:
Disk full (/tmp/#sql-temptable-35b-4c0-b3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Errorcode: 1021