Queries

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."InvoiceUnit"."total" FROM "public"."InvoiceUnit" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."InvoiceUnit"."invoiceId") WHERE (($3=$4 AND ("j0"."id" IS NOT NULL)) AND "public"."InvoiceUnit"."examinationId" = $1) OFFSET $2 /* traceparent='00-73e9a1e8b42a96e6e4e0f646bde40bda-bbe5907469d210f8-01' */) AS "sub"

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."Order" AS "j0" ON ("j0"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."Session" AS "j1" ON ("j1"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("public"."Invoice"."id") WHERE (("j0"."patientProfileId" = $1 AND ("j0"."id" IS NOT NULL)) OR ("j1"."patientProfileId" = $2 AND "j1"."status" <> CAST($3::text AS "public"."SessionStatus") AND ("j1"."date" IS NULL OR "j1"."date" <= $4) AND ("j1"."id" IS NOT NULL)) OR ("j2"."patientProfileId" = $5 AND "j2"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND "j2"."startDate" <= $7 AND ("j2"."id" IS NOT NULL))) OFFSET $8 /* traceparent='00-f6556dfe566619fb95dfd86be505cc4d-809f4c79fcee0fec-01' */) AS "sub" /* traceparent='00-f6556dfe566619fb95dfd86be505cc4d-809f4c79fcee0fec-01' */

SELECT SUM("restNotPaid") AS "_sum$restNotPaid" FROM (SELECT "public"."Invoice"."restNotPaid" FROM "public"."Invoice" LEFT JOIN "public"."Order" AS "j0" ON ("j0"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."Session" AS "j1" ON ("j1"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("public"."Invoice"."id") WHERE (("j0"."patientProfileId" = $1 AND ("j0"."id" IS NOT NULL)) OR ("j1"."patientProfileId" = $2 AND "j1"."status" <> CAST($3::text AS "public"."SessionStatus") AND ("j1"."date" IS NULL OR "j1"."date" <= $4) AND ("j1"."id" IS NOT NULL)) OR ("j2"."patientProfileId" = $5 AND "j2"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND "j2"."startDate" <= $7 AND ("j2"."id" IS NOT NULL))) OFFSET $8 /* traceparent='00-791567810990e2bc32e82084af5cbf28-21048d35d8f2a40b-01' */) AS "sub" /* traceparent='00-791567810990e2bc32e82084af5cbf28-21048d35d8f2a40b-01' */

SELECT SUM("restNotPaid") AS "_sum$restNotPaid" FROM (SELECT "public"."Invoice"."restNotPaid" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("public"."Invoice"."id") WHERE (("j0"."patientProfileId" = $1 AND "j0"."status" <> CAST($2::text AS "public"."SessionStatus") AND "j0"."date" > $3 AND ("j0"."id" IS NOT NULL)) OR ("j1"."patientProfileId" = $4 AND "j1"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND "j1"."startDate" > $6 AND ("j1"."id" IS NOT NULL))) OFFSET $7 /* traceparent='00-791567810990e2bc32e82084af5cbf28-ecb4441b2bf1b524-01' */) AS "sub" /* traceparent='00-791567810990e2bc32e82084af5cbf28-ecb4441b2bf1b524-01' */

SELECT "public"."UniqueText"."id", "public"."UniqueText"."type"::text, "public"."UniqueText"."text", "public"."UniqueText"."clinicDomain", "public"."UniqueText"."createdAt", "public"."UniqueText"."updatedAt" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."text" ILIKE $2 AND "public"."UniqueText"."clinicDomain" = $3) ORDER BY "public"."UniqueText"."createdAt" DESC LIMIT $4 OFFSET $5 /* traceparent='00-2bc4dd2c659c489355bf5a3749c45ef3-6977fe0835fcc6b6-01' */

CREATE INDEX CONCURRENTLY ON UniqueText (clinicDomain, type)

Rows: 145441
Row progression: 145441, 641, 6

Row estimates
- clinicDomain (=): 641
- type (=): 1276
- text (~~*): 14544
- createdAt (sort): 1

Existing indexes
- id PRIMARY
- text, clinicDomain, type UNIQUE

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."UniqueText"."id" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."text" ILIKE $2 AND "public"."UniqueText"."clinicDomain" = $3) OFFSET $4 /* traceparent='00-2bc4dd2c659c489355bf5a3749c45ef3-61ff011f57eea51d-01' */) AS "sub" /* traceparent='00-2bc4dd2c659c489355bf5a3749c45ef3-61ff011f57eea51d-01' */

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("public"."Invoice"."id") WHERE (("j0"."patientProfileId" = $1 AND "j0"."status" <> CAST($2::text AS "public"."SessionStatus") AND "j0"."date" > $3 AND ("j0"."id" IS NOT NULL)) OR ("j1"."patientProfileId" = $4 AND "j1"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND "j1"."startDate" > $6 AND ("j1"."id" IS NOT NULL))) OFFSET $7 /* traceparent='00-f6556dfe566619fb95dfd86be505cc4d-12b743fb2995efb6-01' */) AS "sub" /* traceparent='00-f6556dfe566619fb95dfd86be505cc4d-12b743fb2995efb6-01' */

SELECT "public"."Session"."id", "public"."Session"."patientProfileId", "public"."Session"."doctorId", "public"."Session"."assistantId", "public"."Session"."referralDoctorId", "public"."Session"."number", "public"."Session"."date", "public"."Session"."from", "public"."Session"."to", "public"."Session"."shiftId", "public"."Session"."note", "public"."Session"."totalTimeInSec", "public"."Session"."clinicDomain", "public"."Session"."isWhatsAppNotificationSentHour", "public"."Session"."isWhatsAppNotificationSentTenMin", "public"."Session"."isPatientInWaitingRoom", "public"."Session"."patientInWaitingRoomFrom", "public"."Session"."startTime", "public"."Session"."endTime", "public"."Session"."order", "public"."Session"."timeType"::text, "public"."Session"."status"::text, "public"."Session"."branchId", "public"."Session"."createdAt", "public"."Session"."updatedAt", "public"."Session"."packageSubscriptionId", "public"."Session"."link", "public"."Session"."confirmedAt", "public"."Session"."specialty"::text, "public"."Session"."cancellationReason", "public"."Session"."cancellationDate", "public"."Session"."generalTags", "public"."Session"."expectedTotalTime", "public"."Session"."treatmentPlanId", "public"."Session"."patientJourneyId" FROM "public"."Session" WHERE ((EXISTS(SELECT "t0"."A" FROM "public"."_SessionToUniqueText" AS "t0" INNER JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ($4=$5 AND ("public"."Session"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) OR EXISTS(SELECT "t1"."A" FROM "public"."_SessionComplaints" AS "t1" INNER JOIN "public"."UniqueText" AS "j1" ON ("j1"."id") = ("t1"."B") WHERE ($6=$7 AND ("public"."Session"."id") = ("t1"."A") AND "t1"."A" IS NOT NULL))) AND "public"."Session"."clinicDomain" = $1) ORDER BY "public"."Session"."createdAt" DESC LIMIT $2 OFFSET $3

SELECT "public"."PrescriptionUnit"."id", "public"."PrescriptionUnit"."isTemplate", "public"."PrescriptionUnit"."medicineId", "public"."PrescriptionUnit"."repetitionId", "public"."PrescriptionUnit"."periodId", "public"."PrescriptionUnit"."noteId", "public"."PrescriptionUnit"."order", "public"."PrescriptionUnit"."clinicDomain", "public"."PrescriptionUnit"."createdAt", "public"."PrescriptionUnit"."updatedAt" FROM "public"."PrescriptionUnit" LEFT JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("public"."PrescriptionUnit"."medicineId") WHERE ("public"."PrescriptionUnit"."isTemplate" = $1 AND ("j0"."text" ILIKE $2 AND ("j0"."id" IS NOT NULL)) AND "public"."PrescriptionUnit"."clinicDomain" = $3) ORDER BY "public"."PrescriptionUnit"."isTemplate" DESC LIMIT $4 OFFSET $5 /* traceparent='00-e56b191febea0abb5ab1bea83c07c11a-87582eb1314b88c5-01' */

SELECT "public"."UniqueText"."id", "public"."UniqueText"."type"::text, "public"."UniqueText"."text", "public"."UniqueText"."clinicDomain", "public"."UniqueText"."createdAt", "public"."UniqueText"."updatedAt" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."clinicDomain" = $2) ORDER BY "public"."UniqueText"."createdAt" DESC LIMIT $3 OFFSET $4 /* traceparent='00-b7eb66579427bae2067d604b6b1611f2-cc5452a3ed8ce062-01' */

CREATE INDEX CONCURRENTLY ON UniqueText (clinicDomain, type)

Rows: 145441
Row progression: 145441, 641, 6

Row estimates
- clinicDomain (=): 641
- type (=): 1276
- createdAt (sort): 1

Existing indexes
- id PRIMARY
- text, clinicDomain, type UNIQUE

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE ((EXISTS(SELECT "t0"."A" FROM "public"."_SessionToUniqueText" AS "t0" INNER JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ($3=$4 AND ("public"."Session"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) OR EXISTS(SELECT "t1"."A" FROM "public"."_SessionComplaints" AS "t1" INNER JOIN "public"."UniqueText" AS "j1" ON ("j1"."id") = ("t1"."B") WHERE ($5=$6 AND ("public"."Session"."id") = ("t1"."A") AND "t1"."A" IS NOT NULL))) AND "public"."Session"."clinicDomain" = $1) OFFSET $2 /* traceparent='00-5e349a6a575436e56900f6c08dcb4767-f2e642c8a20e7e3c-01' */) AS "sub"

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."UniqueText"."id" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."clinicDomain" = $2) OFFSET $3 /* traceparent='00-b7eb66579427bae2067d604b6b1611f2-2c3eea0ceba9867c-01' */) AS "sub" /* traceparent='00-b7eb66579427bae2067d604b6b1611f2-2c3eea0ceba9867c-01' */

SELECT "public"."VariablePropertyValue"."id", "public"."VariablePropertyValue"."value", "public"."VariablePropertyValue"."propertyId", "public"."VariablePropertyValue"."createdAt", "public"."VariablePropertyValue"."updatedAt", "public"."VariablePropertyValue"."patientProfileId" FROM "public"."VariablePropertyValue" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."VariablePropertyValue"."patientProfileId") WHERE ("public"."VariablePropertyValue"."propertyId" = $1 AND "public"."VariablePropertyValue"."patientProfileId" = $2 AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL))) ORDER BY "public"."VariablePropertyValue"."createdAt" DESC LIMIT $4 OFFSET $5 /* traceparent='00-bcea28170369dce3d6f554d2be40ecd7-6efb2a5d3891821e-01' */

