query
RESULTSET
query
  ACTIVE BODY CONTENTID CREDITS DISPLAYSTART DISPLAYSTOP FILEID FILENAME ORDERNO PARENTID PATH RELEASEDATE SUMMARY TAGS TITLE URLTITLE
1 1 <p><a href="http://www.mammothoutdoorsports.com/info/mammoth-village-championships"><img alt="Mammoth Village Championships 2014 " src="/cms/Mammoth/assets/Image/homepage/mos-mvc2014-slider1%20copy.jpg" style="width: 745px; height: 365px;" /></a></p> 7C983283-9825-DEB6-C0A97FC51061F885 [empty string] [empty string] [empty string] [empty string] homepage/main-banners/mammoth-village-championships-slider 1 99C1B414-91C8-E8F2-C00A7E4D2E24A481 00000000000000000000000000000000001,99BDCE22-A409-67A0-408DBC97EC66B82C,99C1B414-91C8-E8F2-C00A7E4D2E24A481,7C983283-9825-DEB6-C0A97FC51061F885 [empty string] [empty string] [empty string] Mammoth Village Championships Slider mammoth-village-championships-slider
2 1 <p><a href="http://www.mammothoutdoorsports.com/clearance"><img alt="70% OFF Winter Gear For Limited Time Only" src="/cms/Mammoth/assets/Image/homepage/mos-70offwinter-slider1.jpg" style="width: 745px; height: 365px;" /></a></p> 7A609D1E-C51A-7731-FA1D90E849359D06 [empty string] [empty string] [empty string] [empty string] homepage/main-banners/20off-bike-tubes-tune-ups1 2 99C1B414-91C8-E8F2-C00A7E4D2E24A481 00000000000000000000000000000000001,99BDCE22-A409-67A0-408DBC97EC66B82C,99C1B414-91C8-E8F2-C00A7E4D2E24A481,7A609D1E-C51A-7731-FA1D90E849359D06 [empty string] [empty string] [empty string] Summer Bike Special Slider 20off-bike-tubes-tune-ups1
3 1 <p><a href="http://www.mammothoutdoorsports.com/footwear-allfootwear"><img alt="New Arrivals of Summer Shoes" src="/cms/Mammoth/assets/Image/homepage/mos-summershoes-slider3.jpg" style="width: 745px; height: 365px;" /></a></p> 3726A15E-972D-6723-472C00B6225C3993 [empty string] [empty string] [empty string] [empty string] homepage/main-banners/new-arrivals-of-summer-shoes 3 99C1B414-91C8-E8F2-C00A7E4D2E24A481 00000000000000000000000000000000001,99BDCE22-A409-67A0-408DBC97EC66B82C,99C1B414-91C8-E8F2-C00A7E4D2E24A481,3726A15E-972D-6723-472C00B6225C3993 [empty string] [empty string] [empty string] New Arrivals of Summer Shoes new-arrivals-of-summer-shoes
4 1 <p><a href="http://www.mammothoutdoorsports.com/bikes/browse/brand/trek-bicycle"><img alt="New Arrivals of Trek Bikes" src="/cms/Mammoth/assets/Image/homepage/mos-trekbikes-slider1.jpg" style="width: 745px; height: 365px;" /></a></p> 36C9D746-D5A3-7FB5-D611BC6B9D283622 [empty string] [empty string] [empty string] [empty string] homepage/main-banners/womans-summer-casual-clothing 4 99C1B414-91C8-E8F2-C00A7E4D2E24A481 00000000000000000000000000000000001,99BDCE22-A409-67A0-408DBC97EC66B82C,99C1B414-91C8-E8F2-C00A7E4D2E24A481,36C9D746-D5A3-7FB5-D611BC6B9D283622 [empty string] [empty string] [empty string] Womans Summer Casual Clothing womans-summer-casual-clothing
5 1 <p><a href="http://www.mammothoutdoorsports.com/info/bike-sales-rentals"><img alt="20% Off Mammoth Bike Rentals" src="/cms/Mammoth/assets/Image/homepage/mos-bikerentals-slider3.jpg" style="width: 745px; height: 365px;" /></a></p> BA77D187-9377-657C-26BEDEBA351B467D [empty string] [empty string] [empty string] [empty string] homepage/main-banners/bike-sales-and-rentals-banner 5 99C1B414-91C8-E8F2-C00A7E4D2E24A481 00000000000000000000000000000000001,99BDCE22-A409-67A0-408DBC97EC66B82C,99C1B414-91C8-E8F2-C00A7E4D2E24A481,BA77D187-9377-657C-26BEDEBA351B467D [empty string] [empty string] [empty string] Bike Sales and Rentals Banner bike-sales-and-rentals-banner
CACHED false
EXECUTIONTIME 2
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
Mammoth Village Championships 2014 70% OFF Winter Gear For Limited Time Only New Arrivals of Summer Shoes New Arrivals of Trek Bikes 20% Off Mammoth Bike Rentals

Ride our FREE Downtown Mammoth Bike Park

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.