inner_join_subquery.sql

SELECT s.* FROM services s
    INNER JOIN (
    	SELECT st.service_id FROM services_typetags st
    		INNER JOIN services s ON s.id = st.service_id
    		INNER JOIN typetags t ON t.id = st.typetag_id
    		WHERE t.id IN (8, 9, 11)
    		GROUP BY st.service_id
    		HAVING COUNT(st.service_id) = 3
    ) ss
ON s.id = ss.service_id

Here we want to filter using the services_typetags n:m relation and have all services returned, which have at least the typetags 8, 9 and 11.