Selecting Many with join

I have

public class PersonEntity {
    [AutoIncrement]
    [PrimaryKey]
    public long Id { get; set; }
    [Reference]
    public List<CarEntity> Cars { get; set; } = new List<CarEntity>();

    //...other relations 
}

public class CarEntity{
    [AutoIncrement]
    [PrimaryKey]
    public long Id { get; set; }

    [References(typeof(PersonEntity ))]
    public long PersonId { get ; set ; }

    [Reference]
    public PersonEntity Person { get; set; }

    public string Description {get;set;}
}

I want to select from PersonEntity where Cars.Description contains some string.
I want to get the PersonEntity with all the other relations it has.

Can you please suggest the most efficient approach for that?

Thannks

The general approach is to workout how you’d want to do it in SQL then try to replicate the query in OrmLite. How would you do this with SQL?