modicio/modic.io.repository/FragmentRepository/findMostRecentFragmentByVariantIDLazy

findMostRecentFragmentByVariantIDLazy

@Query(value = "SELECT DISTINCT ON (running_time, variantID) * from Fragment f WHERE f.variantID = :variantID AND running_time = ( SELECT MAX(running_time) FROM Fragment f1 WHERE f1.variantID = :variantID) AND f.open = :isOpen ORDER BY running_time DESC, variantID LIMIT 1", nativeQuery = true)
abstract fun findMostRecentFragmentByVariantIDLazy(@Param(value = "variantID") variantID: String, @Param(value = "isOpen") isOpen: Boolean = false): Fragment?