Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 12.9 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
1120

Clematis 'Ville de Lyon'

Ville de Lyon Clematis

A beautiful, rounded, carmine flower with edges of deep crimson.

  • Deep carmine flowers with centers that fade to mauve
  • Wonderful trellised or climbing posts

  • Category: Vine
  • Hardiness Zone: 4
Login for pricing

l

j