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

 

转载于:https://www.cnblogs.com/CyLee/p/5594636.html