Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 4.46 ms
Record Count: 0
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 != '25' and
g.genus = 'Agastache'
limit 1
id

Agastache foeniculum

Anise Hyssop

This upright, clump-forming perennial has attractive spikes of small tubular purple flowers from early summer to early fall. They are attractive to bees, hummingbirds, and butterflies.

  • Green leaves and square stems
  • Lavender to purple flowers
  • Licorice scented foliage
  • Flowers mid-summer to fall

Login for pricing