ИХ
Size: a a a
ИХ
AD
AD
ИХ
عأ
AD
ИХ
Н
orders = OrderCleaner.objects.filter(
order__when_go_datetime__date__gte=start_date,
order__when_go_datetime__date__lte=end_date
).values("cleaner").annotate(count=Count('id')).order_by()
orders_subquery = orders.filter(cleaner=OuterRef('id'))
qs = User.objects.filter(role=UserRoles.CLEANER).annotate(
many_orders_count=Sum(Subquery(orders_subquery.values('count')), output_field=IntegerField())
)
SELECT "users_user"."id",
"users_user"."password",
"users_user"."last_login",
"users_user"."is_superuser",
"users_user"."is_staff",
"users_user"."is_active",
"users_user"."date_joined",
"users_user"."user_identifier",
"users_user"."username",
"users_user"."first_name",
"users_user"."last_name",
"users_user"."patronymic",
"users_user"."email",
"users_user"."is_blocked",
"users_user"."role",
"users_user"."photo",
"users_user"."last_ip",
"users_user"."get_email_messages",
"users_user"."rating",
"users_user"."about_me",
"users_user"."show_on_site",
"users_user"."on_line",
"users_user"."checked",
"users_user"."client_bonus",
"users_user"."cleaner_money",
"users_user"."invited_by_id",
"users_user"."joined_in_cleaner_app",
"users_user"."last_activity_time",
"users_user"."registration_date",
"users_user"."manager_comment",
"users_user"."phone",
"users_user"."birthday",
"users_user"."citizenship",
"users_user"."nearest_metro",
"users_user"."tshirt_size",
"users_user"."gender",
"users_user"."work_experience",
"users_user"."card_number",
"users_user"."bank_name",
"users_user"."passport_scan",
"users_user"."personal_photo",
"users_user"."registration_scan",
"users_user"."snils_scan",
SUM((SELECT Count(U0."id") AS "count"
FROM "orders_ordercleaner" U0
inner join "orders_order" U1
ON ( U0."order_id" = U1."id" )
WHERE ( ( U1."when_go_datetime" ) :: DATE >= 2021 - 04 - 24
AND ( U1."when_go_datetime" ) :: DATE <= 2021 - 05 - 24
AND U0."cleaner_id" = "users_user"."id" )
GROUP BY U0."cleaner_id")) AS "many_orders_count"
FROM "users_user"
WHERE "users_user"."role" = cleaner
GROUP BY "users_user"."id"
AD
AD
DT
1
ИХ
AD
1
AD
1