complex mysql query to convert to django orm quersety with performance increase

hello I have a function that does multiple queries n+1 / I need a performance optimization because it takes too much time and need to be refactored with django orm

this function is to be refactored from mysql syntax to django orm queryset syntax

only apply if you really have years experience in django mysql and if you are expert with django orm queries

dont waste my time and yours I will screen you out easily

if you dont know what is prefetch_related or select_related do not waste my time and yours with all due respect

time line 1d or less , it is urgent

budget 100$ no more.