text: /*
  First derived from View "mgd.prb_strain_genotype_view"
  
  ~ 5 seconds -> I can't wait this long (killed @ 16.5 minutes)
  
  todo re test as it may bave been  an issue on their side
  */
  SELECT
  	psgv._straingenotype_key,
      --s._strain_key,
      psgv._genotype_key as mgi_internal, -- mgitype -> 'Genotype'
      --s._qualifier_key,
      --s._createdby_key,
      --s._modifiedby_key,
      --s.creation_date,
      --s.modification_date,
      psgv.strain,
      psgv.description,
      psgv.mgiid,
      psgv.qualifier
      --u.login AS modifiedby
     FROM prb_strain_genotype_view psgv
  ;
  
  /*
   SELECT s._straingenotype_key,
      s._strain_key,
      s._genotype_key,
      s._qualifier_key,
      ss.strain,
      gs.strain AS description,
      a.accid AS mgiid,
      t.term AS qualifier
     FROM prb_strain_genotype s
      join prb_strain ss on s._strain_key = ss._strain_key 
      join acc_accession a on s._genotype_key = a._object_key 
      join gxd_genotype g on s._genotype_key = g._genotype_key 
      join prb_strain gs on g._strain_key = gs._strain_key 
      join voc_term t on s._qualifier_key = t._term_key 
      join acc_mgitype at on a._mgitype_key =  at._mgitype_key
    WHERE at.name = 'Genotype'
      AND a._logicaldb_key = 1 
  ;
  */
  