[求教]复杂查询时，Active Record 类的用法

hh2hh

请教如下的sql，用Active Record应该怎么写？

SQL复制代码

 
SELECT sc.*, si.ExtendCode AS ExtendCode2
FROM (SELECT * FROM table1
    WHERE (OwnerID = '143') AND (isDraft = 0)) AS sc LEFT OUTER JOIN
    (SELECT DISTINCT ExtendCode FROM table2) AS si
    ON sc.ExtendCode = si.ExtendCode
ORDER BY sc.LastUpdate DESC
 

复制代码

Hex

这么复杂的 SQL 用 AR 没必要吧，恐怕 AR 做不到。
Active Record 和 SQL 不是一一对应的，复杂 SQL AR 做不出来。