>SELECT ListOrder.ListID, List.Listname, Count.Updated > FROM ListOrder > LEFT OUTER JOIN Count ON > ListOrder.ListID=Count.ListID AND ListOrder.SelectID=Count.SelectID > JOIN List ON > ListOrder.ListID=List.ListID > WHERE List.ManagerID = 1875 > AND Count.Updated >= GetDate()-180 > GROUP BY ListOrder.ListID, List.Listname, Count.Updated >