SELECT "public"."PatientProfile"."id", "public"."PatientProfile"."avatar", "public"."PatientProfile"."name", "public"."PatientProfile"."phone", "public"."PatientProfile"."phoneCode", "public"."PatientProfile"."email", "public"."PatientProfile"."address", "public"."PatientProfile"."patientIndex", "public"."PatientProfile"."taxApplicable", "public"."PatientProfile"."freeNote", "public"."PatientProfile"."city", "public"."PatientProfile"."state", "public"."PatientProfile"."zip", "public"."PatientProfile"."country", "public"."PatientProfile"."nationalId", "public"."PatientProfile"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "public"."PatientProfile"."medicalHistory", "public"."PatientProfile"."clinicDomain", "public"."PatientProfile"."createdAt", "public"."PatientProfile"."updatedAt", "public"."PatientProfile"."referralDoctorId", "public"."PatientProfile"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE (("public"."PatientProfile"."name" ILIKE $1 OR "public"."PatientProfile"."phone" ILIKE $2) AND "public"."PatientProfile"."clinicDomain" = $3) ORDER BY "public"."PatientProfile"."isActive" DESC, "public"."PatientProfile"."createdAt" DESC LIMIT $4 OFFSET $5 /* traceparent='00-9cc1512eead5e64b12bfb0c94b265b66-07946ad147cecee8-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."VariablePropertyValue"."id" FROM "public"."VariablePropertyValue" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."VariablePropertyValue"."patientProfileId") WHERE ("public"."VariablePropertyValue"."propertyId" = $1 AND "public"."VariablePropertyValue"."patientProfileId" = $2 AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL))) OFFSET $4 /* traceparent='00-bcea28170369dce3d6f554d2be40ecd7-0033b0d31bf16b20-01' */) AS "sub" /* traceparent='00-bcea28170369dce3d6f554d2be40ecd7-0033b0d31bf16b20-01' */

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Order" AS "j3" ON ("j3"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE (((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $1) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $2 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $3 AND "j0"."createdAt" <= $4 AND "j0"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR (("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND "j3"."createdAt" >= $7 AND "j3"."createdAt" <= $8 AND ("j3"."id" IS NOT NULL)) OR ("j5"."branchId" = $9 AND ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL)) AND "j5"."date" >= $11 AND "j5"."date" <= $12 AND "j5"."status" <> CAST($13::text AS "public"."SessionStatus") AND ("j5"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($14::text AS "public"."InvoiceStatus")) OFFSET $15 /* traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-d507fb121ada1872-01' */) AS "sub" /* traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-d507fb121ada1872-01' */

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Order" AS "j2" ON ("j2"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") WHERE (((("j1"."clinicDomain" = $1 AND ("j1"."id" IS NOT NULL)) AND "j0"."createdAt" >= $2 AND "j0"."createdAt" <= $3 AND "j0"."status" <> CAST($4::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR (("j3"."clinicDomain" = $5 AND ("j3"."id" IS NOT NULL)) AND "j2"."createdAt" >= $6 AND "j2"."createdAt" <= $7 AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" <> CAST($8::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $9 AND ("j5"."id" IS NOT NULL)) AND "j4"."date" >= $10 AND "j4"."date" <= $11 AND ("j4"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($12::text AS "public"."InvoiceStatus")) OFFSET $13 /* traceparent='00-4204664206eb0dfcdd0af733619eef74-f28f5e6299ad89be-01' */) AS "sub" /* traceparent='00-4204664206eb0dfcdd0af733619eef74-f28f5e6299ad89be-01' */

SELECT "public"."UniqueText"."id", "public"."UniqueText"."type"::text, "public"."UniqueText"."text", "public"."UniqueText"."clinicDomain", "public"."UniqueText"."createdAt", "public"."UniqueText"."updatedAt" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."text"::text LIKE $2 AND "public"."UniqueText"."clinicDomain" = $3) ORDER BY "public"."UniqueText"."createdAt" DESC LIMIT $4 OFFSET $5 /* traceparent='00-ba63b748c4bbc8133404429561673723-a3c84ac2f0f0dfac-01' */

SELECT "public"."Examination"."id", "public"."Examination"."name", "public"."Examination"."isActive", "public"."Examination"."price", "public"."Examination"."specialties"::text[], "public"."Examination"."defaultTime", "public"."Examination"."isDefault", "public"."Examination"."isMultiple", "public"."Examination"."clinicDomain", "public"."Examination"."order", "public"."Examination"."createdAt", "public"."Examination"."updatedAt", "public"."Examination"."doctorPercentage", "public"."Examination"."doctorFixedBonus", "public"."Examination"."managerPercentage", "public"."Examination"."managerFixedBonus", "public"."Examination"."category", "public"."Examination"."generalTags", "public"."Examination"."image", "public"."Examination"."color", "public"."Examination"."taxApplicable" FROM "public"."Examination" WHERE (EXISTS(SELECT "t0"."A" FROM "public"."_ExaminationToSession" AS "t0" INNER JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ("j0"."from" >= $1 AND "j0"."from" <= $2 AND ("public"."Examination"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) AND (EXISTS(SELECT "t1"."B" FROM "public"."_BranchToExamination" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ("j1"."id" = $3 AND ("public"."Examination"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) OR NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToExamination" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ($8=$9 AND ("public"."Examination"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL))) AND "public"."Examination"."clinicDomain" = $4 AND (NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToExamination" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ($10=$11 AND ("public"."Examination"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) OR EXISTS(SELECT "t4"."B" FROM "public"."_BranchToExamination" AS "t4" INNER JOIN "public"."Branch" AS "j4" ON ("j4"."id") = ("t4"."A") WHERE ("j4"."id" IN ($5) AND ("public"."Examination"."id") = ("t4"."B") AND "t4"."B" IS NOT NULL)))) ORDER BY "public"."Examination"."id" ASC LIMIT $6 OFFSET $7

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."UniqueText"."id" FROM "public"."UniqueText" WHERE ("public"."UniqueText"."type" = CAST($1::text AS "public"."UniqueTextType") AND "public"."UniqueText"."text"::text LIKE $2 AND "public"."UniqueText"."clinicDomain" = $3) OFFSET $4 /* traceparent='00-ba63b748c4bbc8133404429561673723-8a24cc1df7d1396c-01' */) AS "sub" /* traceparent='00-ba63b748c4bbc8133404429561673723-8a24cc1df7d1396c-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."User" AS "j5" ON ("j5"."id") = ("j3"."doctorId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."doctorId" = $3 AND ("j2"."clinicDomain" = $4 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $5 AND "j0"."createdAt" <= $6 AND "j0"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $8 AND "j3"."branchId" = $9 AND ("j4"."clinicDomain" = $10 AND ("j4"."id" IS NOT NULL)) AND "j3"."date" >= $11 AND "j3"."date" <= $12 AND "j3"."status" <> CAST($13::text AS "public"."SessionStatus") AND ((NOT $16=$17) AND ("j5"."id" IS NOT NULL)) AND ("j3"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $14 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)))) OFFSET $15 /* traceparent='00-993e05221af96cac375f9b691516c471-5b627bbe02c22e68-01' */) AS "sub"

SELECT MAX("serialNumber") AS "_max$serialNumber" FROM (SELECT "public"."Invoice"."serialNumber" FROM "public"."Invoice" WHERE "public"."Invoice"."clinicDomain" = $1 OFFSET $2 /* traceparent='00-e6b532352eebb1b414fe9db9550c16de-5a11b71ca25e82c0-01' */) AS "sub" /* traceparent='00-e6b532352eebb1b414fe9db9550c16de-5a11b71ca25e82c0-01' */

SELECT "public"."PatientProfile"."id", "public"."PatientProfile"."avatar", "public"."PatientProfile"."name", "public"."PatientProfile"."phone", "public"."PatientProfile"."phoneCode", "public"."PatientProfile"."email", "public"."PatientProfile"."address", "public"."PatientProfile"."patientIndex", "public"."PatientProfile"."taxApplicable", "public"."PatientProfile"."freeNote", "public"."PatientProfile"."city", "public"."PatientProfile"."state", "public"."PatientProfile"."zip", "public"."PatientProfile"."country", "public"."PatientProfile"."nationalId", "public"."PatientProfile"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "public"."PatientProfile"."medicalHistory", "public"."PatientProfile"."clinicDomain", "public"."PatientProfile"."createdAt", "public"."PatientProfile"."updatedAt", "public"."PatientProfile"."referralDoctorId", "public"."PatientProfile"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE ("public"."PatientProfile"."isActive" = $1 AND "public"."PatientProfile"."clinicDomain" = $2) ORDER BY "public"."PatientProfile"."id" ASC LIMIT $3 OFFSET $4 /* traceparent='00-c09946c1ea761b8b7c61caadee384ef0-bac0ee4cc24f30ec-01' */

Covered by index on (clinicDomain, link)
Rows: 216581
Row progression: 216581, 985, 493

Row estimates
- clinicDomain (=): 985
- isActive (=): 108291
- id (sort): 1

Existing indexes
- id PRIMARY
- clinicDomain, link UNIQUE
- clinicDomain, patientIndex UNIQUE

SELECT "public"."Examination"."id", "public"."Examination"."name", "public"."Examination"."isActive", "public"."Examination"."price", "public"."Examination"."specialties"::text[], "public"."Examination"."defaultTime", "public"."Examination"."isDefault", "public"."Examination"."isMultiple", "public"."Examination"."clinicDomain", "public"."Examination"."order", "public"."Examination"."createdAt", "public"."Examination"."updatedAt", "public"."Examination"."doctorPercentage", "public"."Examination"."doctorFixedBonus", "public"."Examination"."managerPercentage", "public"."Examination"."managerFixedBonus", "public"."Examination"."category", "public"."Examination"."generalTags", "public"."Examination"."image", "public"."Examination"."color", "public"."Examination"."taxApplicable" FROM "public"."Examination" WHERE (EXISTS(SELECT "t0"."A" FROM "public"."_ExaminationToSession" AS "t0" INNER JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ("j0"."from" >= $1 AND "j0"."from" <= $2 AND ("public"."Examination"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) AND (EXISTS(SELECT "t1"."B" FROM "public"."_BranchToExamination" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ("j1"."id" = $3 AND ("public"."Examination"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) OR NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToExamination" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ($7=$8 AND ("public"."Examination"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL))) AND "public"."Examination"."clinicDomain" = $4) ORDER BY "public"."Examination"."id" ASC LIMIT $5 OFFSET $6

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."TreasuryTransaction"."amount" FROM "public"."TreasuryTransaction" WHERE "public"."TreasuryTransaction"."treasuryId" = $1 OFFSET $2 /* traceparent='00-b88334a537f3293fcfa9e0817df6f50b-aa014f595ea2f379-01' */) AS "sub" /* traceparent='00-b88334a537f3293fcfa9e0817df6f50b-aa014f595ea2f379-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."Expense"."amount" FROM "public"."Expense" WHERE ("public"."Expense"."clinicDomain" = $1 AND "public"."Expense"."date" >= $2 AND "public"."Expense"."date" <= $3 AND "public"."Expense"."branchId" IN ($4)) OFFSET $5 /* traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-7d612a68450d8de1-01' */) AS "sub" /* traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-7d612a68450d8de1-01' */

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") WHERE (((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $1) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."doctorId" = $2 AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $7 AND "j3"."branchId" = $8 AND ("j4"."clinicDomain" = $9 AND ("j4"."id" IS NOT NULL)) AND "j3"."date" >= $10 AND "j3"."date" <= $11 AND "j3"."status" <> CAST($12::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($13::text AS "public"."InvoiceStatus")) OFFSET $14 /* traceparent='00-82a429e1bf5aeb58407cc4fbdf858041-a1f44088fbcf6885-01' */) AS "sub" /* traceparent='00-82a429e1bf5aeb58407cc4fbdf858041-a1f44088fbcf6885-01' */

SELECT "public"."Session"."id", "public"."Session"."order", "public"."Session"."to" FROM "public"."Session" WHERE ("public"."Session"."from" >= $1 AND "public"."Session"."from" <= $2 AND "public"."Session"."clinicDomain" = $3 AND "public"."Session"."status" IN (CAST($4::text AS "public"."SessionStatus"),CAST($5::text AS "public"."SessionStatus")) AND "public"."Session"."order" > $6 AND "public"."Session"."id" <> $7) ORDER BY "public"."Session"."order" DESC LIMIT $8 OFFSET $9 /* traceparent='00-d0d7070ecdb14ba60810a02abe2840f7-9f7896bf35d2732c-01' */

CREATE INDEX CONCURRENTLY ON Session (clinicDomain, from)

Rows: 491713
Row progression: 491713, 2496, 246

Row estimates
- clinicDomain (=): 2496
- from (<=): 48520
- from (>=): 48520
- order (>): 49454
- status (=): 122928
- id (<>): 491712
- order (sort): 2826

Existing indexes
- id PRIMARY
- branchId, from
- clinicDomain, link UNIQUE
- date, branchId
- date, clinicDomain
- date, doctorId
- date, patientProfileId
- doctorId, branchId
- doctorId, date, branchId, clinicDomain
- patientProfileId

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."User" AS "j5" ON ("j5"."id") = ("j3"."doctorId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."branchId" = $7 AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND "j3"."date" >= $9 AND "j3"."date" <= $10 AND "j3"."status" <> CAST($11::text AS "public"."SessionStatus") AND ((NOT $14=$15) AND ("j5"."id" IS NOT NULL)) AND ("j3"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $12 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)))) OFFSET $13 /* traceparent='00-c129a136a6f64cdb969df1e2717c1082-f95f2a2578329900-01' */) AS "sub"

SELECT "public"."Prescription"."id", "public"."Prescription"."name", "public"."Prescription"."noteId", "public"."Prescription"."previewUrl", "public"."Prescription"."isTemplate", "public"."Prescription"."sessionId", "public"."Prescription"."clinicDomain", "public"."Prescription"."order", "public"."Prescription"."link", "public"."Prescription"."createdAt", "public"."Prescription"."updatedAt", "public"."Prescription"."patientProfileId", "public"."Prescription"."nextAppointment", "public"."Prescription"."designTemplate" FROM "public"."Prescription" WHERE ("public"."Prescription"."patientProfileId" = $1 AND "public"."Prescription"."clinicDomain" = $2) ORDER BY "public"."Prescription"."id" ASC LIMIT $3 OFFSET $4 /* traceparent='00-ff67bd516a2e8ebaa241526e1a9907a5-f8157e231d16a181-01' */

CREATE INDEX CONCURRENTLY ON Prescription (patientProfileId)

Rows: 59224
Row progression: 59224, 2

Row estimates
- patientProfileId (=): 2
- clinicDomain (=): 463
- id (sort): 1

Existing indexes
- id PRIMARY
- link, clinicDomain UNIQUE

SELECT "public"."Prescription"."id", "public"."Prescription"."name", "public"."Prescription"."noteId", "public"."Prescription"."previewUrl", "public"."Prescription"."isTemplate", "public"."Prescription"."sessionId", "public"."Prescription"."clinicDomain", "public"."Prescription"."order", "public"."Prescription"."link", "public"."Prescription"."createdAt", "public"."Prescription"."updatedAt", "public"."Prescription"."patientProfileId", "public"."Prescription"."nextAppointment", "public"."Prescription"."designTemplate" FROM "public"."Prescription" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Prescription"."sessionId") WHERE ((("j0"."patientProfileId" = $1 AND ("j0"."id" IS NOT NULL)) OR "public"."Prescription"."patientProfileId" = $2) AND "public"."Prescription"."clinicDomain" = $3) ORDER BY "public"."Prescription"."id" ASC LIMIT $4 OFFSET $5 /* traceparent='00-df1c976d41162663d926108e17dc791f-3342fc0e78679305-01' */

SELECT "public"."PatientProfile"."id", "public"."PatientProfile"."avatar", "public"."PatientProfile"."name", "public"."PatientProfile"."phone", "public"."PatientProfile"."phoneCode", "public"."PatientProfile"."email", "public"."PatientProfile"."address", "public"."PatientProfile"."patientIndex", "public"."PatientProfile"."taxApplicable", "public"."PatientProfile"."freeNote", "public"."PatientProfile"."city", "public"."PatientProfile"."state", "public"."PatientProfile"."zip", "public"."PatientProfile"."country", "public"."PatientProfile"."nationalId", "public"."PatientProfile"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "public"."PatientProfile"."medicalHistory", "public"."PatientProfile"."clinicDomain", "public"."PatientProfile"."createdAt", "public"."PatientProfile"."updatedAt", "public"."PatientProfile"."referralDoctorId", "public"."PatientProfile"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE ("public"."PatientProfile"."isActive" = $1 AND ("public"."PatientProfile"."name" ILIKE $2 OR "public"."PatientProfile"."phone" IS NULL) AND "public"."PatientProfile"."id" <> $3 AND "public"."PatientProfile"."clinicDomain" = $4) ORDER BY "public"."PatientProfile"."id" ASC LIMIT $5 OFFSET $6 /* traceparent='00-7cc4f0a3891f56b700019bebcb950085-7179b05309459ac6-01' */

SELECT "public"."PatientProfile"."id", "public"."PatientProfile"."avatar", "public"."PatientProfile"."name", "public"."PatientProfile"."phone", "public"."PatientProfile"."phoneCode", "public"."PatientProfile"."email", "public"."PatientProfile"."address", "public"."PatientProfile"."patientIndex", "public"."PatientProfile"."taxApplicable", "public"."PatientProfile"."freeNote", "public"."PatientProfile"."city", "public"."PatientProfile"."state", "public"."PatientProfile"."zip", "public"."PatientProfile"."country", "public"."PatientProfile"."nationalId", "public"."PatientProfile"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "public"."PatientProfile"."medicalHistory", "public"."PatientProfile"."clinicDomain", "public"."PatientProfile"."createdAt", "public"."PatientProfile"."updatedAt", "public"."PatientProfile"."referralDoctorId", "public"."PatientProfile"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE ("public"."PatientProfile"."isActive" = $1 AND ("public"."PatientProfile"."name" ILIKE $2 OR "public"."PatientProfile"."phone" = $3) AND "public"."PatientProfile"."id" <> $4 AND "public"."PatientProfile"."clinicDomain" = $5) ORDER BY "public"."PatientProfile"."id" ASC LIMIT $6 OFFSET $7 /* traceparent='00-787b3eb8716d00c89d755b287f889127-4ebe948c59d0c2df-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."User" AS "j5" ON ("j5"."id") = ("j3"."doctorId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."branchId" = $7 AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND "j3"."date" >= $9 AND "j3"."date" <= $10 AND "j3"."status" <> CAST($11::text AS "public"."SessionStatus") AND ((NOT $13=$14) AND ("j5"."id" IS NOT NULL)) AND ("j3"."id" IS NOT NULL)))) OFFSET $12 /* traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-d70bd720e18cdd8a-01' */) AS "sub"

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" NOT IN (CAST($1::text AS "public"."PaymentMethod"),CAST($2::text AS "public"."PaymentMethod")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $7) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND "j2"."doctorId" = $8 AND ("j4"."clinicDomain" = $9 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $10 AND "j5"."branchId" = $11 AND ("j6"."clinicDomain" = $12 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $13 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $14 /* traceparent='00-993e05221af96cac375f9b691516c471-d8bacef60a377b04-01' */) AS "sub" /* traceparent='00-993e05221af96cac375f9b691516c471-d8bacef60a377b04-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor" FROM (SELECT "public"."PaymentTransaction"."forDoctor", "public"."PaymentTransaction"."forAssistant", "public"."PaymentTransaction"."forReferralDoctor" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $4) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND "j2"."doctorId" = $5 AND ("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND "j2"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $8 AND "j5"."branchId" = $9 AND ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $11 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $12 /* traceparent='00-993e05221af96cac375f9b691516c471-4c714725400df3b5-01' */) AS "sub" /* traceparent='00-993e05221af96cac375f9b691516c471-4c714725400df3b5-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE ("public"."Session"."from" >= $1 AND "public"."Session"."from" <= $2 AND "public"."Session"."clinicDomain" = $3 AND "public"."Session"."status" = CAST($4::text AS "public"."SessionStatus")) OFFSET $5 /* traceparent='00-13659963b5616fc87634e7a08c293e9e-83110bfb6ddaa408-01' */) AS "sub" /* traceparent='00-13659963b5616fc87634e7a08c293e9e-83110bfb6ddaa408-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Prescription"."id" FROM "public"."Prescription" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Prescription"."sessionId") WHERE ((("j0"."patientProfileId" = $1 AND ("j0"."id" IS NOT NULL)) OR "public"."Prescription"."patientProfileId" = $2) AND "public"."Prescription"."clinicDomain" = $3) OFFSET $4 /* traceparent='00-df1c976d41162663d926108e17dc791f-456d1cebe6c7e4ce-01' */) AS "sub" /* traceparent='00-df1c976d41162663d926108e17dc791f-456d1cebe6c7e4ce-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Prescription"."id" FROM "public"."Prescription" WHERE ("public"."Prescription"."patientProfileId" = $1 AND "public"."Prescription"."clinicDomain" = $2) OFFSET $3 /* traceparent='00-ff67bd516a2e8ebaa241526e1a9907a5-01a4ea3bc16aac16-01' */) AS "sub" /* traceparent='00-ff67bd516a2e8ebaa241526e1a9907a5-01a4ea3bc16aac16-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Notification"."id" FROM "public"."Notification" WHERE "public"."Notification"."userId" = $1 OFFSET $2 /* traceparent='00-d59b7c4f367db7b07cc5413ecaaa6b00-2e0b6a2f67618555-01' */) AS "sub" /* traceparent='00-d59b7c4f367db7b07cc5413ecaaa6b00-2e0b6a2f67618555-01' */

SELECT "public"."Notification"."id", "public"."Notification"."userId", "public"."Notification"."title", "public"."Notification"."content", "public"."Notification"."type"::text, "public"."Notification"."isRead", "public"."Notification"."createdAt", "public"."Notification"."updatedAt", "public"."Notification"."sentToWhatsappAt", "public"."Notification"."whatsappLogId" FROM "public"."Notification" WHERE "public"."Notification"."userId" = $1 ORDER BY "public"."Notification"."createdAt" DESC LIMIT $2 OFFSET $3 /* traceparent='00-d59b7c4f367db7b07cc5413ecaaa6b00-cadee7d1de09e2f9-01' */

CREATE INDEX CONCURRENTLY ON Notification (userId, createdAt)

Rows: 84205
Row progression: 84205, 726, 0

Row estimates
- userId (=): 726
- createdAt (sort): 1

Existing indexes
- id PRIMARY
- whatsappLogId UNIQUE

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND "public"."PaymentTransaction"."amount" < $4 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $5) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND "j2"."doctorId" = $6 AND ("j4"."clinicDomain" = $7 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $8 AND "j5"."branchId" = $9 AND ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $11 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $12 /* traceparent='00-993e05221af96cac375f9b691516c471-6b00b3d8882d6db6-01' */) AS "sub" /* traceparent='00-993e05221af96cac375f9b691516c471-6b00b3d8882d6db6-01' */

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Order" AS "j3" ON ("j3"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR (("j4"."clinicDomain" = $7 AND ("j4"."id" IS NOT NULL)) AND "j3"."createdAt" >= $8 AND "j3"."createdAt" <= $9 AND ("j3"."id" IS NOT NULL)) OR ("j5"."branchId" = $10 AND ("j6"."clinicDomain" = $11 AND ("j6"."id" IS NOT NULL)) AND "j5"."date" >= $12 AND "j5"."date" <= $13 AND "j5"."status" <> CAST($14::text AS "public"."SessionStatus") AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $15 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($16::text AS "public"."InvoiceStatus")) OFFSET $17 /* traceparent='00-83b65343b11394e64f7eecfbca3d4a68-48b9303fb01f3c03-01' */) AS "sub" /* traceparent='00-83b65343b11394e64f7eecfbca3d4a68-48b9303fb01f3c03-01' */

SELECT "public"."Invoice"."id", "public"."Invoice"."sessionId", "public"."Invoice"."orderId", "public"."Invoice"."accommodationId", "public"."Invoice"."note", "public"."Invoice"."status"::text, "public"."Invoice"."paymentStatus"::text, "public"."Invoice"."ownerId", "public"."Invoice"."total", "public"."Invoice"."totalTax", "public"."Invoice"."subTotal", "public"."Invoice"."discountValue", "public"."Invoice"."restNotPaid", "public"."Invoice"."packageDiscount", "public"."Invoice"."manualDiscount", "public"."Invoice"."insuranceCoverageAmount", "public"."Invoice"."patientDeductibleAmount", "public"."Invoice"."insuranceDiscountAmount", "public"."Invoice"."forDoctor", "public"."Invoice"."forManagers", "public"."Invoice"."insurancePolicyClassId", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."paymentAttach", "public"."Invoice"."clinicDomain", "public"."Invoice"."createdAt", "public"."Invoice"."updatedAt", "public"."Invoice"."link", "public"."Invoice"."points", "public"."Invoice"."consumablesTotal", "public"."Invoice"."consumablesPayByPatient", "public"."Invoice"."closingShiftId", "public"."Invoice"."isLocked", "public"."Invoice"."serialNumber" FROM "public"."Invoice" WHERE ("public"."Invoice"."status" = CAST($1::text AS "public"."InvoiceStatus") AND "public"."Invoice"."restNotPaid" > $2 AND "public"."Invoice"."clinicDomain" = $3) ORDER BY "public"."Invoice"."createdAt" DESC LIMIT $4 OFFSET $5 /* traceparent='00-4e410c6feb0fa566e066888a1a72dc22-2da019cac1d3ad28-01' */

CREATE INDEX CONCURRENTLY ON Invoice (clinicDomain, restNotPaid)

Rows: 506245
Row progression: 506245, 2531, 254

Row estimates
- clinicDomain (=): 2531
- restNotPaid (>): 50849
- status (=): 168748
- createdAt (sort): 1

Existing indexes
- id PRIMARY
- accommodationId UNIQUE
- clinicDomain, serialNumber UNIQUE
- closingShiftId
- orderId UNIQUE
- sessionId UNIQUE

SELECT "public"."Session"."id", "public"."Session"."order" FROM "public"."Session" WHERE ("public"."Session"."from" >= $1 AND "public"."Session"."from" <= $2 AND "public"."Session"."clinicDomain" = $3 AND "public"."Session"."status" IN (CAST($4::text AS "public"."SessionStatus"),CAST($5::text AS "public"."SessionStatus")) AND "public"."Session"."id" <> $6) ORDER BY "public"."Session"."order" DESC LIMIT $7 OFFSET $8 /* traceparent='00-e6b532352eebb1b414fe9db9550c16de-d45c97b6f720a592-01' */

CREATE INDEX CONCURRENTLY ON Session (clinicDomain, from)

Rows: 491713
Row progression: 491713, 2496, 246

Row estimates
- clinicDomain (=): 2496
- from (<=): 48520
- from (>=): 48520
- status (=): 122928
- id (<>): 491712
- order (sort): 2826

Existing indexes
- id PRIMARY
- branchId, from
- clinicDomain, link UNIQUE
- date, branchId
- date, clinicDomain
- date, doctorId
- date, patientProfileId
- doctorId, branchId
- doctorId, date, branchId, clinicDomain
- patientProfileId

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("j0"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j1"."patientProfileId") LEFT JOIN "public"."Order" AS "j4" ON ("j4"."id") = ("j0"."orderId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Session" AS "j6" ON ("j6"."id") = ("j0"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j8" ON ("j8"."id") = ("j0"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j9" ON ("j9"."id") = ("j8"."patientProfileId") WHERE ("j0"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToPackageSubscription" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ((NOT "j2"."id" = $2) AND ("j1"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL)) AND ("j3"."clinicDomain" = $3 AND ("j3"."id" IS NOT NULL)) AND "j1"."createdAt" >= $4 AND "j1"."createdAt" <= $5 AND "j1"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR (("j5"."clinicDomain" = $7 AND ("j5"."id" IS NOT NULL)) AND "j4"."createdAt" >= $8 AND "j4"."createdAt" <= $9 AND ("j4"."id" IS NOT NULL)) OR ("j6"."branchId" = $10 AND ("j7"."clinicDomain" = $11 AND ("j7"."id" IS NOT NULL)) AND "j6"."date" >= $12 AND "j6"."date" <= $13 AND "j6"."status" <> CAST($14::text AS "public"."SessionStatus") AND ("j6"."id" IS NOT NULL)) OR ("j9"."clinicDomain" = $15 AND ("j9"."id" IS NOT NULL) AND ("j8"."id" IS NOT NULL))) AND "j0"."status" = CAST($16::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $17 /* traceparent='00-83b65343b11394e64f7eecfbca3d4a68-d9f3ddb28a744e39-01' */) AS "sub" /* traceparent='00-83b65343b11394e64f7eecfbca3d4a68-d9f3ddb28a744e39-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") LEFT JOIN "public"."Order" AS "j8" ON ("j8"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j9" ON ("j9"."id") = ("j8"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" NOT IN (CAST($1::text AS "public"."PaymentMethod"),CAST($2::text AS "public"."PaymentMethod")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 AND ((("j3"."clinicDomain" = $7 AND ("j3"."id" IS NOT NULL) AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" = CAST($8::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $9 AND ("j5"."id" IS NOT NULL)) AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $10 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)) OR ("j9"."clinicDomain" = $11 AND ("j9"."id" IS NOT NULL) AND ("j8"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $12 /* traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-b4caa3ba447bbcd5-01' */) AS "sub" /* traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-b4caa3ba447bbcd5-01' */

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."doctorId" = $3 AND ("j2"."clinicDomain" = $4 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $5 AND "j0"."createdAt" <= $6 AND "j0"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $8 AND "j3"."branchId" = $9 AND ("j4"."clinicDomain" = $10 AND ("j4"."id" IS NOT NULL)) AND "j3"."date" >= $11 AND "j3"."date" <= $12 AND "j3"."status" <> CAST($13::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR ("j6"."clinicDomain" = $14 AND ("j6"."id" IS NOT NULL) AND ("j5"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($15::text AS "public"."InvoiceStatus")) OFFSET $16 /* traceparent='00-993e05221af96cac375f9b691516c471-26d678678f3af7cb-01' */) AS "sub" /* traceparent='00-993e05221af96cac375f9b691516c471-26d678678f3af7cb-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor" FROM (SELECT "public"."PaymentTransaction"."forDoctor", "public"."PaymentTransaction"."forAssistant", "public"."PaymentTransaction"."forReferralDoctor" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") LEFT JOIN "public"."Order" AS "j9" ON ("j9"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j10" ON ("j10"."id") = ("j9"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $4) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $5 AND ("j4"."id" IS NOT NULL)) AND "j2"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j2"."id" IS NOT NULL)) OR ("j5"."branchId" = $7 AND ("j6"."clinicDomain" = $8 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $9 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL)) OR ("j10"."clinicDomain" = $10 AND ("j10"."id" IS NOT NULL) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $11 /* traceparent='00-83b65343b11394e64f7eecfbca3d4a68-e791525a1ab06633-01' */) AS "sub" /* traceparent='00-83b65343b11394e64f7eecfbca3d4a68-e791525a1ab06633-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") LEFT JOIN "public"."Order" AS "j9" ON ("j9"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j10" ON ("j10"."id") = ("j9"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND "public"."PaymentTransaction"."amount" < $4 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $5) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."branchId" = $7 AND ("j6"."clinicDomain" = $8 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $9 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL)) OR ("j10"."clinicDomain" = $10 AND ("j10"."id" IS NOT NULL) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $11 /* traceparent='00-83b65343b11394e64f7eecfbca3d4a68-ec81d08c5efcecb6-01' */) AS "sub" /* traceparent='00-83b65343b11394e64f7eecfbca3d4a68-ec81d08c5efcecb6-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor" FROM (SELECT "public"."PaymentTransaction"."forDoctor", "public"."PaymentTransaction"."forAssistant", "public"."PaymentTransaction"."forReferralDoctor" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") LEFT JOIN "public"."Order" AS "j8" ON ("j8"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j9" ON ("j9"."id") = ("j8"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND (((("j3"."clinicDomain" = $4 AND ("j3"."id" IS NOT NULL)) AND "j2"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" = CAST($6::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $7 AND ("j5"."id" IS NOT NULL)) AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $8 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)) OR ("j9"."clinicDomain" = $9 AND ("j9"."id" IS NOT NULL) AND ("j8"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $10 /* traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-53f778a55840dc9f-01' */) AS "sub" /* traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-53f778a55840dc9f-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("j0"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j1"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j0"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j0"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") WHERE ("j0"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToPackageSubscription" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ((NOT "j2"."id" = $2) AND ("j1"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL)) AND "j1"."doctorId" = $3 AND ("j3"."clinicDomain" = $4 AND ("j3"."id" IS NOT NULL)) AND "j1"."createdAt" >= $5 AND "j1"."createdAt" <= $6 AND "j1"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR ("j4"."doctorId" = $8 AND "j4"."branchId" = $9 AND ("j5"."clinicDomain" = $10 AND ("j5"."id" IS NOT NULL)) AND "j4"."date" >= $11 AND "j4"."date" <= $12 AND "j4"."status" <> CAST($13::text AS "public"."SessionStatus") AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $14 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL))) AND "j0"."status" = CAST($15::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $16 /* traceparent='00-993e05221af96cac375f9b691516c471-8d47aa83d3a82232-01' */) AS "sub" /* traceparent='00-993e05221af96cac375f9b691516c471-8d47aa83d3a82232-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") LEFT JOIN "public"."Order" AS "j8" ON ("j8"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j9" ON ("j9"."id") = ("j8"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND "public"."PaymentTransaction"."amount" < $4 AND ((("j3"."clinicDomain" = $5 AND ("j3"."id" IS NOT NULL) AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" = CAST($6::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $7 AND ("j5"."id" IS NOT NULL)) AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $8 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)) OR ("j9"."clinicDomain" = $9 AND ("j9"."id" IS NOT NULL) AND ("j8"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $10 /* traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-d227d8ae5ef3642c-01' */) AS "sub" /* traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-d227d8ae5ef3642c-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") LEFT JOIN "public"."Order" AS "j9" ON ("j9"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j10" ON ("j10"."id") = ("j9"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" NOT IN (CAST($1::text AS "public"."PaymentMethod"),CAST($2::text AS "public"."PaymentMethod")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $7) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."branchId" = $9 AND ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $11 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL)) OR ("j10"."clinicDomain" = $12 AND ("j10"."id" IS NOT NULL) AND ("j9"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $13 /* traceparent='00-83b65343b11394e64f7eecfbca3d4a68-5dd03ef5bb5fca89-01' */) AS "sub" /* traceparent='00-83b65343b11394e64f7eecfbca3d4a68-5dd03ef5bb5fca89-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."branchId" = $7 AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND "j3"."date" >= $9 AND "j3"."date" <= $10 AND "j3"."status" <> CAST($11::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)))) OFFSET $12 /* traceparent='00-66f091e63c5a31e9bb8d99c271eecfec-9f67c9cbd65e3415-01' */) AS "sub" /* traceparent='00-66f091e63c5a31e9bb8d99c271eecfec-9f67c9cbd65e3415-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j2" ON ("j2"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."User" AS "j4" ON ("j4"."id") = ("j2"."doctorId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL)) AND "j0"."createdAt" >= $3 AND "j0"."createdAt" <= $4 AND "j0"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j2"."status" <> CAST($6::text AS "public"."SessionStatus") AND ("j3"."clinicDomain" = $7 AND ("j3"."id" IS NOT NULL)) AND "j2"."date" >= $8 AND "j2"."date" <= $9 AND ((NOT $12=$13) AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL) AND ("j5"."id" IS NOT NULL)))) OFFSET $11 /* traceparent='00-acd9f5fa7d01887f5494210ac5a46bd8-dc4700482a4a63bc-01' */) AS "sub"

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor" FROM (SELECT "public"."PaymentTransaction"."forDoctor", "public"."PaymentTransaction"."forAssistant", "public"."PaymentTransaction"."forReferralDoctor" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Order" AS "j7" ON ("j7"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $4) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $5 AND ("j4"."id" IS NOT NULL)) AND "j2"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j2"."id" IS NOT NULL)) OR ("j5"."branchId" = $7 AND ("j6"."clinicDomain" = $8 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $9 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $10 /* traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-f20040656f4d4b54-01' */) AS "sub" /* traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-f20040656f4d4b54-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."Expense"."amount" FROM "public"."Expense" WHERE ("public"."Expense"."clinicDomain" = $1 AND "public"."Expense"."date" >= $2 AND "public"."Expense"."date" <= $3) OFFSET $4 /* traceparent='00-1ff6bf54cf73d995455be72bd8d044a5-5a42a81f7f093228-01' */) AS "sub" /* traceparent='00-1ff6bf54cf73d995455be72bd8d044a5-5a42a81f7f093228-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j2" ON ("j2"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j4" ON ("j4"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL)) AND "j0"."createdAt" >= $3 AND "j0"."createdAt" <= $4 AND "j0"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j2"."status" <> CAST($6::text AS "public"."SessionStatus") AND ("j3"."clinicDomain" = $7 AND ("j3"."id" IS NOT NULL)) AND "j2"."date" >= $8 AND "j2"."date" <= $9 AND ("j2"."id" IS NOT NULL)) OR ("j5"."clinicDomain" = $10 AND ("j5"."id" IS NOT NULL) AND ("j4"."id" IS NOT NULL)))) OFFSET $11 /* traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-f7a9a4bbb0af935a-01' */) AS "sub" /* traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-f7a9a4bbb0af935a-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."User" AS "j5" ON ("j5"."id") = ("j3"."doctorId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."doctorId" = $3 AND ("j2"."clinicDomain" = $4 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $5 AND "j0"."createdAt" <= $6 AND "j0"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $8 AND "j3"."branchId" = $9 AND ("j4"."clinicDomain" = $10 AND ("j4"."id" IS NOT NULL)) AND "j3"."date" >= $11 AND "j3"."date" <= $12 AND "j3"."status" <> CAST($13::text AS "public"."SessionStatus") AND ((NOT $15=$16) AND ("j5"."id" IS NOT NULL)) AND ("j3"."id" IS NOT NULL)))) OFFSET $14 /* traceparent='00-82a429e1bf5aeb58407cc4fbdf858041-4201a6daf4cf7e5b-01' */) AS "sub"

