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