Norm MacDonald

TABLE WITHOUT ID
file.link AS Name, by AS By, in AS In, of AS Of, date AS Date, year AS Year
FROM #Type
WHERE
(
  (
    contains(by, this.file.name)
    OR
    contains(by, this.file.link)
    OR
    any(contains(by, this.by))
    AND
    by
  )
  AND
  file.name !=this.file.name  
)
SORT file.etags DESC, date DESC, year DESC