ВК
Size: a a a
ВК
АП
ВК
ВК
A
СП
AC
K
И
AC
AC
И
И
СП
AC
AC
T
H
SELECTтипа того я сделал но тут миксуются чаты там где они есть и были итд
"chat"."id" AS "chat_id",
"chat"."name" AS "chat_name",
"chat"."photoURL" AS "chat_photoURL",
"chat"."isGroup" AS "chat_isGroup"
FROM "chat" "chat"
LEFT JOIN "participanceChat" "participance"
ON "participance"."chat_id"="chat"."id"
WHERE "participance"."participant_id" IN ($1, $2)
const _ans = await createQueryBuilder(ChatEntity, "chat")
.where("chat.isGroup = :value", { value: false })
.leftJoin("chat.participance", "participance")
.where("participance.participant_id IN (:...ids)", {
ids: [tokenVer.id, partsUser],
})
.getMany();