Drizzle Query, Relationship Sub-Query

I have Domains and Products, and a pivot between them (DomainProducts).

I'd like to query (

findFirst

findFirst

) the

DomainProducts

DomainProducts

where

DomainProducts.Slug='hello-world'

DomainProducts.Slug='hello-world'

and

DomainProducts.Domain.Url='mydomain.com'

DomainProducts.Domain.Url='mydomain.com'

Is that possible? It seems like it's not possible to do it with the Query, instead I have to use it like a normal Select and manually do the join?