Gene Recombination map example query broken

[malcook]

The query documented for gene Recombination map returns 0 rows

i.e.

Code: Select all


SELECT fp.value
  FROM feature f, featureprop fp, cvterm cvt
  WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
    cvt.name = 'promoted_genetic_location' AND f.uniquename = 'FBgn0000011';
------
(0 rows)


c.f. http://gmod.org/wiki/FlyBase_Field_Mapp ... ene_Report

Can fix?

-- Cheers
Malcolm Cook