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

Abies balsamea 'Nana'

Dwarf Balsam Fir

  • Slow growing, dwarf, rounded conifer
  • Dark green, soft needles
  • Great low growing specimen plant

Login for pricing

A rounded conifer with soft, waxy dark green needles.