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