Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 1.44 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 != '158' and
g.genus = 'Diervilla'
limit 1
id
1159

Diervilla lonicera

Dwarf Bush Honeysuckle

A beautiful plant with honeysuckle-like yellow flowers and foliage that turns red in the fall. North American native plant.

  • Great shrub for the hedge
  • Small, fragrant flowers
  • Vibrant fall colors
  • Mounding, spreading habit

  • Category: Shrub
  • Hardiness Zone: 3-7
  • Height: 30-40 in
  • Spread: 3-4 ft
Login for pricing