findAllByPipelineId

@Query(value = "SELECT d FROM Deal d WHERE d.stageId IN (SELECT s.id FROM Stage s WHERE s.pipelineId = :pipelineId)")
abstract fun findAllByPipelineId(pipelineId: String): List<Deal>(source)