多表联查进行数据统计

懒人w

于 2023-06-19 14:10:06 发布

阅读量134

点赞数

分类专栏：随笔工作记录文章标签： java 开发语言

本文链接：https://blog.csdn.net/weixin_45049746/article/details/131286721

版权

工作记录同时被 2 个专栏收录

30 篇文章 0 订阅

订阅专栏

随笔

19 篇文章 0 订阅

订阅专栏

多表联查进行数据统计时，建议使用子查询，否则统计的数据不准确

    <select id="selectLnCensusArticleList" parameterType="LnArticle" resultMap="LnArticleResult">
        SELECT
        (select count(lc.collection_id) from  ln_collection lc where lc.collection_id = la.id and lc.type = 'article') collectionCount,
        (select count(lac.article_id) from  ln_article_comment lac where lac.article_id = la.id) commentCount,
        (select count(lsl.support_id) from  ln_support_log lsl where lsl.support_id = la.id and lsl.type = 'article') supportCount,
        (select count( lab.browse_id) from  ln_browse lab where lab.browse_id = la.id and lab.type = 'article') browseCount,
        (select count(lar.reward_id) from  ln_article_reward lar where lar.reward_id = la.id ) rewardCount,
        la.*
        FROM
        ln_article la
        <where>
            <if test="title != null  and title != ''"> and la.title like concat('%', #{title}, '%')</if>
        </where>
    </select>