SELECT "public"."PackageSubscription"."id", "public"."PackageSubscription"."packageId", "public"."PackageSubscription"."patientProfileId", "public"."PackageSubscription"."invoiceId", "public"."PackageSubscription"."doctorId", "public"."PackageSubscription"."assistantId", "public"."PackageSubscription"."referralDoctorId", "public"."PackageSubscription"."status"::text, "public"."PackageSubscription"."isOnHold", "public"."PackageSubscription"."startDate", "public"."PackageSubscription"."endDate", "public"."PackageSubscription"."effectiveEndDate", "public"."PackageSubscription"."createdAt", "public"."PackageSubscription"."updatedAt", "public"."PackageSubscription"."finishedAt", "public"."PackageSubscription"."shiftId", "public"."PackageSubscription"."patientInsuranceId", "public"."PackageSubscription"."mainBranchId" FROM "public"."PackageSubscription" LEFT JOIN "public"."Package" AS "j2" ON ("j2"."id") = ("public"."PackageSubscription"."packageId") WHERE ("public"."PackageSubscription"."patientProfileId" = $1 AND (EXISTS(SELECT "t0"."B" FROM "public"."_BranchToPackageSubscription" AS "t0" INNER JOIN "public"."Branch" AS "j0" ON ("j0"."id") = ("t0"."A") WHERE ("j0"."id" = $2 AND ("public"."PackageSubscription"."id") = ("t0"."B") AND "t0"."B" IS NOT NULL)) OR NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ($7=$8 AND ("public"."PackageSubscription"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL))) AND "public"."PackageSubscription"."status" = CAST($3::text AS "public"."PackageSubscriptionStatus") AND (EXISTS(SELECT "t3"."packageId" FROM "public"."PackageUnit" AS "t3" WHERE ("t3"."examinationId" IN ($4) AND ("j2"."id") = ("t3"."packageId") AND "t3"."packageId" IS NOT NULL)) AND ("j2"."id" IS NOT NULL))) LIMIT $5 OFFSET $6

