SELECT "ex"."ex", "ex"."lv", "ex"."tt", "ex"."td", "dn2"."ex" AS "trex", sum("ap"."uq") AS "trq" FROM "ex"
INNER JOIN "lv" ON ("lv"."lv" = "ex"."lv")
INNER JOIN "dn" ON ("dn"."ex" = "ex"."ex")
INNER JOIN "dn" AS "dn2" ON ("dn2"."mn" = "dn"."mn")
INNER JOIN "mn" ON ("mn"."mn" = "dn2"."mn")
INNER JOIN "ap" ON ("ap"."ap" = "mn"."ap")
WHERE
  lcvc("lv"."lc", "lv"."vc") IN ('ita-000') AND
  "dn"."ex" != "dn2"."ex" AND
  "dn2"."ex" IN (645630)
GROUP BY "ex"."ex", "ex"."lv", "ex"."tt", "ex"."td", "dn2"."ex"
ORDER BY "ex"."ex"
LIMIT 2000;