Query
Template: /consoleAssets/gardenlandTheme/plants/dsp_plantDetail.cfm:38
Execution Time: 7.15 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
select p.friendlyURL as myval
from tb_users_plants p
where p.isactive and p.displayOnWebsite = 1 and isnull(p.deleteDate) and userID = 3829
and p.type = 'Aquatic'
group by p.friendlyURL
order by p.NameLine2, p.nameLine1
myval
1Nymphaea-Blue-Triumph-Waterlily
Waterlily - Nymphaea 'Blue Triumph' from Landscaper Theme Three

Nymphaea 'Blue Triumph'

Waterlily

  • Fragrant showy flower
  • Glossy deep green foliage
  • Misty blue inflorescence

10in - $28.99
Waterlily Details
Height 6 - 12 in
Spread 24 - 48 in
Zone 4-10
Categories Aquatic

Check back soon for additional information on Waterlily.

Check back soon for more in-depth details on Waterlily.