SELECT s.businessID, s.smallLogo, s.parentbusinessID, s.name, s.listingCity, s.listingState, s.featuredURL, s.featured, s.listingDesc, st.name AS stateName, s.zip AS zip FROM business s join state st on st.stateID = s.listingState, xbusinesscategorytype x, categorytype ct WHERE (s.featured = 'A' OR s.featured = 'B') AND s.listingState <> '' AND ((st.stateID = 'AB' AND s.listingState = st.stateID) OR (s.businessID IN (SELECT businessID from businessListingStates where stateID='AB' and businessID=s.businessID))) AND s.businessID = x.businessID AND x.categoryTypeID=ct.categoryTypeID AND ct.searchwithall = 'Y' GROUP BY s.businessID ORDER BY st.name, s.featured, s.listingCity, s.name