<!--分页查询-->
<select id="pageByQuery" resultType="com.boyia.magic.lxt.api.vo.AppsGroupVo">
SELECT
t1.id,
t1.group_name,
t1.remark,
t1.create_by,
t1.create_time,
t1.status,
COUNT(t2.apps_id) AS appsCount
FROM
lxt_platform_apps_group AS t1
LEFT JOIN lxt_platform_apps_group_relation AS t2 ON t2.apps_id = t1.id
WHERE
t1.del_flag = '0'
<if test="query.groupName != null and query.groupName != ''">
AND t1.group_name LIKE CONCAT(CONCAT('%', #{query.groupName}), '%')
</if>
GROUP BY
t1.id
ORDER BY
t1.rank_weight
ASC
</select>
关键
COUNT(t2.apps_id) AS appsCount
按照关联的 t2 表的主键数量进行计数。
- t2.apps_id:t2表的主键。
- appsCount:接收数据的字段(用于接收数据的对象字段)。
GROUP BY t1.id
按照 t1 表的主键进行分组,目的是将多条的关联关系聚集。 - t1.id:t1表的主键。