SELECT "public"."Invoice"."id", "public"."Invoice"."sessionId", "public"."Invoice"."orderId", "public"."Invoice"."accommodationId", "public"."Invoice"."note", "public"."Invoice"."status"::text, "public"."Invoice"."paymentStatus"::text, "public"."Invoice"."ownerId", "public"."Invoice"."total", "public"."Invoice"."totalTax", "public"."Invoice"."subTotal", "public"."Invoice"."discountValue", "public"."Invoice"."restNotPaid", "public"."Invoice"."packageDiscount", "public"."Invoice"."manualDiscount", "public"."Invoice"."insuranceCoverageAmount", "public"."Invoice"."patientDeductibleAmount", "public"."Invoice"."insuranceDiscountAmount", "public"."Invoice"."forDoctor", "public"."Invoice"."forManagers", "public"."Invoice"."insurancePolicyClassId", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."paymentAttach", "public"."Invoice"."clinicDomain", "public"."Invoice"."createdAt", "public"."Invoice"."updatedAt", "public"."Invoice"."link", "public"."Invoice"."points", "public"."Invoice"."consumablesTotal", "public"."Invoice"."consumablesPayByPatient", "public"."Invoice"."closingShiftId", "public"."Invoice"."isLocked", "public"."Invoice"."serialNumber" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."Order" AS "j2" ON ("j2"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") WHERE (((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $1) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."status" <> CAST($2::text AS "public"."PackageSubscriptionStatus") AND "j0"."startDate" >= $3 AND "j0"."startDate" <= $4 AND ("j0"."id" IS NOT NULL)) OR ("j2"."branchId" = $5 AND "j2"."createdAt" >= $6 AND "j2"."createdAt" <= $7 AND ("j2"."id" IS NOT NULL)) OR ("j3"."date" >= $8 AND "j3"."date" <= $9 AND "j3"."status" <> CAST($10::text AS "public"."SessionStatus") AND "j3"."branchId" = $11 AND ("j3"."id" IS NOT NULL))) AND "public"."Invoice"."clinicDomain" = $12) ORDER BY "public"."Invoice"."id" DESC LIMIT $13 OFFSET $14 /* traceparent='00-8647724935b55aa444d9d4a7f949429e-c7a7da98adcd4344-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j2" ON ("j2"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."User" AS "j4" ON ("j4"."id") = ("j2"."doctorId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL)) AND "j0"."createdAt" >= $3 AND "j0"."createdAt" <= $4 AND "j0"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j2"."status" <> CAST($6::text AS "public"."SessionStatus") AND ("j3"."clinicDomain" = $7 AND ("j3"."id" IS NOT NULL)) AND "j2"."date" >= $8 AND "j2"."date" <= $9 AND ((NOT $11=$12) AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)))) OFFSET $10 /* traceparent='00-5bb9fe8e4199c0dbbd21814e49c7716a-fc2cc31b9244a30f-01' */) AS "sub"

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Order" AS "j2" ON ("j2"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL)) AND "j0"."createdAt" >= $3 AND "j0"."createdAt" <= $4 AND "j0"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR (("j3"."clinicDomain" = $6 AND ("j3"."id" IS NOT NULL)) AND "j2"."createdAt" >= $7 AND "j2"."createdAt" <= $8 AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" <> CAST($9::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $10 AND ("j5"."id" IS NOT NULL)) AND "j4"."date" >= $11 AND "j4"."date" <= $12 AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $13 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($14::text AS "public"."InvoiceStatus")) OFFSET $15 /* traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-a7e3103367e16dc5-01' */) AS "sub" /* traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-a7e3103367e16dc5-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Order" AS "j7" ON ("j7"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND "public"."PaymentTransaction"."amount" < $4 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $5) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."branchId" = $7 AND ("j6"."clinicDomain" = $8 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $9 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $10 /* traceparent='00-dae9d8e8ef09570bcf413df515b9dc6b-7ea168e8aa6c48c2-01' */) AS "sub" /* traceparent='00-dae9d8e8ef09570bcf413df515b9dc6b-7ea168e8aa6c48c2-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Order" AS "j7" ON ("j7"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" NOT IN (CAST($1::text AS "public"."PaymentMethod"),CAST($2::text AS "public"."PaymentMethod")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $7) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."branchId" = $9 AND ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $11 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $12 /* traceparent='00-dae9d8e8ef09570bcf413df515b9dc6b-f5f1fbc7b4209f9b-01' */) AS "sub" /* traceparent='00-dae9d8e8ef09570bcf413df515b9dc6b-f5f1fbc7b4209f9b-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor" FROM (SELECT "public"."PaymentTransaction"."forDoctor", "public"."PaymentTransaction"."forAssistant", "public"."PaymentTransaction"."forReferralDoctor" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Order" AS "j6" ON ("j6"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND (((("j3"."clinicDomain" = $4 AND ("j3"."id" IS NOT NULL)) AND "j2"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" = CAST($6::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $7 AND ("j5"."id" IS NOT NULL)) AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $8 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $9 /* traceparent='00-4204664206eb0dfcdd0af733619eef74-3422c06f5f027056-01' */) AS "sub" /* traceparent='00-4204664206eb0dfcdd0af733619eef74-3422c06f5f027056-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("j0"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j1"."patientProfileId") LEFT JOIN "public"."Order" AS "j4" ON ("j4"."id") = ("j0"."orderId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Session" AS "j6" ON ("j6"."id") = ("j0"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") WHERE ("j0"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToPackageSubscription" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ((NOT "j2"."id" = $2) AND ("j1"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL)) AND ("j3"."clinicDomain" = $3 AND ("j3"."id" IS NOT NULL)) AND "j1"."createdAt" >= $4 AND "j1"."createdAt" <= $5 AND "j1"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR (("j5"."clinicDomain" = $7 AND ("j5"."id" IS NOT NULL)) AND "j4"."createdAt" >= $8 AND "j4"."createdAt" <= $9 AND ("j4"."id" IS NOT NULL)) OR ("j6"."branchId" = $10 AND ("j7"."clinicDomain" = $11 AND ("j7"."id" IS NOT NULL)) AND "j6"."date" >= $12 AND "j6"."date" <= $13 AND "j6"."status" <> CAST($14::text AS "public"."SessionStatus") AND ("j6"."id" IS NOT NULL))) AND "j0"."status" = CAST($15::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $16 /* traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-9ecdfa8b1c3aac65-01' */) AS "sub" /* traceparent='00-0490f24aa581d472d36d7ee4b5f99f86-9ecdfa8b1c3aac65-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("j0"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j1"."patientProfileId") LEFT JOIN "public"."Order" AS "j3" ON ("j3"."id") = ("j0"."orderId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j0"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j0"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("j0"."clinicDomain" = $1 AND ((("j2"."clinicDomain" = $2 AND ("j2"."id" IS NOT NULL)) AND "j1"."createdAt" >= $3 AND "j1"."createdAt" <= $4 AND "j1"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR (("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND "j3"."createdAt" >= $7 AND "j3"."createdAt" <= $8 AND ("j3"."id" IS NOT NULL)) OR ("j5"."status" <> CAST($9::text AS "public"."SessionStatus") AND ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL)) AND "j5"."date" >= $11 AND "j5"."date" <= $12 AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $13 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND "j0"."status" = CAST($14::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $15 /* traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-a3f43f97e90112ba-01' */) AS "sub" /* traceparent='00-3b47e0a76859f9e85fcf0c196b3cfab9-a3f43f97e90112ba-01' */

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") WHERE (((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $1) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $2 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $3 AND "j0"."createdAt" <= $4 AND "j0"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $6 AND "j3"."branchId" = $7 AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND "j3"."date" >= $9 AND "j3"."date" <= $10 AND "j3"."status" <> CAST($11::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL))) AND "public"."Invoice"."status" = CAST($12::text AS "public"."InvoiceStatus")) OFFSET $13 /* traceparent='00-777da4fe7fb1f79e9be077262e07c594-9fa25b42c5bd1eed-01' */) AS "sub" /* traceparent='00-777da4fe7fb1f79e9be077262e07c594-9fa25b42c5bd1eed-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j2" ON ("j2"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL)) AND "j0"."createdAt" >= $3 AND "j0"."createdAt" <= $4 AND "j0"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j2"."status" <> CAST($6::text AS "public"."SessionStatus") AND ("j3"."clinicDomain" = $7 AND ("j3"."id" IS NOT NULL)) AND "j2"."date" >= $8 AND "j2"."date" <= $9 AND ("j2"."id" IS NOT NULL)))) OFFSET $10 /* traceparent='00-4204664206eb0dfcdd0af733619eef74-3f68768f9336f114-01' */) AS "sub" /* traceparent='00-4204664206eb0dfcdd0af733619eef74-3f68768f9336f114-01' */

