Query
Template: /consoleAssets/farmTheme/plants/dsp_plantDetail.cfm:37
Execution Time: 8.78 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 Two

Nymphaea 'Blue Triumph'

Waterlily
10in - $28.99
  • Summary
  • Additional Details

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

Height
6 - 12 in
Spread
24 - 48 in
Zone
4-10
Categories
Aquatic
Tags
Staff FavoriteFull SunWater Garden

  • 128 Raleigh St, Holly Springs, NC 27540