Re: 3 tables joined with where clause

[Ibram N.]

So I need two queries? I found a solution with sub queries :

SELECT
c.id, c.title as title, CONCAT(GROUP_CONCAT(ta.tag)) as tags
FROM db_Content as c
LEFT JOIN db_ContentTag as ct ON ct.content_id = c.id
LEFT JOIN db_Tag as ta ON ta.id = ct.tag_id
WHERE
c.id IN (
SELECT ContentTag.content_id FROM ContentTag WHERE ContentTag.tag_id IN (
SELECT GROUP_CONCAT(Tag.id) FROM Tag WHERE Tag.tag LIKE '%agA%'
)
)
GROUP BY 1


it seems to work perpectly but it's a bit heavy. Do you have an idea to clean it ?