SELECT "public"."WeightTracking"."id", "public"."WeightTracking"."weightId", "public"."WeightTracking"."heightId", "public"."WeightTracking"."nutritionProfileId", "public"."WeightTracking"."dietId", "public"."WeightTracking"."dietInDetails", "public"."WeightTracking"."files", "public"."WeightTracking"."water", "public"."WeightTracking"."sleep", "public"."WeightTracking"."exercise", "public"."WeightTracking"."stress", "public"."WeightTracking"."muscles", "public"."WeightTracking"."fat", "public"."WeightTracking"."abdominalObesity", "public"."WeightTracking"."patientDietId", "public"."WeightTracking"."sessionId", "public"."WeightTracking"."createdAt", "public"."WeightTracking"."updatedAt" FROM "public"."WeightTracking" LEFT JOIN "public"."VariablePropertyValue" AS "orderby_1" ON ("orderby_1"."id") = ("public"."WeightTracking"."weightId") LEFT JOIN "public"."NutritionProfile" AS "j0" ON ("j0"."id") = ("public"."WeightTracking"."nutritionProfileId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") WHERE ("public"."WeightTracking"."nutritionProfileId" = $1 AND ("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL) AND ("j0"."id" IS NOT NULL))) ORDER BY "orderby_1"."createdAt" DESC LIMIT $3 OFFSET $4 /* traceparent='00-e7c4b4228a3d9e5562b37e1e5aadd564-e929d61f05f30d8b-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Order" AS "j6" ON ("j6"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" NOT IN (CAST($1::text AS "public"."PaymentMethod"),CAST($2::text AS "public"."PaymentMethod")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 AND ((("j3"."clinicDomain" = $7 AND ("j3"."id" IS NOT NULL) AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" = CAST($8::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $9 AND ("j5"."id" IS NOT NULL)) AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $10 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $11 /* traceparent='00-ff16bf76e448ce5f3012aa56279297e7-64a1d564c21720e7-01' */) AS "sub" /* traceparent='00-ff16bf76e448ce5f3012aa56279297e7-64a1d564c21720e7-01' */

SELECT "public"."PrescriptionUnit"."id", "public"."PrescriptionUnit"."isTemplate", "public"."PrescriptionUnit"."medicineId", "public"."PrescriptionUnit"."repetitionId", "public"."PrescriptionUnit"."periodId", "public"."PrescriptionUnit"."noteId", "public"."PrescriptionUnit"."order", "public"."PrescriptionUnit"."clinicDomain", "public"."PrescriptionUnit"."createdAt", "public"."PrescriptionUnit"."updatedAt" FROM "public"."PrescriptionUnit" LEFT JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("public"."PrescriptionUnit"."medicineId") LEFT JOIN "public"."UniqueText" AS "j1" ON ("j1"."id") = ("public"."PrescriptionUnit"."repetitionId") LEFT JOIN "public"."UniqueText" AS "j2" ON ("j2"."id") = ("public"."PrescriptionUnit"."periodId") LEFT JOIN "public"."UniqueText" AS "j3" ON ("j3"."id") = ("public"."PrescriptionUnit"."noteId") WHERE ("public"."PrescriptionUnit"."clinicDomain" = $1 AND ("j0"."text" = $2 AND "j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND ("j1"."text" = $4 AND "j1"."clinicDomain" = $5 AND ("j1"."id" IS NOT NULL)) AND ("j2"."text" = $6 AND "j2"."clinicDomain" = $7 AND ("j2"."id" IS NOT NULL)) AND ("j3"."text" = $8 AND "j3"."clinicDomain" = $9 AND ("j3"."id" IS NOT NULL))) LIMIT $10 OFFSET $11 /* traceparent='00-4443d3b33415eb4554659c48a2939b85-38e56fd95c00dfdb-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") LEFT JOIN "public"."Order" AS "j6" ON ("j6"."id") = ("j1"."orderId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND "public"."PaymentTransaction"."amount" < $4 AND ((("j3"."clinicDomain" = $5 AND ("j3"."id" IS NOT NULL) AND ("j2"."id" IS NOT NULL)) OR ("j4"."status" = CAST($6::text AS "public"."SessionStatus") AND ("j5"."clinicDomain" = $7 AND ("j5"."id" IS NOT NULL)) AND ("j4"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $8 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $9 /* traceparent='00-ff16bf76e448ce5f3012aa56279297e7-2666eeb6e1599722-01' */) AS "sub" /* traceparent='00-ff16bf76e448ce5f3012aa56279297e7-2666eeb6e1599722-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE (EXISTS(SELECT "t0"."A" FROM "public"."_SessionToUniqueText" AS "t0" INNER JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ($3=$4 AND ("public"."Session"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) AND "public"."Session"."clinicDomain" = $1) OFFSET $2 /* traceparent='00-e45ef7a800318ade551aff628e0c03b6-737fe605407cdcf4-01' */) AS "sub"

SELECT SUM("total") AS "_sum$total" FROM (SELECT "public"."Invoice"."total" FROM "public"."Invoice" LEFT JOIN "public"."Session" AS "j0" ON ("j0"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") WHERE (("j0"."status" <> CAST($1::text AS "public"."SessionStatus") AND ("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL)) AND "j0"."date" >= $3 AND "j0"."date" <= $4 AND ("j0"."id" IS NOT NULL)) AND "public"."Invoice"."clinicDomain" = $5) OFFSET $6 /* traceparent='00-4204664206eb0dfcdd0af733619eef74-98dd185f4abb3986-01' */) AS "sub" /* traceparent='00-4204664206eb0dfcdd0af733619eef74-98dd185f4abb3986-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE ("public"."Session"."from" >= $1 AND "public"."Session"."from" <= $2 AND "public"."Session"."status" NOT IN (CAST($3::text AS "public"."SessionStatus"),CAST($4::text AS "public"."SessionStatus")) AND EXISTS(SELECT "t0"."B" FROM "public"."_ExaminationToSession" AS "t0" INNER JOIN "public"."Examination" AS "j0" ON ("j0"."id") = ("t0"."A") WHERE ("j0"."id" = $5 AND ("public"."Session"."id") = ("t0"."B") AND "t0"."B" IS NOT NULL))) OFFSET $6 /* traceparent='00-e36f55eaa95fb5ee4b8b68037d09613f-58298878a78f8d38-01' */) AS "sub" /* traceparent='00-e36f55eaa95fb5ee4b8b68037d09613f-58298878a78f8d38-01' */

