Applying where clause for multiple table before joins using qm.Rels()

[Aaegamysta]

Hi,
I am having trouble figuring out how is it possible to execute where clause on two tables before they are joined using qm.Rels() and qm.Load()
Here is a simple example:
The following tables are defined:

CREATE TABLE `trip` (
  `id` int PRIMARY KEY NOT NULL,
  `ship_id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `active` bool NOT NULL,
);
CREATE TABLE `ship` (
  `id` int PRIMARY KEY NOT NULL,
  `name` varchar(255) NOT NULL,
  `active` bool NOT NULL,
);
CREATE TABLE `ship_media` (
  `id` int PRIMARY KEY NOT NULL,
  `ship_id` int NOT NULL,
  `media_id` int NOT NULL,
  `media_link` varchar(255),
);
CREATE TABLE `media` (
  `id` int PRIMARY KEY NOT NULL,
  `source` varchar(255),
);

What is required is to perform a Where clause filter on both trips and ships using active before they are joined with media.
Now the problem is if I apply a where clause after qm.Rels(...), it will apply only for Media.

joinShipMedia := qm.Load(qm.Rels(models.TripRels.Ship, models.ShipRels.ShipMedia, models.ShipMediumRels.Medium))

Is there a possiblity to perform the filter/ add the where clause before the joins using SQLBoiler?

Thanks!

[stephenafamo]

Let me know if this works:

models.Trips(
  models.TripsWhere.Active.EQ(true),
  qm.Load(models.TripRels.Ship, models.ShipWhere.Active.EQ(true)),
  qm.Load(qm.Rels(models.TripRels.Ship, models.ShipRels.ShipMedia, models.ShipMediumRels.Medium)),
)