| Query Template: /plantsWL/qry_getSubstitutions.cfm:163 Execution Time: 1.18 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 != '119' and g.genus = 'Clematis' limit 1 | ||
| id | ||
| 1 | 120 | |
Clematis 'Niobe'
Niobe Clematis
Produces gorgeous, large, ruby red flowers from June until September.
- Vigorous climber with large, fragrant flowers
- Attractive, dense, dark green foliage