SELECT Products_tbl.*,MenusItems_tbl.ItemName,(SELECT TOP 1 Taste FROM Tastes_tbl WHERE ProductID = Products_tbl.ProductID AND Taste >= CONVERT(VARCHAR(10), GETDATE(), 120)) AS X FROM Products_tbl LEFT JOIN ProductsPlaceOrder_tbl ON Products_tbl.ProductID = ProductsPlaceOrder_tbl.ProductID AND ProductsPlaceOrder_tbl.AreaID = 2057 LEFT OUTER JOIN MenusItems_tbl ON Products_tbl.EventSubType = MenusItems_tbl.MenuItemID WHERE (EventSubType = 2057 OR ', ' + AddCategories + ',' LIKE '%, 2057,%') AND Products_tbl.Active = 'True' AND (EXISTS (SELECT TOP 1 Taste FROM Tastes_tbl WHERE ProductID = Products_tbl.ProductID AND Taste >= CONVERT(VARCHAR(10), GETDATE(), 120)) OR NOT EXISTS (SELECT Taste FROM Tastes_tbl WHERE ProductID = Products_tbl.ProductID)) ORDER BY Products_tbl.EventSubType,X,ProductsPlaceOrder_tbl.ItemPlace