如何查询同时包含多个指定标签的文章

SELECT article_id FROM (
    SELECT article_id, GROUP_CONCAT(tag_id ORDER BY tag_id) tag_ids
    FROM articles_tags
    WHERE article_id in (1, 2, 3)
    GROUP BY article_id
) t WHERE tag_ids LIKE '%1,2,3%';

SELECT at1.article_id
FROM articles_tags at1
JOIN articles_tags at2 ON at1.article_id = at2.article_id AND at2.tag_id = 2
JOIN articles_tags at3 ON at1.article_id = at3.article_id AND at3.tag_id = 3
WHERE at1.tag_id = 1

SELECT article_id
FROM articles_tags
WHERE tag_id in (1, 2, 3)
GROUP BY article_id
HAVING COUNT(*) = 3