mysql 再查詢結果的基礎上查詢（子查詢）

標籤：

---恢複內容開始---

 SELECT A.wx_name, A.wx_litpic, B . *                                         FROM (                                        SELECT uid, COUNT( * ) AS daticishu                                        FROM statements                                        WHERE TYPE IN ( 5, 7 )                                         AND flag =  ‘1‘                                        GROUP BY uid                                        ORDER BY COUNT( * ) DESC                                         LIMIT 20                                        ) AS B                                        JOIN user AS A ON uid = openid                                        LIMIT 0 , 20

 

---恢複內容結束---

mysql 再查詢結果的基礎上查詢（子查詢）