countUnfinishedNormalPipelineTasks
@Query(value = "
select count(*)
from task t
join task_type tt on tt.id = t.type_id
where
t.pipeline_task_id = :pipelineTaskId and
tt.category = 10 and
t.running_status < 50
", nativeQuery = true)