tp3.23拼接sql语句

Question

问题描述

想问下这条语句 怎么样用thinkphp3.23框架 拼接出来sql语句

sql语句

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

Answer 1

直接在框架列M('')->query(sql语句放进来)。就不用拼接了