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/bike-sales-rentals"><img alt="" src="/cms/Mammoth/assets/Image/mos-bikerentals-slider2.png" 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 1 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
2 1 <p><a href="http://www.mammothoutdoorsports.com/info/mega-sale"><img alt="" src="/cms/Mammoth/assets/Image/MegaSalehomepagebanner1.jpg" style="width: 745px; height: 365px;" /></a></p> E145382A-9FE3-83FE-FD9AD590294CEB8F [empty string] [empty string] [empty string] [empty string] homepage/main-banners/mega-sale-banner 2 99C1B414-91C8-E8F2-C00A7E4D2E24A481 00000000000000000000000000000000001,99BDCE22-A409-67A0-408DBC97EC66B82C,99C1B414-91C8-E8F2-C00A7E4D2E24A481,E145382A-9FE3-83FE-FD9AD590294CEB8F [empty string] [empty string] [empty string] MEGA SALE Banner mega-sale-banner
3 1 <p><a href="/snowboard-snowboards"><img alt="Discount Libtech Snowboards" src="/cms/Mammoth/assets/Image/mos-snowboards-slider1.jpg" style="width: 745px; height: 365px;" /></a></p> BD66A963-AAD9-A687-E7C16CB64F9B7C7E http://www.mammothoutdoorsports.com/snowboard-snowboards [empty string] [empty string] [empty string] homepage/main-banners/discount-libtech-snowboards 5 99C1B414-91C8-E8F2-C00A7E4D2E24A481 00000000000000000000000000000000001,99BDCE22-A409-67A0-408DBC97EC66B82C,99C1B414-91C8-E8F2-C00A7E4D2E24A481,BD66A963-AAD9-A687-E7C16CB64F9B7C7E [empty string] [empty string] http://www.mammothoutdoorsports.com/snowboard-snowboards Discount Libtech Snowboards discount-libtech-snowboards
4 1 <p><a href="http://www.mammothoutdoorsports.com/all-products/browse/keyword/moment/brand/moment"><img alt="Discount on Dye Goggles" src="/cms/Mammoth/assets/Image/apr2014_Moment50off(1).jpg" style="width: 745px; height: 365px;" /></a></p> 21BADDAF-BB12-52AE-6F416C30DDEF8DA7 http://www.mammothoutdoorsports.com/clearance [empty string] [empty string] [empty string] homepage/main-banners/mammoth-ski-clearance 6 99C1B414-91C8-E8F2-C00A7E4D2E24A481 00000000000000000000000000000000001,99BDCE22-A409-67A0-408DBC97EC66B82C,99C1B414-91C8-E8F2-C00A7E4D2E24A481,21BADDAF-BB12-52AE-6F416C30DDEF8DA7 [empty string] [empty string] http://www.mammothoutdoorsports.com/clearance Shop Clearance mammoth-ski-clearance
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
Discount Libtech Snowboards Discount on Dye Goggles

Hertzog 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.