SITE UPGRADE Latest Ads Weather 10/26/2009 We have moved WVMountainTrader.com to a new server and are in the process of working out the bugs.  We encourage you to use the site as much as you want, as often as you want.  Also, for are registered users take advantage of our new INVITE A FRIEND application.  The more people we have using the site the easier it is to sell our things.  If you have any questions or see any problems whatsoever please contact us immediately by clicking HERE! Thank you for your support! 1996 Toyota Corolla ( / Autos) Saturday, 04 September 2010 Buckhannon Weather Forecast, WV

SELECT DISTINCT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid, u.username as user FROM #__adsmanager_ads as a LEFT JOIN #__adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN #__users as u ON a.userid = u.id LEFT JOIN #__adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN #__adsmanager_categories as p ON c.parent = p.id WHERE a.id=335 and c.published LIMIT 1