Results from Plant table
No Results found SELECT plant.idPlant , idCollection , PlantAcc, AccessionName , AccYear , OriginCountry, Comment ,HasImage, plant.SubCollection , PhenotypeParameter , PhenotypeValue , Comment , StoreCode, PhenotypeParameter , PhenotypeValue
FROM `plant`
JOIN `taxon` ON `plant`.idTaxon=`taxon`.idTaxon
JOIN `phenotype` ON `plant`.idPlant=`phenotype`.idPlant
JOIN storeref on plant.idPlant=storeref.idPlant
WHERE (Genus ='Pisum')
AND (PhenotypeParameter='Pods%20per%20Node')
AND (PhenotypeValue='3') . Limit 0, 500