SELECT b.lst_id,b.mem_id,b.title,b.description,b.posted,c.posted, MAX(c.posted) as last_com FROM lists_comments as c JOIN lists as b ON c.lst_id=b.lst_id WHERE b.restricted='0' AND b.featured='1' GROUP BY c.lst_id ORDER BY last_com DESC LIMIT 0,5:Disk full (/var/tmp/#sql_fb55_2); waiting for someone to free some space...