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=477 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 |