SELECT "public"."Session"."id", "public"."Session"."patientProfileId", "public"."Session"."doctorId", "public"."Session"."assistantId", "public"."Session"."referralDoctorId", "public"."Session"."number", "public"."Session"."date", "public"."Session"."from", "public"."Session"."to", "public"."Session"."shiftId", "public"."Session"."note", "public"."Session"."totalTimeInSec", "public"."Session"."clinicDomain", "public"."Session"."isWhatsAppNotificationSentHour", "public"."Session"."isWhatsAppNotificationSentTenMin", "public"."Session"."isPatientInWaitingRoom", "public"."Session"."patientInWaitingRoomFrom", "public"."Session"."startTime", "public"."Session"."endTime", "public"."Session"."order", "public"."Session"."timeType"::text, "public"."Session"."status"::text, "public"."Session"."branchId", "public"."Session"."createdAt", "public"."Session"."updatedAt", "public"."Session"."packageSubscriptionId", "public"."Session"."link", "public"."Session"."confirmedAt", "public"."Session"."specialty"::text, "public"."Session"."cancellationReason", "public"."Session"."cancellationDate", "public"."Session"."generalTags", "public"."Session"."expectedTotalTime", "public"."Session"."treatmentPlanId", "public"."Session"."patientJourneyId" FROM "public"."Session" WHERE (EXISTS(SELECT "t0"."A" FROM "public"."_SessionComplaints" AS "t0" INNER JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ($4=$5 AND ("public"."Session"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) AND "public"."Session"."clinicDomain" = $1) ORDER BY "public"."Session"."createdAt" DESC LIMIT $2 OFFSET $3

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE ("public"."Session"."from" >= $1 AND "public"."Session"."from" <= $2 AND "public"."Session"."clinicDomain" = $3) OFFSET $4 /* traceparent='00-13659963b5616fc87634e7a08c293e9e-0c0441193e664514-01' */) AS "sub" /* traceparent='00-13659963b5616fc87634e7a08c293e9e-0c0441193e664514-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE ("public"."Session"."from" >= $1 AND "public"."Session"."from" <= $2 AND "public"."Session"."status" = CAST($3::text AS "public"."SessionStatus") AND EXISTS(SELECT "t0"."B" FROM "public"."_ExaminationToSession" AS "t0" INNER JOIN "public"."Examination" AS "j0" ON ("j0"."id") = ("t0"."A") WHERE ("j0"."id" = $4 AND ("public"."Session"."id") = ("t0"."B") AND "t0"."B" IS NOT NULL))) OFFSET $5 /* traceparent='00-e36f55eaa95fb5ee4b8b68037d09613f-b08d3edcf3f41c78-01' */) AS "sub" /* traceparent='00-e36f55eaa95fb5ee4b8b68037d09613f-b08d3edcf3f41c78-01' */

SELECT "public"."Attendance"."id", "public"."Attendance"."attendanceAt", "public"."Attendance"."leaveAt", "public"."Attendance"."dailySalary", "public"."Attendance"."hourlySalary", "public"."Attendance"."latitude", "public"."Attendance"."longitude", "public"."Attendance"."address", "public"."Attendance"."checkOutLatitude", "public"."Attendance"."checkOutLongitude", "public"."Attendance"."checkOutAddress", "public"."Attendance"."checkInDeviceInfo", "public"."Attendance"."notes", "public"."Attendance"."status"::text, "public"."Attendance"."branchId", "public"."Attendance"."userId", "public"."Attendance"."clinicDomain" FROM "public"."Attendance" WHERE ("public"."Attendance"."attendanceAt" >= $1 AND "public"."Attendance"."attendanceAt" <= $2 AND "public"."Attendance"."branchId" = $3 AND "public"."Attendance"."userId" = $4 AND "public"."Attendance"."clinicDomain" = $5) ORDER BY "public"."Attendance"."attendanceAt" DESC LIMIT $6 OFFSET $7 /* traceparent='00-695e3b454ecc8c3e501722ef9f462d03-989f65ca78de732f-01' */

