SELECT
ql.id as id,
ql.label_name as labelName,
count(qs.id) as qrcodeNum
FROM
qrcode_label ql
LEFT JOIN
label_qrcode_link lql
ON
ql.id=lql.qrocde_label_id
LEFT JOIN
(SELECT * FROM qrcode_struct qs
where qs.delete_flag=0) qs
ON
lql.qrcode_struct_id = qs.id
where
ql.lable_name like "%标签%"
group by
ql.id
order by
ql.id
desc
注意:关联查询中数据条数缺少的问题
优化:现将数据量大的表,满足条件的数据查询出来,创建临时表,再去关联这个临时表