SELECT * FROM Adverts INNER JOIN AdvertCategories on Adverts.AdvertCategoryID=AdvertCategories.AdvertCategoryID INNER JOIN AdvertCompanies on Adverts.AdvertCompanyID=AdvertCompanies.AdvertCompanyID WHERE Adverts.SiteID=2 AND Deleted=0 AND StartDate <= '2008-07-04' AND EndDate >= '2008-07-04' AND Deleted=0 AND Adverts.SiteID=2 ORDER BY RAND() Limit 0,6 Keith Martin's Corvette Market Magazine
  SCM Quick Links
Popular Topics
Collector Car Profiles
Affordable Classics
The Marketplace
Auction & Event Calendar
Million Dollar Sales
Cars for Sale
Research Center
SCM University
KM Buyer's Guides
KM On Collecting series
Market Analysis
The SCM Community
SCM Services and Subscriptions
Advertise with SCM
Contests and Games
Crossword Puzzle
Vodcasts & Slideshows