SELECT *, MIN(DATE_FORMAT(publish_date,'%Y')) AS year FROM issue WHERE issue_magazine_id = 2 GROUP BY DATE_FORMAT(publish_date,'%Y') ORDER BY year DESCDisk full (/tmp/#sql_22ea_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")