CREATE INDEX CONCURRENTLY ON Attendance (branchId)

Rows: 7392
Row progression: 7392, 25

Row estimates
- branchId (=): 25
- userId (=): 29
- clinicDomain (=): 59
- attendanceAt (<=): 739
- attendanceAt (>=): 739
- attendanceAt (sort): 1

Existing indexes
- id PRIMARY

UPDATE "public"."Invoice" SET "status" = CAST($1::text AS "public"."InvoiceStatus"), "updatedAt" = $2 WHERE ("public"."Invoice"."status" = CAST($3::text AS "public"."InvoiceStatus") AND EXISTS(SELECT "t0"."id" FROM "public"."Session" AS "t0" WHERE ("t0"."status" = CAST($4::text AS "public"."SessionStatus") AND ("public"."Invoice"."sessionId") = ("t0"."id") AND "t0"."id" IS NOT NULL))) /* traceparent='00-a22dab0740be88f907a259ca6ce18857-bfb235ac9e4aa84a-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("j0"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j1"."patientProfileId") LEFT JOIN "public"."Order" AS "j3" ON ("j3"."id") = ("j0"."orderId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j0"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("j0"."clinicDomain" = $1 AND ((("j2"."clinicDomain" = $2 AND ("j2"."id" IS NOT NULL)) AND "j1"."createdAt" >= $3 AND "j1"."createdAt" <= $4 AND "j1"."status" <> CAST($5::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR (("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND "j3"."createdAt" >= $7 AND "j3"."createdAt" <= $8 AND ("j3"."id" IS NOT NULL)) OR ("j5"."status" <> CAST($9::text AS "public"."SessionStatus") AND ("j6"."clinicDomain" = $10 AND ("j6"."id" IS NOT NULL)) AND "j5"."date" >= $11 AND "j5"."date" <= $12 AND ("j5"."id" IS NOT NULL))) AND "j0"."status" = CAST($13::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $14 /* traceparent='00-4204664206eb0dfcdd0af733619eef74-774e75aa9eedcb99-01' */) AS "sub" /* traceparent='00-4204664206eb0dfcdd0af733619eef74-774e75aa9eedcb99-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j5" ON ("j5"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."branchId" = $7 AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND "j3"."date" >= $9 AND "j3"."date" <= $10 AND "j3"."status" <> CAST($11::text AS "public"."SessionStatus") AND ("j3"."id" IS NOT NULL)) OR ("j6"."clinicDomain" = $12 AND ("j6"."id" IS NOT NULL) AND ("j5"."id" IS NOT NULL)))) OFFSET $13 /* traceparent='00-25537bdecb8e0a5ed9181e6f6bba96f2-df150f7a6f8bccf2-01' */) AS "sub" /* traceparent='00-25537bdecb8e0a5ed9181e6f6bba96f2-df150f7a6f8bccf2-01' */

SELECT "public"."PackageSubscription"."id", "public"."PackageSubscription"."packageId", "public"."PackageSubscription"."patientProfileId", "public"."PackageSubscription"."invoiceId", "public"."PackageSubscription"."doctorId", "public"."PackageSubscription"."assistantId", "public"."PackageSubscription"."referralDoctorId", "public"."PackageSubscription"."status"::text, "public"."PackageSubscription"."startDate", "public"."PackageSubscription"."endDate", "public"."PackageSubscription"."createdAt", "public"."PackageSubscription"."updatedAt", "public"."PackageSubscription"."finishedAt", "public"."PackageSubscription"."shiftId", "public"."PackageSubscription"."patientInsuranceId", "public"."PackageSubscription"."mainBranchId" FROM "public"."PackageSubscription" LEFT JOIN "public"."Package" AS "j2" ON ("j2"."id") = ("public"."PackageSubscription"."packageId") WHERE ("public"."PackageSubscription"."patientProfileId" = $1 AND (EXISTS(SELECT "t0"."B" FROM "public"."_BranchToPackageSubscription" AS "t0" INNER JOIN "public"."Branch" AS "j0" ON ("j0"."id") = ("t0"."A") WHERE ("j0"."id" = $2 AND ("public"."PackageSubscription"."id") = ("t0"."B") AND "t0"."B" IS NOT NULL)) OR NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ($7=$8 AND ("public"."PackageSubscription"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL))) AND "public"."PackageSubscription"."status" = CAST($3::text AS "public"."PackageSubscriptionStatus") AND (EXISTS(SELECT "t3"."packageId" FROM "public"."PackageUnit" AS "t3" WHERE ("t3"."examinationId" IN ($4) AND ("j2"."id") = ("t3"."packageId") AND "t3"."packageId" IS NOT NULL)) AND ("j2"."id" IS NOT NULL))) LIMIT $5 OFFSET $6

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE ("public"."Session"."from" >= $1 AND "public"."Session"."from" <= $2 AND "public"."Session"."clinicDomain" = $3 AND "public"."Session"."status" IN (CAST($4::text AS "public"."SessionStatus"),CAST($5::text AS "public"."SessionStatus"))) OFFSET $6 /* traceparent='00-13659963b5616fc87634e7a08c293e9e-85c58af1485ae41d-01' */) AS "sub" /* traceparent='00-13659963b5616fc87634e7a08c293e9e-85c58af1485ae41d-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."Invoice" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j1" ON ("j1"."invoiceId") = ("j0"."id") LEFT JOIN "public"."PatientProfile" AS "j3" ON ("j3"."id") = ("j1"."patientProfileId") LEFT JOIN "public"."Session" AS "j4" ON ("j4"."id") = ("j0"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j5" ON ("j5"."id") = ("j4"."patientProfileId") WHERE ("j0"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t2"."B" FROM "public"."_BranchToPackageSubscription" AS "t2" INNER JOIN "public"."Branch" AS "j2" ON ("j2"."id") = ("t2"."A") WHERE ((NOT "j2"."id" = $2) AND ("j1"."id") = ("t2"."B") AND "t2"."B" IS NOT NULL)) AND "j1"."doctorId" = $3 AND ("j3"."clinicDomain" = $4 AND ("j3"."id" IS NOT NULL)) AND "j1"."createdAt" >= $5 AND "j1"."createdAt" <= $6 AND "j1"."status" <> CAST($7::text AS "public"."PackageSubscriptionStatus") AND ("j1"."id" IS NOT NULL)) OR ("j4"."doctorId" = $8 AND "j4"."branchId" = $9 AND ("j5"."clinicDomain" = $10 AND ("j5"."id" IS NOT NULL)) AND "j4"."date" >= $11 AND "j4"."date" <= $12 AND "j4"."status" <> CAST($13::text AS "public"."SessionStatus") AND ("j4"."id" IS NOT NULL))) AND "j0"."status" = CAST($14::text AS "public"."InvoiceStatus") AND ("j0"."id" IS NOT NULL)) OFFSET $15 /* traceparent='00-82a429e1bf5aeb58407cc4fbdf858041-4a532786411ad535-01' */) AS "sub" /* traceparent='00-82a429e1bf5aeb58407cc4fbdf858041-4a532786411ad535-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."TreasuryTransaction"."id" FROM "public"."TreasuryTransaction" LEFT JOIN "public"."Treasury" AS "j0" ON ("j0"."id") = ("public"."TreasuryTransaction"."treasuryId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."TreasuryTransaction"."createdAt" >= $2 AND "public"."TreasuryTransaction"."createdAt" <= $3) OFFSET $4 /* traceparent='00-752423796cb0756202a2de36841799d4-74e81b822eaf2ce3-01' */) AS "sub" /* traceparent='00-752423796cb0756202a2de36841799d4-74e81b822eaf2ce3-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."TreasuryTransaction"."amount" FROM "public"."TreasuryTransaction" LEFT JOIN "public"."Treasury" AS "j0" ON ("j0"."id") = ("public"."TreasuryTransaction"."treasuryId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."TreasuryTransaction"."createdAt" >= $2 AND "public"."TreasuryTransaction"."createdAt" <= $3 AND "public"."TreasuryTransaction"."amount" > $4) OFFSET $5 /* traceparent='00-752423796cb0756202a2de36841799d4-d37e274e9bb2d68c-01' */) AS "sub" /* traceparent='00-752423796cb0756202a2de36841799d4-d37e274e9bb2d68c-01' */

SELECT "public"."Session"."id", "public"."Session"."patientProfileId", "public"."Session"."doctorId", "public"."Session"."assistantId", "public"."Session"."referralDoctorId", "public"."Session"."number", "public"."Session"."date", "public"."Session"."from", "public"."Session"."to", "public"."Session"."shiftId", "public"."Session"."note", "public"."Session"."totalTimeInSec", "public"."Session"."clinicDomain", "public"."Session"."isWhatsAppNotificationSentHour", "public"."Session"."isWhatsAppNotificationSentTenMin", "public"."Session"."isPatientInWaitingRoom", "public"."Session"."patientInWaitingRoomFrom", "public"."Session"."startTime", "public"."Session"."endTime", "public"."Session"."order", "public"."Session"."timeType"::text, "public"."Session"."status"::text, "public"."Session"."branchId", "public"."Session"."createdAt", "public"."Session"."updatedAt", "public"."Session"."packageSubscriptionId", "public"."Session"."link", "public"."Session"."confirmedAt", "public"."Session"."specialty"::text, "public"."Session"."cancellationReason", "public"."Session"."cancellationDate", "public"."Session"."generalTags", "public"."Session"."expectedTotalTime", "public"."Session"."treatmentPlanId", "public"."Session"."patientJourneyId" FROM "public"."Session" WHERE (EXISTS(SELECT "t0"."A" FROM "public"."_SessionToUniqueText" AS "t0" INNER JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ($4=$5 AND ("public"."Session"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) AND "public"."Session"."clinicDomain" = $1) ORDER BY "public"."Session"."createdAt" DESC LIMIT $2 OFFSET $3

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Session"."id" FROM "public"."Session" WHERE (EXISTS(SELECT "t0"."A" FROM "public"."_SessionComplaints" AS "t0" INNER JOIN "public"."UniqueText" AS "j0" ON ("j0"."id") = ("t0"."B") WHERE ($3=$4 AND ("public"."Session"."id") = ("t0"."A") AND "t0"."A" IS NOT NULL)) AND "public"."Session"."clinicDomain" = $1) OFFSET $2 /* traceparent='00-8f40be53350570a89b794442440b41d4-00f1abd94af7959b-01' */) AS "sub"

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor" FROM (SELECT "public"."PaymentTransaction"."forDoctor", "public"."PaymentTransaction"."forAssistant", "public"."PaymentTransaction"."forReferralDoctor" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $4) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $5 AND ("j4"."id" IS NOT NULL)) AND "j2"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $7 AND "j5"."branchId" = $8 AND ("j6"."clinicDomain" = $9 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $10 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $11 /* traceparent='00-480cf48d7ad616b30a596c71833667e7-e2ca7523df73cac0-01' */) AS "sub" /* traceparent='00-480cf48d7ad616b30a596c71833667e7-e2ca7523df73cac0-01' */

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."Invoice"."id" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."Order" AS "j2" ON ("j2"."id") = ("public"."Invoice"."orderId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") WHERE (((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $1) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND "j0"."status" <> CAST($2::text AS "public"."PackageSubscriptionStatus") AND "j0"."startDate" >= $3 AND "j0"."startDate" <= $4 AND ("j0"."id" IS NOT NULL)) OR ("j2"."branchId" = $5 AND "j2"."createdAt" >= $6 AND "j2"."createdAt" <= $7 AND ("j2"."id" IS NOT NULL)) OR ("j3"."date" >= $8 AND "j3"."date" <= $9 AND "j3"."status" <> CAST($10::text AS "public"."SessionStatus") AND "j3"."branchId" = $11 AND ("j3"."id" IS NOT NULL))) AND "public"."Invoice"."clinicDomain" = $12) OFFSET $13 /* traceparent='00-2fd8797e9acd82644868fffaca8c7630-702fe5a7fc67e42e-01' */) AS "sub" /* traceparent='00-2fd8797e9acd82644868fffaca8c7630-702fe5a7fc67e42e-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE (("j0"."clinicDomain" = $1 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $2 AND "public"."PaymentTransaction"."createdAt" <= $3 AND "public"."PaymentTransaction"."amount" < $4 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $5) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $6 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $7 AND "j5"."branchId" = $8 AND ("j6"."clinicDomain" = $9 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $10 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $11 /* traceparent='00-480cf48d7ad616b30a596c71833667e7-6e756edbab6e3a9a-01' */) AS "sub" /* traceparent='00-480cf48d7ad616b30a596c71833667e7-6e756edbab6e3a9a-01' */

