LOC: Difference from Baseline Transmission Database Query

Back to Database Queries
         
        SELECT
          "institution"."name",                                 -- anonymized name of institution
          "machine"."id",                                       -- anonymized name of machine
          "machineType"."model",                           -- type of machine
          "multileafCollimator"."model",                   -- HD or Millenium
          "output"."dataDate",                             -- time and date that data was collected
       -- "output"."analysisDate",                         -- time and date that data was analyzed
          "diffBaselineTrans"."section",                    -- section
          "diffBaselineTrans"."leafIndex",                  -- leaf number
          "diffBaselineTrans"."diffBaselineTrans_mm"                  -- difference from baseline transmission in mm
        FROM
          public."diffBaselineTrans",
          public."institution",
          public."machine",
          public."machineType",
          public."multileafCollimator",
          public."output"
        WHERE
              ("diffBaselineTrans"."outputPK" = "output"."outputPK")
          AND ("output"."machinePK" = "machine"."machinePK")
          AND ("machine"."institutionPK" = "institution"."institutionPK")
          AND ("machine"."machineTypePK" = "machineType"."machineTypePK")
          AND ("machine"."multileafCollimatorPK" = "multileafCollimator"."multileafCollimatorPK")
        ORDER BY
          "institution"."name",
          "machine"."id",
          "output"."dataDate",
		  "diffBaselineTrans"."section",
          "diffBaselineTrans"."leafIndex"
        ASC LIMIT 10;