Tilia cordata Greenspire® Greenspire® Linden from Prides Corner Farms

Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 43.9 ms Record Count: 3 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 = 3138 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		TILIA CORDATA `GREENSPIRE`		1001208		0	33	0	0	0	295	Wholesale Yard B&B		1		-	2/2.5 B+B	0	295					3138	20500
2		TILIA CORDATA `GREENSPIRE`		1001205		0	12	7	0	0	360	Wholesale Yard B&B		1		-	2.5/3 B+B	0	360					3138	20461
3		TILIA CORDATA `GREENSPIRE`		1001206		0	18	0	0	0	465	Wholesale Yard B&B		1		-	3/3.5 B+B	0	465					3138	20710