SELECT SubCategories.ID AS ID, SubCategories.Name AS Name, SubCategories.C00 AS C00 FROM TenBest.PointsOfInterestSubCategories AS SubCategories, PointsOfInterestSupplementalBusinesses AS Business, PointsOfInterestSupplementalBusinessesMetros AS BusinessMetros, PointsOfInterestSupplementalBusinessesSubCategories AS BusinessSubCategories WHERE Business.ID=BusinessMetros.BusinessID AND Business.ID=BusinessSubCategories.BusinessID AND BusinessSubCategories.CategoryID=SubCategories.C00 AND BusinessMetros.MetroID=445 AND SubCategories.Name NOT IN ('Hotels And Lodging') GROUP BY SubCategories.ID ORDER BY SubCategories.Name
|
|
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
©2009 10Best. All rights reserved. Radisson Hotels & Resorts Privacy Policy 10Best Privacy Policy & Legal Notice |