| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 94 ms Record Count: 1 Cached: No Lazy: No SQL: select h.program, s.name, s.udefSKUNameSuffix, s.sku, s.udefBannedStates, s.udefBBL, s.udefRR, s.udefLR, s.udefTimsTopTwenty, s.udefJaimesHotList, s.listPrice as price, s.udefCategory as category, s.udefComments as comments, s.udefGrade as grade, s.udefSpecial as special, s.udefPlantSize as plantSize, s.qtyUnit as size, s.salePrice, s.listPrice, s.udefTier2, s.udefTier2Price, s.udefTier3, s.udefTier3Price, s.plantID, s.id from tb_plant_skus s inner join tb_lists_hotlist h on (h.sku = s.sku) where s.isactive = 1 and s.delete_date is null and s.isecommerce = 1 and s.plantID = 10679 order by udefcategory, name, price | ||||||||||||||||||||||||||
| program | name | udefSKUNameSuffix | sku | udefBannedStates | udefBBL | udefRR | udefLR | udefTimsTopTwenty | udefJaimesHotList | price | category | comments | grade | special | plantSize | size | salePrice | listPrice | udefTier2 | udefTier2Price | udefTier3 | udefTier3Price | plantID | id | ||
| 1 | PW | DIERVILLA RIVULARIS `KODIAK RED 2.0` | 1020942 | 0 | 187 | 0 | 0 | 1 | 22.19 | SHRUBS: DIERVILLA - bush honeysuckle | 1 | 15-18" | #2 | 0 | 22.19 | (5-9) | 21.08 | (10+) | 19.08 | 10679 | 21946 | |||||
| • | Border or Bed |
| • | Container |
| • | Cut Flower/Foliage |
| • | Focal Point |
| • | Great Foliage |
| • | Specimen |
| • | Yellow |
| • | Proven Winners |
| • | Ground Cover |
Thrives in full shade, to part shade. Diervilla needs very little care - if you'd like to prune it, do so in early spring. It does not require regular pruning, but if it starts to get a little sparse as it matures, cut it back to the ground in early spring for a fresh start.
| string |