Planet Urine Clearance Sale Items

We're making space for new products. All products below are discounted up to 50%! Get in on the action because the offers are only good until supplies last.

SELECT ProductUnits.*, ProductPages.*, ClearanceItems.SalePrice FROM ClearanceItems INNER JOIN (ProductUnits INNER JOIN ProductPages ON ProductUnits.ProductPageID = ProductPages.ProductPageID) ON ClearanceItems.ProductUnitID = ProductUnits.ProductUnitID WHERE ProductPages.LiveYN <> 0
 

NEW!!#productsList.ProductName#
#CoolText#
#Description#
#HotText#
More Information
SELECT ProductUnits.* FROM ProductUnits WHERE (((ProductUnits.ProductPageID)=#productsList.ProductPageID#) AND ((ProductUnits.LiveYN)<>0)) ORDER BY ProductUnits.UnitPrice;
 

#productUnits.UnitName#
#productUnits.UnitNote#
Our Price: #DollarFormat(productUnits.UnitPrice)#
Clearance Price: #DollarFormat(productsList.SalePrice)#
#productsList.AttnText#
 
» Back to Top