SELECT Top 3 PostedDate, ItemDirectory.ItemID, Item, AVGrating, Description, Image FROM ItemDirectory, ItemReviews WHERE ItemDirectory.ItemID=ItemReviews.ItemID GROUP BY PostedDate, AVGrating, ItemDirectory.ItemID, Item, Description, Image ORDER by PostedDate DESC SELECT Top 3 PostedDate, ShopDirectory.ShopID, ShopName, AVGrating, Description, Image FROM ShopDirectory, ShopReviews WHERE ShopDirectory.ShopID=ShopReviews.ShopID GROUP BY PostedDate, AVGrating, ShopDirectory.ShopID, ShopName, Description, Image ORDER by PostedDate DESC SELECT Top 3 PostedDate, AVG(AVGrating) AS RaceAVGrating, RaceReviews.RaceID, RaceName, City, StateName, Mileage, SkillLevel, RaceDirectory.RaceID FROM RaceDirectory, RaceReviews WHERE RaceDirectory.RaceID= RaceReviews.RaceID GROUP BY PostedDate, RaceReviews.RaceID, RaceName, RaceDirectory.RaceID, Mileage, SkillLevel, City, StateName, AVGrating ORDER by PostedDate DESC SELECT Top 3 PostedDate, AVG(AVGrating) AS TrailAVGrating, TrailReviews.TrailID, TrailName, City, StateName, Mileage, SkillLevel, TrailDirectory.TrailID FROM TrailDirectory, TrailReviews WHERE TrailDirectory.TrailID=TrailReviews.TrailID GROUP BY PostedDate, TrailReviews.TrailID, TrailName, TrailDirectory.TrailID, StateName, TrailName, City, Mileage, SkillLevel, AVGrating ORDER by PostedDate DESC SELECT Top 3 NumberOfTrailReviews, NumberOfRaceReviews, StateName, Region, StateID FROM StateDirectory GROUP BY Statename, NumberOfTrailReviews, NumberOfRaceReviews, Region, StateID order by NumberOfTrailReviews, NumberOfRaceReviews desc SELECT sum(NumberOfTrailReviews) as rallcountTRAIL , sum(NumberOfRaceReviews) as rallcountRACE FROM StateDirectory order by count(NumberOfTrailReviews) desc, count(NumberOfRaceReviews) desc SELECT Image, Description, EntryDate, ImageID, Name, ImageType FROM ImageGallery ORDER BY ImageID SELECT Top 3 NewsDate, Name, NewsDate, Description, NewsID FROM NewsDirectory ORDER BY NewsDate DESC SELECT Distinct Region FROM StateDirectory ORDER BY Region SELECT ImageTypeID, ImageType FROM ImageTypes MTBMIND -- Riding through all elements!
.. Today is #DateFormat(Now(),"dddd, mmmm dd, yyyy")#
       

 

  
 

Car Roof Racks & Bike Racks

ORS Racks Direct specializes in discount Yakima Racks, Thule
Racks & Rocky Mounts.
Team Sponsors



The Brake People!Visit Cambria Bicycle Outfitter!

Functional eyewear for cyclists.

Panaracer Tires


Superior lubes and tools!

Innovator of quality bars and posts.



       

Site updates!!
We are in the process of updating the site once again to make it a little more user friendly and interactive with our discussion forums. If there are any problems, please contact us at your leisure.

Now get out and ride your bike!


Community Forum
Populate our online community and start a discussion, or join in on conversations from riders across the country! Registration is free for all riders.

Login | Register | View New Posts

Jesse Anthony Leanne Schoenfeld
Chris Gagnon Josh Schoenfeld
Collin Galloway Dan Gagliarde

Photo Gallery
Check out sweet pics with our new and improved viewing gallery. Rate pics, leave comments, and remember the day!

Fitness & nutrition
You can't ride strong unless you ARE strong! We have all the info you need to develop your riding through the means of various training techniques.

Maintenance Tips
General tips and helpful information on how to keep your ride running smoothly, and without complications!
Mountain Biking Basics
For the newbie to mountain biking and racing. Information on the language and passion of mtb'ing.

Check out the official dictionary for mountain biking (slang).


Writing Lounge
Share stories, poems, essays and publications written to address the sport and issues of mountain biking.
  

Event Search
Complete regional race and event listings that bring you into the heart of competition and gatherings.

  • Click here for the NORBA, EFTA, Root 66, 24 Hour, and Championship race schedules.
  • Click here for the 2005 month-by-month calendar view.

Above Photo: Flying at warp speed.
'04 24 hours of Adrenaline
Last Rated Events:
State
Mileage
Rating:
#RaceName#
#StateName#
#Mileage#
Regional Trail Listings
Looking for the epic ride of the year? Look no further than our listing of rated trails around the country.
Last Rated Trails:
State
Mileage
Rating:
#TrailName#
#StateName#
#Mileage#

Bikes, Parts, and More!
- Add an Item -
Read reviews on bikes, parts, and clothing by riders who have ridden and tested them!
Last Rated Items:
Rating:
#Item#
Shop Directory
- Add a Shop -
Search for a shop with the best gear, knowledge, and services for your buck!
Last Rated Shops:
Rating:
#ShopName#
 
     
   

             

 
   


Copyright © 2004 MTBMIND.com. All Rights Reserved
Site Designed by Chris Gagnon