Pepper hybrid Spitfire Spitfire Anaheim Hot Pepper from Prides Corner Farms

Pepper hybrid Spitfire

Spitfire Anaheim Hot Pepper

» Hybrid, hot Anaheim pepper
» 60-85 days to maturity
» Heavy yield of large, long green peppers
» Great disease resistance
» Subtle heat flavor for salsas!
» Superb for fresh eating or preserving
» Very productive and dependable
» Easy to grow

Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 73.1 ms
Record Count: 0
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 = 8734
order by udefcategory, name, price

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price