Struggling with simple subquery statement in Drizzle

const query = db
        .select({
            ...
        })
        .from(leads)
        .innerJoin(participants, eq(participants.id, leads.participantId))
        .innerJoin(campaigns, eq(campaigns.id, leads.campaignId))
        .leftJoin(agents, eq(agents.id, leads.agentId))
        .leftJoin(sites, eq(sites.id, leads.siteId))
        .leftJoin(studies, eq(studies.id, leads.studyId))
        .where((t) => {
            const conditions = [eq(campaigns.organizationId, organizationId)];

            ...

            return and(...conditions);
        })
        .as('query');

const query = db
        .select({
            ...
        })
        .from(leads)
        .innerJoin(participants, eq(participants.id, leads.participantId))
        .innerJoin(campaigns, eq(campaigns.id, leads.campaignId))
        .leftJoin(agents, eq(agents.id, leads.agentId))
        .leftJoin(sites, eq(sites.id, leads.siteId))
        .leftJoin(studies, eq(studies.id, leads.studyId))
        .where((t) => {
            const conditions = [eq(campaigns.organizationId, organizationId)];

            ...

            return and(...conditions);
        })
        .as('query');

const [{ count: total }] = await db.select({ count: count() }).from(query);

    const basicLeads = await db
        .select()
        .from(query)
        .where((t) =>
            participantIds
                ? inArray(t.participantId, participantIds)
                : undefined
        )
        .limit(perPage)
        .offset(Math.max(0, page - 1) * perPage);

const [{ count: total }] = await db.select({ count: count() }).from(query);

    const basicLeads = await db
        .select()
        .from(query)
        .where((t) =>
            participantIds
                ? inArray(t.participantId, participantIds)
                : undefined
        )
        .limit(perPage)
        .offset(Math.max(0, page - 1) * perPage);