Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 9.17 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
select g.id
from tb_plant_genusoverview_substitutions s
inner join tb_plant_genusOverview g on (g.id = s.genus_id)
where g.delete_date is null and g.isactive = 1 and
g.id != '395' and
g.genus = 'Rhododendron'
limit 1
id
1392

Rhododendron Girard hybrid 'Girard's Pleasant White'

Girard's Pleasant White Azalea

  • Blooming evergreen for woodland gardens
  • Beautiful, trumpet-shaped flowers
  • Loads of flowers
  • Mounding, rounded habit

Login for pricing