Mysql合并两个查询

Question

select sira, count(sira) c from mesajlar
group by sira
order by c desc
limit 20;

SELECT `baslik` FROM `konular` WHERE `id` = ??SIRA??

我想将这两个查询结合起来。

我有一张桌子，名叫美甲和魔芋。我想得到最常见的20个值的'sira‘从美容院。然后，我想在第二个查询中使用这些值。

怎么做？

Answer 1

试试这个：

SELECT
    konular.baslik
    ,m.c
FROM
    (
        SELECT
            sira,
            count(sira) c
        FROM
            mesajlar
        GROUP BY
            sira
        ORDER BY
            c DESC
        LIMIT 20
    ) m
        INNER JOIN konular
            ON konular.id = m.sira