Screenwriter

TABLE WITHOUT ID
file.link AS Name, in AS In, of AS Of, for AS For, re AS Re, as AS As, contact AS Contact, url AS URL, date AS Date
FROM #Type
WHERE
(
  (
    any(contains(for, this.for))
    OR
    any(contains(of, this.for))
    OR
    any(contains(by, this.for))
    OR
    any(contains(in, this.for))
    OR
    any(contains(re, this.for))
    OR
    any(contains(as, this.for))
    AND
    this.for
  )
  OR
  (
    any(contains(of, this.of))
    OR
    any(contains(for, this.of))
    OR
    any(contains(by, this.of))
    OR
    any(contains(in, this.of))
    OR
    any(contains(re, this.of))
    OR
    any(contains(as, this.of))
    AND
    this.of
  )
  OR
  (
    any(contains(of, this.in))
    OR
    any(contains(for, this.in))
    OR
    any(contains(by, this.in))
    OR
    any(contains(in, this.in))
    OR
    any(contains(re, this.in))
    OR
    any(contains(as, this.in))
    AND
    this.in
  )
  OR
  (
    any(contains(of, this.as))
    OR
    any(contains(for, this.as))
    OR
    any(contains(by, this.as))
    OR
    any(contains(in, this.as))
    OR
    any(contains(re, this.as))
    OR
    any(contains(as, this.as))
    AND
    this.as
  )
  OR
  (
    any(contains(for, this.file.name))
    OR
    any(contains(for, this.file.link))
    OR
    any(contains(of, this.file.name))
    OR
    any(contains(of, this.file.link))
    OR
    any(contains(in, this.file.name))
    OR
    any(contains(in, this.file.link))
    OR
    any(contains(by, this.file.name))
    OR
    any(contains(by, this.file.link))
    OR
    any(contains(re, this.file.name))
    OR
    any(contains(re, this.file.link))
    OR
    any(contains(as, this.file.name))
    OR
    any(contains(as, this.file.link))
  )
  AND file.name !=this.file.name  
)
SORT file.etags DESC, date DESC, file.link ASC