SELECT "public"."PatientProfile"."id", "public"."PatientProfile"."avatar", "public"."PatientProfile"."name", "public"."PatientProfile"."phone", "public"."PatientProfile"."phoneCode", "public"."PatientProfile"."email", "public"."PatientProfile"."address", "public"."PatientProfile"."patientIndex", "public"."PatientProfile"."taxApplicable", "public"."PatientProfile"."freeNote", "public"."PatientProfile"."city", "public"."PatientProfile"."state", "public"."PatientProfile"."zip", "public"."PatientProfile"."country", "public"."PatientProfile"."nationalId", "public"."PatientProfile"."source", "public"."PatientProfile"."longitude", "public"."PatientProfile"."latitude", "public"."PatientProfile"."birthday", "public"."PatientProfile"."note", "public"."PatientProfile"."weight", "public"."PatientProfile"."type"::text, "public"."PatientProfile"."firstSessionDate", "public"."PatientProfile"."lastSessionDate", "public"."PatientProfile"."isActive", "public"."PatientProfile"."medicalHistory", "public"."PatientProfile"."clinicDomain", "public"."PatientProfile"."createdAt", "public"."PatientProfile"."updatedAt", "public"."PatientProfile"."referralDoctorId", "public"."PatientProfile"."whatsappCampaignId", "public"."PatientProfile"."link", "public"."PatientProfile"."branchId", "public"."PatientProfile"."petType", "public"."PatientProfile"."color", "public"."PatientProfile"."petStatus", "public"."PatientProfile"."petBreed", "public"."PatientProfile"."petName", "public"."PatientProfile"."isVaccinated", "public"."PatientProfile"."totalPayed", "public"."PatientProfile"."totalPayments", "public"."PatientProfile"."totalPaymentsRest", "public"."PatientProfile"."totalUpcomingPayments", "public"."PatientProfile"."telegramChatId", "public"."PatientProfile"."telegramUsername" FROM "public"."PatientProfile" WHERE (("public"."PatientProfile"."name" ILIKE $1 OR "public"."PatientProfile"."phone" ILIKE $2 OR "public"."PatientProfile"."phone" ILIKE $3 OR "public"."PatientProfile"."patientIndex" = $4) AND "public"."PatientProfile"."clinicDomain" = $5) ORDER BY "public"."PatientProfile"."isActive" DESC, "public"."PatientProfile"."createdAt" DESC LIMIT $6 OFFSET $7 /* traceparent='00-6a6da4476e98aa3e271750472b1652c5-1160147cc312df8f-01' */

SELECT "public"."PackageSubscription"."id", "public"."PackageSubscription"."packageId", "public"."PackageSubscription"."patientProfileId", "public"."PackageSubscription"."invoiceId", "public"."PackageSubscription"."doctorId", "public"."PackageSubscription"."assistantId", "public"."PackageSubscription"."referralDoctorId", "public"."PackageSubscription"."status"::text, "public"."PackageSubscription"."isOnHold", "public"."PackageSubscription"."startDate", "public"."PackageSubscription"."endDate", "public"."PackageSubscription"."effectiveEndDate", "public"."PackageSubscription"."createdAt", "public"."PackageSubscription"."updatedAt", "public"."PackageSubscription"."finishedAt", "public"."PackageSubscription"."shiftId", "public"."PackageSubscription"."patientInsuranceId", "public"."PackageSubscription"."mainBranchId" FROM "public"."PackageSubscription" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PackageSubscription"."patientProfileId") WHERE ("public"."PackageSubscription"."status" IN (CAST($1::text AS "public"."PackageSubscriptionStatus"),CAST($2::text AS "public"."PackageSubscriptionStatus"),CAST($3::text AS "public"."PackageSubscriptionStatus")) AND ("j0"."clinicDomain" = $4 AND ("j0"."id" IS NOT NULL))) ORDER BY "public"."PackageSubscription"."createdAt" DESC LIMIT $5 OFFSET $6 /* traceparent='00-ee83e244057d16129207e0f385238224-15bfe0cca71e1bae-01' */

SELECT SUM("amount") AS "_sum$amount" FROM (SELECT "public"."PaymentTransaction"."amount" FROM "public"."PaymentTransaction" LEFT JOIN "public"."PatientProfile" AS "j0" ON ("j0"."id") = ("public"."PaymentTransaction"."patientProfileId") LEFT JOIN "public"."Invoice" AS "j1" ON ("j1"."id") = ("public"."PaymentTransaction"."invoiceId") LEFT JOIN "public"."PackageSubscription" AS "j2" ON ("j2"."invoiceId") = ("j1"."id") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j2"."patientProfileId") LEFT JOIN "public"."Session" AS "j5" ON ("j5"."id") = ("j1"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j6" ON ("j6"."id") = ("j5"."patientProfileId") LEFT JOIN "public"."Accommodation" AS "j7" ON ("j7"."id") = ("j1"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j8" ON ("j8"."id") = ("j7"."patientProfileId") WHERE ("public"."PaymentTransaction"."method" NOT IN (CAST($1::text AS "public"."PaymentMethod"),CAST($2::text AS "public"."PaymentMethod")) AND ("j0"."clinicDomain" = $3 AND ("j0"."id" IS NOT NULL)) AND "public"."PaymentTransaction"."createdAt" >= $4 AND "public"."PaymentTransaction"."createdAt" <= $5 AND "public"."PaymentTransaction"."amount" >= $6 AND (((NOT EXISTS(SELECT "t3"."B" FROM "public"."_BranchToPackageSubscription" AS "t3" INNER JOIN "public"."Branch" AS "j3" ON ("j3"."id") = ("t3"."A") WHERE ((NOT "j3"."id" = $7) AND ("j2"."id") = ("t3"."B") AND "t3"."B" IS NOT NULL)) AND ("j4"."clinicDomain" = $8 AND ("j4"."id" IS NOT NULL)) AND ("j2"."id" IS NOT NULL)) OR ("j5"."doctorId" = $9 AND "j5"."branchId" = $10 AND ("j6"."clinicDomain" = $11 AND ("j6"."id" IS NOT NULL)) AND ("j5"."id" IS NOT NULL)) OR ("j8"."clinicDomain" = $12 AND ("j8"."id" IS NOT NULL) AND ("j7"."id" IS NOT NULL))) AND ("j1"."id" IS NOT NULL))) OFFSET $13 /* traceparent='00-480cf48d7ad616b30a596c71833667e7-75a4be2f908332a2-01' */) AS "sub" /* traceparent='00-480cf48d7ad616b30a596c71833667e7-75a4be2f908332a2-01' */

SELECT SUM("forDoctor") AS "_sum$forDoctor", SUM("forAssistant") AS "_sum$forAssistant", SUM("forReferralDoctor") AS "_sum$forReferralDoctor", SUM("consumablesTotal") AS "_sum$consumablesTotal", SUM("forManagers") AS "_sum$forManagers" FROM (SELECT "public"."Invoice"."forDoctor", "public"."Invoice"."forAssistant", "public"."Invoice"."forReferralDoctor", "public"."Invoice"."consumablesTotal", "public"."Invoice"."forManagers" FROM "public"."Invoice" LEFT JOIN "public"."PackageSubscription" AS "j0" ON ("j0"."invoiceId") = ("public"."Invoice"."id") LEFT JOIN "public"."PatientProfile" AS "j2" ON ("j2"."id") = ("j0"."patientProfileId") LEFT JOIN "public"."Session" AS "j3" ON ("j3"."id") = ("public"."Invoice"."sessionId") LEFT JOIN "public"."PatientProfile" AS "j4" ON ("j4"."id") = ("j3"."patientProfileId") LEFT JOIN "public"."User" AS "j5" ON ("j5"."id") = ("j3"."doctorId") LEFT JOIN "public"."Accommodation" AS "j6" ON ("j6"."id") = ("public"."Invoice"."accommodationId") LEFT JOIN "public"."PatientProfile" AS "j7" ON ("j7"."id") = ("j6"."patientProfileId") WHERE ("public"."Invoice"."clinicDomain" = $1 AND ((NOT EXISTS(SELECT "t1"."B" FROM "public"."_BranchToPackageSubscription" AS "t1" INNER JOIN "public"."Branch" AS "j1" ON ("j1"."id") = ("t1"."A") WHERE ((NOT "j1"."id" = $2) AND ("j0"."id") = ("t1"."B") AND "t1"."B" IS NOT NULL)) AND ("j2"."clinicDomain" = $3 AND ("j2"."id" IS NOT NULL)) AND "j0"."createdAt" >= $4 AND "j0"."createdAt" <= $5 AND "j0"."status" <> CAST($6::text AS "public"."PackageSubscriptionStatus") AND ("j0"."id" IS NOT NULL)) OR ("j3"."doctorId" = $7 AND "j3"."branchId" = $8 AND ("j4"."clinicDomain" = $9 AND ("j4"."id" IS NOT NULL)) AND "j3"."date" >= $10 AND "j3"."date" <= $11 AND "j3"."status" <> CAST($12::text AS "public"."SessionStatus") AND ((NOT $15=$16) AND ("j5"."id" IS NOT NULL)) AND ("j3"."id" IS NOT NULL)) OR ("j7"."clinicDomain" = $13 AND ("j7"."id" IS NOT NULL) AND ("j6"."id" IS NOT NULL)))) OFFSET $14 /* traceparent='00-fdd0a79e152571338ceccac8de31348f-3da1b212a2278fde-01' */) AS "sub"

SELECT COUNT(*) AS "_count$_all" FROM (SELECT "public"."WeightTracking"."id" FROM "public"."WeightTracking" LEFT JOIN "public"."NutritionProfile" AS "j0" ON ("j0"."id") = ("public"."WeightTracking"."nutritionProfileId") LEFT JOIN "public"."PatientProfile" AS "j1" ON ("j1"."id") = ("j0"."patientProfileId") WHERE ("public"."WeightTracking"."nutritionProfileId" = $1 AND ("j1"."clinicDomain" = $2 AND ("j1"."id" IS NOT NULL) AND ("j0"."id" IS NOT NULL))) OFFSET $3 /* traceparent='00-e2e15e93dfc4cbb6f6a76b979b960d65-751954283f5cf637-01' */) AS "sub" /* traceparent='00-e2e15e93dfc4cbb6f6a76b979b960d65-751954283f5cf637-01' */