InterestingSlides.sql

USE Aperio
SELECT *
  FROM [dbo].[Image] 
  JOIN [dbo].[Slide] ON Slide.Id=Image.ParentId
  LEFT JOIN [dbo].[Specimen] ON Slide.ParentId=Specimen.Id
  LEFT JOIN [dbo].[Case] AS CaseStudy ON Specimen.ParentId=CaseStudy.Id
  LEFT JOIN [Core].[Stain] ON Slide.StainId=Stain.Id
  LEFT JOIN [dbo].[BodySite] ON Slide.BodySiteId=BodySite.Id
  WHERE Specimen.DataGroupId = 62
  AND Image.CompressedFileLocation != ''
  AND Specimen.ParentTable = 'Case'
  ORDER BY CaseStudy.PhysicianName ASC, CaseStudy.Id ASC, Specimen.Id ASC, Slide.Id ASC