Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 0.718 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 != '61' and
g.genus = 'Aster'
limit 1
id
162

Aster alpinus 'Dwarf Mix'

Alpine Aster

A mounding perennial with large daisy-like flowers that begin to appear in late spring through summer. Ideal for ground covers, borders and rockeries. Attracts both bees and butterflies to your garden.

  • Violet-blue shades with pink tones and white
  • Spreading, tufted growth habit
  • Great for the rock garden or front of the border

Login for pricing