Ayuda SELECT.. LIKE

[jurena]

SELECT a.id, COUNT(DISTINCT c.tag) FROM imagenes AS a
inner JOIN imagenes_tags AS b ON a.id = b.img_id
inner JOIN indice_tags AS c ON b.tag_id = c.id
WHERE c.tag IN('árboles','hojas','rojas')
GROUP BY b.img_id HAVING COUNT(distinct c.tag) >= 3

Algo así: no lo he probado