query
RESULTSET
query
  ACTIVE BODY CONTENTID CREDITS DISPLAYSTART DISPLAYSTOP FILEID FILENAME ORDERNO PARENTID PATH RELEASEDATE SUMMARY TAGS TITLE URLTITLE
1 1 <p><br /> <a href="http://mammothoutdoorsports.com/thermals"><img alt="40% OFF All Thermals" src="/cms/Mammoth/assets/Image/homepage/mos-40offthermals-slider2.jpg" style="width: 745px; height: 365px;" /></a></p> FB570F99-CF0F-9DCC-45764A1366286AD9 [empty string] [empty string] [empty string] [empty string] homepage/main-banners/40-off-thermals 1 99C1B414-91C8-E8F2-C00A7E4D2E24A481 00000000000000000000000000000000001,99BDCE22-A409-67A0-408DBC97EC66B82C,99C1B414-91C8-E8F2-C00A7E4D2E24A481,FB570F99-CF0F-9DCC-45764A1366286AD9 [empty string] [empty string] [empty string] 40% OFF Thermals 40-off-thermals
2 1 <p><br /> <a href="http://www.mammothoutdoorsports.com/info/bike-sales-rentals"><img alt="20% OFF All Bikes" src="/cms/Mammoth/assets/Image/homepage/mos-20offnewbikes-slider4.jpg" style="width: 745px; height: 365px;" /></a></p> FB4E393E-B3EB-D90B-B366337C24EECD93 [empty string] [empty string] [empty string] [empty string] homepage/main-banners/20-off-all-bikes 2 99C1B414-91C8-E8F2-C00A7E4D2E24A481 00000000000000000000000000000000001,99BDCE22-A409-67A0-408DBC97EC66B82C,99C1B414-91C8-E8F2-C00A7E4D2E24A481,FB4E393E-B3EB-D90B-B366337C24EECD93 [empty string] [empty string] [empty string] 20% OFF All Bikes 20-off-all-bikes
3 1 <p><a href="http://www.mammothoutdoorsports.com/info/bike-sales-rentals"><img alt="20% OFF Bike Rentals" src="/cms/Mammoth/assets/Image/homepage/mos-bikerentals-slider4.jpg" style="width: 745px; height: 365px;" /></a></p> FB3F4643-F3C3-D76E-707790D0CBC16D9B [empty string] [empty string] [empty string] [empty string] homepage/main-banners/20-off-bike-rentals 3 99C1B414-91C8-E8F2-C00A7E4D2E24A481 00000000000000000000000000000000001,99BDCE22-A409-67A0-408DBC97EC66B82C,99C1B414-91C8-E8F2-C00A7E4D2E24A481,FB3F4643-F3C3-D76E-707790D0CBC16D9B [empty string] [empty string] [empty string] 20% OFF Bike Rentals 20-off-bike-rentals
4 1 <p><br /> <a href="http://www.mammothoutdoorsports.com/clearance"><img alt="Up to 50% OFF Winter Gear" src="/cms/Mammoth/assets/Image/homepage/mos-50offwintergear-slider2(1).jpg" style="width: 745px; height: 365px;" /></a></p> 684DEC17-E2D5-6307-7237A0902D64F855 [empty string] [empty string] [empty string] [empty string] homepage/main-banners/50-off-winter-gear 5 99C1B414-91C8-E8F2-C00A7E4D2E24A481 00000000000000000000000000000000001,99BDCE22-A409-67A0-408DBC97EC66B82C,99C1B414-91C8-E8F2-C00A7E4D2E24A481,684DEC17-E2D5-6307-7237A0902D64F855 [empty string] [empty string] [empty string] 50% OFF Winter Gear 50-off-winter-gear
CACHED false
EXECUTIONTIME 1
SQL SELECT contentID, active, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Body, orderno, credits FROM tcontent WHERE siteid = 'Mammoth' and (parentID = '99C1B414-91C8-E8F2-C00A7E4D2E24A481') AND (active = 1) ORDER BY orderno asc

40% OFF All Thermals
20% OFF All Bikes 20% OFF Bike Rentals
Up to 50% OFF Winter Gear

2014 Snow Show Schedule

Mammoth Rental Bikes For Sale

Free Giveaways

Family owned and operated since 1977.

Located in the heart of the Eastern Sierra Mountains, Mammoth Outdoor Sports provides all the equipment & accessories you'll need to enjoy everything Mammoth Mountain has to offer. We stock top name brands in Bikes, Skis, Snowboards, Boots, Bindings, Outerwear, Footwear & Accessories at the best prices. We also offer incredible bike rentals during the summer and ski/snowboard rentals during the winter. Call us with any questions on equipment or where to experience the best of Mammoth at 760-934-3239.