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

Hemerocallis fulva

Orange Daylily (Tawny Daylily)

Tawny orange flowers. This large species daylily has flower scapes rising from a large clump of thick, arching, blade-like, bright green leaves. A superb colonizer that has naturalized in many parts of the country and is commonly seen growing along roads.

  • Orange flowers with a slightly darker, orange eyezone
  • Green, slender, grass-like foliage
  • Perfect for the sunny border

Login for pricing

b

e

q

j

x

+

d

*

u

8