2025-02-05 15:29:44 +01:00
|
|
|
|
SELECT SUM(a1.Betrag)
|
|
|
|
|
|
FROM gkvtransferprotokoll AS t1
|
|
|
|
|
|
JOIN gkvabrechnung a1
|
|
|
|
|
|
ON a1.Oid = t1.GkvAbrechnungOid
|
2025-09-23 12:32:24 +02:00
|
|
|
|
WHERE DATE(a1.ErstelltAm) >= ?
|
|
|
|
|
|
AND DATE(a1.ErstelltAm) <= ?
|
2025-02-05 15:29:44 +01:00
|
|
|
|
AND t1.Oid = (
|
|
|
|
|
|
SELECT MIN(Oid)
|
|
|
|
|
|
FROM gkvtransferprotokoll AS t2
|
|
|
|
|
|
WHERE t1.GkvAbrechnungOid = t2.GkvAbrechnungOid
|
|
|
|
|
|
GROUP BY t2.GkvAbrechnungOid
|
2025-04-03 12:31:21 +02:00
|
|
|
|
)
|
|
|
|
|
|
AND
|
|
|
|
|
|
(
|
|
|
|
|
|
(a1.Verfahrensstufe = 1 AND t1.EmpfangerBezeichnung NOT LIKE 'knappschaft')
|
|
|
|
|
|
OR
|
|
|
|
|
|
a1.Verfahrensstufe = 2
|
2025-02-05 15:29:44 +01:00
|
|
|
|
)
|
