Nursing Home Administrator Package (47+ hours) Approvals: NAB
SKU: OLCP5000
Single User Price: $170.00
Group Discount Price:
query
RESULTSET
query
PRICELLEVELDISCOUNT
PROMOID
PROMOTIONDESCRIPTION
PROMOTIONTITLE
PROMOTYPE
1
0
45
<div><span style="FONT-WEIGHT: bold">Group Discounts:</span></div><div> </div><div>The more people you train, the more you save!</div><div> </div><div><table style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; BORDER-COLLAPSE: collapse; BORDER-TOP: medium none; BORDER-RIGHT: medium none" border="2"><tbody><tr><td style="BACKGROUND: rgb(220,220,220)"><span style="FONT-WEIGHT: bold">Number of Learners </span></td><td style="BACKGROUND: rgb(220,220,220)"><span style="FONT-WEIGHT: bold">Price Per Person </span></td><td style="BACKGROUND: rgb(220,220,220)"><span style="FONT-WEIGHT: bold">Percent Discount </span></td></tr><tr><td>2 - 5</td><td>$180.00</td><td>10%</td></tr><tr><td>6 - 10</td><td>$150.00</td><td>25%</td></tr><tr><td>11 or more</td><td>Call for pricing:</td><td>(540) 349-8074 ext 1</td></tr></tbody></table></div><div> </div>
Group Discount
all
CACHED
false
EXECUTIONTIME
5
SQL
SELECT promotions.promoTitle AS promotionTitle, promotions.promoDescription AS promotionDescription,
promotions.priceLevelDiscount AS pricelLevelDiscount, promotions.promoType AS promoType,
promotions.promoID AS promoId
FROM sd_promoProducts promoProducts INNER JOIN sd_promotions promotions ON promoProducts.promoID = promotions.promoID
WHERE (promotions.status<>0) AND
(promoProducts.selectProductID=?) AND
(promotions.startDate <{d '2025-01-22'} AND promotions.endDate > {d '2025-01-22'}) AND
((promotions.promoCode = ' ') OR ( promotions.promoCode IS NULL)) AND
(promotions.promoTitle <> '') AND (promotions.selectedItem <> 0)
AND promotions.promoID IN (45,45)
AND (promotions.adminDemoMode <> 1)
UNION ALL
SELECT promotions.promoTitle AS promotionTitle, promotions.promoDescription AS promotionDescription,
promotions.priceLevelDiscount AS pricelLevelDiscount, promotions.promoType AS promoType,
promotions.promoID AS promoId
FROM sd_promoProducts promoProducts INNER JOIN sd_promotions promotions ON promoProducts.promoID = promotions.promoID
WHERE (promotions.status<>0) AND
(promoProducts.discountProductID=?) AND
(promotions.startDate <{d '2025-01-22'} AND promotions.endDate > {d '2025-01-22'}) AND
((promotions.promoCode = ' ') OR ( promotions.promoCode IS NULL)) AND
(promotions.promoTitle <> '') AND (promotions.discountedItem <> 0)
AND promotions.promoID IN (45,45)
AND (promotions.adminDemoMode <> 1)
SQLPARAMETERS
Click Here
(2 or more learners)
To purchase, enter number of learners and click "Add to Cart"