Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 1.15 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 'The Frist Lady'

The First Lady Clematis

Silvery, lavender-blue flowers with reddish purple stamens are produced in late spring and again in early fall. Opens with a darker central bar that lightens with age.

  • Vigorous climber with large, fragrant flowers
  • Attractive, dense, dark green foliage

Login for pricing
Attracts Wildlife
Attracts Butterflies
Attracts Humming-birds
Exposure
Full Sun
Partial Sun
Foliage Color
Green
Soil Moisture
Moist, Well-Drained
Attributes
Climbing
Great Foliage
Season of Interest (Flowering)
Summer
Season of Interest (Foliage)
Fall
Summer