Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/TousseTournoverDaysStatisticsReportHelper.java
===================================================================
diff -u -r36323 -r36366
--- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/TousseTournoverDaysStatisticsReportHelper.java	(.../TousseTournoverDaysStatisticsReportHelper.java)	(revision 36323)
+++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/TousseTournoverDaysStatisticsReportHelper.java	(.../TousseTournoverDaysStatisticsReportHelper.java)	(revision 36366)
@@ -178,17 +178,15 @@
 		sbf.append(Invoice.class.getSimpleName());
 		sbf.append(" i on i.id=ti.invoice_id left join ");
 		sbf.append(SterilizationRecord.class.getSimpleName());
-		sbf.append(" sr on sr.id=ti.sterilizationRecord_id ");
-		sbf.append(" where sr.endDate is not null and ti.invoice2_id is null and ");
+		sbf.append(" sr on sr.id=ti.sterilizationRecord_id where sr.endDate is not null and ti.invoice2_id is null and ");
 		sbf.append(orgUnitCodingsSql);
 		sbf.append(" union all select 1 amount ,DATEDIFF(day, endDate,i.sendTime) subday,i.sendTime,ti.packageType from ");
 		sbf.append(TousseInstance.class.getSimpleName());
 		sbf.append(" ti join ");
 		sbf.append(TousseDefinition.class.getSimpleName());
 		sbf.append(" td on td.id=ti.tousseDefinition_id join ");
 		sbf.append(Invoice.class.getSimpleName());
-		sbf.append(" i on i.id=ti.invoice2_id ");
-		sbf.append(" left join  ");
+		sbf.append(" i on i.id=ti.invoice2_id left join  ");
 		sbf.append(SterilizationRecord.class.getSimpleName());
 		sbf.append(" sr on sr.id=ti.sterilizationRecord_id where sr.endDate is not null and ");
 		sbf.append(orgUnitCodingsSql);