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

Metasequoia glyptostroboides

Dawn Redwood

A fast-growing narrow, pyramidal, deciduous conifer with soft light-green foliage.

  • Deciduous, coniferous tree
  • Pyramidal, conical habit
  • Soft, flat, green needles
  • Bronze fall color
  • Reddish, exfoliating bark
  • Use as a specimen or in a group

Login for pricing

e

j

x

y

*

8