S: SELECT EntityID,EntityName,EntityDisplayURL,EntityURL,GoodDatePosted,GoodHeading,GoodFullDesc,GoodImageSL,GoodStockID,GoodImage1Path,GoodDisplayURL,GoodURL,StockImagePath FROM Goods,Entitys,Stocks WHERE GoodEntityID = EntityID AND GoodStockID = StockID AND GoodID = 31 AND GoodActive = 'Y' , New Mexico -- vehicles | autos | trucks | cars | boats | motorcycles | auto repair | mechanics | body repair | auto parts | rvs
