<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<disco format="disco.linkout.sql" format-version="1.0">
<site-info site-name="ZFIN"/>
 <technical-contact email="" name=""/>
 <linkout-sql>
 <![CDATA[

 select

'PubMed' as db, 
c.pubmed_id as oid,
'Data: Gene Expression' as linkcategory,
'Zebrafish: ' || a.genotype_name  || '; Phenotype: ' || a.phenotype_keyword_name || ' (' || a.phenotype_modifier || ') ' ||
case when a.affected_structure_or_process_1_superterm_name is null then '' else a.affected_structure_or_process_1_superterm_name end || ' ' || case when a.affected_structure_or_process_1_subterm_name is null then '' else a.affected_structure_or_process_1_subterm_name end
|| case when a.start_stage_name is null then '' else '; Stage: '|| a.start_stage_name end
 as linkname,
'http://zfin.org/action/genotype/detail?genotype.zdbID='||a.genotype_id as linkurl

         
       from l2_nif_0000_21427_data_genotype_phenotype a, l2_nif_0000_21427_data_environment b, l2_nif_0000_21427_data_publication c
        where
        a.environment_id = b.environment_id
        and a.publication_id = c.publication_zfin_id
        and a.genotype_name not like '%AB%'
        and a.genotype_name not like '%C32%'
        and a.genotype_name not like '%Cologne%'
        and a.genotype_name not like '%Darjeeling%'
        and a.genotype_name not like '%Ekkwill%'
        and a.genotype_name not like '%Hong%'
        and a.genotype_name not like '%India%'
        and a.genotype_name not like '%Indonesia%'
        and a.genotype_name not like '%Nadia%'
        and a.genotype_name not like '%RIKEN%'
        and a.genotype_name not like '%Sanger%'
        and a.genotype_name not like '%Sing%'
        and a.genotype_name not like '%Singapore%'
        and a.genotype_name not like '%SJA%'
        and a.genotype_name not like '%SJD%'
        and a.genotype_name not like '%Tuebingen%'
        and a.genotype_name not like '%Tupfel%'
        and a.genotype_name not like '%WIK%'
        and a.genotype_name not like '%wild%'
 and c.pubmed_id not like 'none'
and c.pubmed_id = '14711874'
 ]]>
</linkout-sql>
</disco>
