Post-Campaign Statistics

Korosten-Zhitomir Campaign : Armour Kills by Stationary Objects in the IL2 World
Stationary Victor	Kill Distance (m)	Victim
Allied_88mm_Mortar	2857	PzIIIN
Allied_88mm_Mortar	2227	PzIVJ
Allied_88mm_Mortar	514	PzVA
Axis_88mm_Mortar	274	ISU-152
Axis_88mm_Mortar	1127	KV1
Axis_88mm_Mortar	129	T34
Axis_88mm_Mortar	399	T34
Axis_88mm_Mortar	2308	SU-85
Axis_88mm_Mortar	1926	T34
Axis_88mm_Mortar	329	T34
AxisInfantry	138	ISU-152
AxisInfantry	103	T34
AxisInfantry	123	T34
BA_10	1279	PzIVJ
Flak18_37mm	1961	MarderIII
Flak18_37mm	1552	ISU-152
Flak18_37mm	591	T34
Flak18_37mm	1081	T34
Flak18_37mm	1062	T34
Flak18_88mm	2477	T34
Flak18_88mm	2485	T34
Flak18_88mm	601	T70M
Flak18_88mm	1642	PzIVJ
Flak18_88mm	2370	StuGIIIG
Flak18_88mm	491	T70M
Flak18_88mm	1722	ISU-152
Flak18_88mm	3112	T34
Flak18_88mm	2786	T34
Flak18_88mm	2548	KV1
Flak18_88mm	2999	SU-85
Flak18_88mm	1441	T70M
Flak18_88mm	2266	T34
Flak18_88mm	3220	KV1
Flak18_88mm	677	SU-76M
Flak18_88mm	5026	ISU-152
Flak18_88mm	825	T34
Howitzer_150mm	3144	T70M
Howitzer_150mm	1074	T70M
Howitzer_150mm	605	T34
Howitzer_150mm	354	T34
Howitzer_150mm	1412	T34
ISU-152	332	SU-85
OpelBlitzMaultierRocket	1226	KV1
OpelBlitzMaultierRocket	4019	T70M
OpelBlitzMaultierRocket	2964	T34
OpelBlitzMaultierRocket	2578	T34
OpelBlitzMaultierRocket	2089	T70M
OpelBlitzMaultierRocket	647	T70M
OpelBlitzMaultierRocket	1358	T34
PaK38	1082	T70M
PaK38	1467	T34
PaK40	1403	T34
PaK40	315	T34
PaK40	329	T34
PaK40	387	T34
PaK40	378	T34
PaK40	1098	KV1
PaK40	1359	T34
PaK40	1290	KV1
PaK40	806	T34
PaK40	999	T34
PaK40	521	T34
PaK40	1088	T34
PaK40	946	T34
PaK40	893	SU-85
PaK40	135	SU-76M
PzIIIN	426	T34
PzIIIN	250	T34
PzIIIN	565	T70M
PzIVJ	309	KV1
PzIVJ	270	KV1
PzIVJ	1295	T34
PzIVJ	830	T70M
PzIVJ	1312	T70M
PzIVJ	1525	KV1
PzIVJ	1123	T34
PzIVJ	1067	T34
PzIVJ	499	T34
PzIVJ	558	T34
PzIVJ	1223	T70M
PzIVJ	926	ISU-152
PzIVJ	1549	ISU-152
PzIVJ	743	SU-76M
PzIVJ	623	T34
PzIVJ	228	T34
PzIVJ	936	T34
PzIVJ	1192	SU-76M
PzVA	1879	T70M
PzVA	428	SU-76M
PzVA	933	SU-85
PzVA	1075	T34
PzVA	1360	T34
PzVA	1768	KV1
PzVA	1641	SU-85
PzVA	1769	T34
PzVA	1724	ISU-152
PzVA	1494	ISU-152
PzVA	1459	ISU-152
PzVA	1830	SU-85
PzVA	722	T34
PzVA	638	T34
PzVA	855	KV1
PzVA	845	KV1
PzVA	837	KV1
PzVIE	404	SU-85
RusInfantry	115	PzIB
RusInfantry	62	PzIB
SdKfz6Flak37	1671	PzIVJ
T34	462	PzVA
T34	467	PzVA
T34	618	PzVA
T34	530	T70M
T70M	607	PzVA
Type91_105mm	4590	SU-76M
Type91_105mm	3955	T70M
Type91_105mm	3606	T70M
Type91_105mm	1830	T34
Type91_105mm	3232	SU-76M
Type91_105mm	3723	T70M
Type91_105mm	449	T70M
Type91_105mm	3138	T34
Wespe	1614	SU-76M
Zenit61K	1806	PzIVJ
Zenit85mm_1939	3905	PzIVJ
ZIS3	175	PzVA
ZIS3	1378	PzVA

 

Supporting SQL Query

SET @VICTIMTYPE = "T%";
SELECT DISTINCT A.Mission,A.EventTime,A.Protagonist,A.Protagonist_Type,A.Protagonist_X,A.Protagonist_Y,ObjMissionData.Unit_Name AS Antagonist,
ObjMissionData.Obj_Type AS Antagonist_Type, ObjMissionData.Start_X_Axis AS Antagonist_X, ObjMissionData.Start_Y_Axis AS Antagonist_Y,
ROUND(SQRT((A.Protagonist_X-ObjMissionData.Start_X_Axis)*(A.Protagonist_X-ObjMissionData.Start_X_Axis)+ (A.Protagonist_Y-ObjMissionData.Start_Y_Axis)*(A.Protagonist_Y-ObjMissionData.Start_Y_Axis))) AS Kill_Distance
FROM ObjMissionData,Unit_Name_Mapping,(SELECT Mission, EventTime, ObjMissionData.Unit_Name AS Protagonist, Obj_Type AS Protagonist_Type, ActionData.X_Axis AS Protagonist_X, ActionData.Y_Axis AS Protagonist_Y,
ActionData.Obj2Group AS Antagonist FROM ActionData,ObjMissionData,Object_Specifications
WHERE ActionData.Mission=ObjMissionData.Mission_Name AND ActionData.Event='destroyed by' AND ActionData.Obj1Group=ObjMissionData.Obj_Group_Name
AND ObjMissionData.Obj_Type=Object_Specifications.Object_Type AND Object_Specifications.Object_Class LIKE @VICTIMTYPE ORDER BY ActionData.Mission,ActionData.EventTime) AS A
WHERE A.Mission=ObjMissionData.Mission_Name AND A.Antagonist=ObjMissionData.Obj_Group_Name AND A.Mission=Unit_Name_Mapping.Mission
AND ObjMissionData.Obj_Group_Name=Unit_Name_Mapping.Unit_Name AND Unit_Name_Mapping.InGame_Name LIKE '%Static';