SQL суроо жазып, видео таблицасынан эң кыска 10 видеонун ичинен эң узун видеону табыңыз (id, узактык, автор_ид).
with sbq as (
select id, duration, author_id
from video
order by duration
limit 10
)
select id, duration, author_id
from sbq
order by duration DESC
limit 1
select id, duration, author_id
from video
order by duration
limit 1
offset 9
shortest = Video.objects.order_by('duration').values('id')[:10][-1]
result = Video.objects.filter(id__in=Subquery(shortest)).order_by("-duration").first()
