How to link to the GrainGenes Database

https://wheat.pw.usda.gov/cgi-bin/GG3/sql.cgi?sql=--%20Trait%20Markers%0Aselect%20twopointdata.name%20as%202_Point_Data,%2
0gene.name%20as%20Gene,%20geneclass.name%20as%20Gene_Class%20from%20twopointdata%20left%20join%20genetwopointdata
%20on%20twopointdata.id%20=%20genetwopointdata.twopointdataid%20left%20join%20gene%20on%20genetwopointdata.geneid
%20=%20gene.id%20left%20join%20genegeneclass%20on%20gene.id%20=%20genegeneclass.geneid%20left%20join%20geneclass
%20on%20genegeneclass.geneclassid%20=%20geneclass.id%20where%20twopointdata.traitmarker%20=%201%20order%20by%20twopointdata.name

Which means:

-- Trait Markers
select
  twopointdata.name as 2_Point_Data,
  gene.name as Gene,
  geneclass.name as Gene_Class
from twopointdata
  left join genetwopointdata on twopointdata.id = genetwopointdata.twopointdataid
  left join gene on genetwopointdata.geneid = gene.id
  left join genegeneclass on gene.id = genegeneclass.geneid
  left join geneclass on genegeneclass.geneclassid = geneclass.id
where twopointdata.traitmarker = 1  
order by twopointdata.name