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 LEFT OUTER JOIN MenusItems_tbl ON Products_tbl.EventSubType = MenusItems_tbl.MenuItemID WHERE EventSubType = 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