genres.sql

SELECT p.*
FROM projects AS p
JOIN genres_projects AS gp
  ON (gp.project_id = p.id)
JOIN genres AS g
  ON (gp.genre_id = g.id)
WHERE g.name IN ('Drama', 'Comedy')
GROUP BY p.id