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

Sempervivum tectorum 'Sunset'

Sunset Hen and Chicks

Emerald green leaves with red tips take on orange-red cast in cool fall weather.

  • Semi-open rosettes of fleshy leaves
  • Emerald green leaves, flushed plum in winter
  • Easily offsets

Login for pricing

e

q

j

w

+

t

2

k

{