Disk full (/tmp/#sql_837_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")[SQL]select * from ( select c.*,m.face,m.nickname from `comment` c
            left join members m on c.memberID=m.memberID where 1 AND type='shop' AND isPub='0' AND c.typeID='1' AND c.siteID=1 ORDER BY  created DESC  ) as _table   GROUP BY  companyID ORDER BY  created DESC  LIMIT 5