Someone

		insert into #return ( id , name , symbol , lastModified , groupCount )
			select distinct comp.id , comp.name , comp.symbol , (
					select top 1 datestamp from EquityResearch
						where bSector = 0 and bArchive = 1 and id in (
							select equityID from EquitySymbols
								left join EquityResearch on EquityResearch.id = equityID
							where companyID = es.companyID
						) order by EquityResearch.datestamp desc
				) as lastModified , (
					select count(id) from EquityResearch
						where bSector = 0 and bArchive = 1 and id in (
							select equityID from EquitySymbols
								left join EquityResearch on EquityResearch.id = equityID
							where companyID = es.companyID
						)
				) as groupCount
			from EquitySymbols es
				left join EquityResearch r on r.id = es.equityID
				left join companies comp on comp.id = es.companyID
			where r.bSector = 0