From 28b9947c645c1c2499c13f241fe26c8520eb2a76 Mon Sep 17 00:00:00 2001
From: Munyoki Kilyungi
Date: Tue, 3 Feb 2026 09:38:31 +0300
Subject: Add missing join.

Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
---
 examples/phenotype.scm | 9 +++++++--
 1 file changed, 7 insertions(+), 2 deletions(-)

diff --git a/examples/phenotype.scm b/examples/phenotype.scm
index b243ccd..690b6a9 100755
--- a/examples/phenotype.scm
+++ b/examples/phenotype.scm
@@ -96,6 +96,7 @@
 (define-transformer gn:trait->gn:phenotype
   (tables (PublishXRef
            (left-join InbredSet "ON InbredSet.InbredSetId = PublishXRef.InbredSetId")
+           (inner-join PublishFreeze "ON PublishFreeze.InbredSetId = InbredSet.Id")
            (left-join Publication "ON Publication.Id = PublishXRef.PublicationId")
            (left-join Phenotype "ON Phenotype.Id = PublishXRef.PhenotypeId"))
           "WHERE InbredSet.public > 0")
@@ -112,7 +113,7 @@
     (set gnt:has_strain (string->identifier "set" (field InbredSet Name InbredSetName) #:separator "_"))
     (set owl:equivalentClass
          (field ("CONCAT(IFNULL(InbredSet.InbredSetCode, PublishXRef.InbredSetId), '_', PublishXRef.Id)"
-                  Phenotype)))
+                 Phenotype)))
     (set dct:references
          (let ((pmid (field
                       ("IF(Publication.PubMed_ID IS NULL, '', CONVERT(Publication.PubMed_Id, INT))"
@@ -183,7 +184,11 @@
       ("xkos:" "<http://rdf-vocabulary.ddialliance.org/xkos#>")
       ("pubmed:" "<http://rdf.ncbi.nlm.nih.gov/pubmed/>")))
    (inputs
-    (list gn:set->gn:dataset gn:dataset->gn:trait gnc:phenotype->gn:phenotype gn:phenotype->metadata gn:trait->gn:phenotype))
+    (list gn:set->gn:dataset
+          gn:dataset->gn:trait
+          gnc:phenotype->gn:phenotype
+          gn:phenotype->metadata
+          gn:trait->gn:phenotype))
    (outputs
     `(#:documentation ,documentation
       #:rdf ,output))))
-- 
cgit 1.4.1