SELECT sum( a ) FROM ( SELECT s.num * w.width * w.length AS a FROM what w LEFT JOIN star s ON w.sid = s.sid ) WHERE s.`name` = 'mark' GROUP BY w.sid ORDER BY w.time DESC ) aa