Ulmus americana 'Princeton' Princeton American Elm from Prides Corner Farms

Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 31.7 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 = 10191 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		ULMUS AMERICANA `PRINCETON`		1007808		0	16	2	0	0	255	Wholesale Yard B&B		1		-	2/2.5 B+B	0	255					10191	20589
2		ULMUS AMERICANA `PRINCETON`		1002908		0	45	0	0	0	315	Wholesale Yard B&B		1		-	2.5/3 B+B	0	315					10191	21103
3		ULMUS AMERICANA `PRINCETON`		1002719		0	13	1	0	0	385	Wholesale Yard B&B		1		-	3/3.5 B+B	0	385					10191	20625