SELECT kll.kll_id, kll.kll_timestamp, kll.kll_external_id, mdn.itemID, mdn.itemName, plt.plt_name, crp.crp_name, crp.crp_id, ali.all_name, ali.all_id, kll.kll_system_id, kll.kll_ship_id, kll.kll_dmgtaken, kll.kll_victim_id, plt.plt_externalid, kll.kll_crp_id, kll.kll_points, kll.kll_isk_loss, shp.shp_class, shp.shp_id, scl.scl_id, scl.scl_class, scl.scl_value, sys.sys_id, sys.sys_name, sys.sys_sec, fbplt.plt_name as fbplt_name, fbplt.plt_id as fbplt_id, fbplt.plt_externalid as fbplt_externalid, fbcrp.crp_name as fbcrp_name, fbali.all_name as fball_name, fbcrp.crp_id as fbcrp_id, fbali.all_id as fball_id    FROM  kb3_kills kll  STRAIGHT_JOIN kb3_pilots plt
								ON ( plt.plt_id = kll.kll_victim_id )
							STRAIGHT_JOIN kb3_corps crp
								ON ( crp.crp_id = kll.kll_crp_id )
							STRAIGHT_JOIN kb3_alliances ali
								ON ( ali.all_id = kll.kll_all_id )
							STRAIGHT_JOIN kb3_pilots fbplt
								ON ( fbplt.plt_id = kll.kll_fb_plt_id )
							STRAIGHT_JOIN kb3_inv_detail fb
								ON ( fb.ind_kll_id = kll.kll_id AND fb.ind_plt_id = kll.kll_fb_plt_id )
							STRAIGHT_JOIN kb3_corps fbcrp
								ON ( fbcrp.crp_id = fb.ind_crp_id )
							STRAIGHT_JOIN kb3_alliances fbali
								ON ( fbali.all_id = fb.ind_all_id )
                                                        LEFT JOIN kb3_mapdenormalize mdn
                                                                ON (kll.kll_location = mdn.itemID)
						    STRAIGHT_JOIN kb3_ships shp
					ON ( shp.shp_id = kll.kll_ship_id )
					STRAIGHT_JOIN kb3_ship_classes scl
					ON ( scl.scl_id = shp.shp_class ) INNER JOIN kb3_systems sys
					ON ( sys.sys_id = kll.kll_system_id ) INNER JOIN kb3_inv_all ina ON (ina.ina_kll_id = kll.kll_id)
						WHERE ina.ina_all_id in (1 )  AND ina.ina_timestamp >= '2017-04-21 02:49:10'  AND ina.ina_timestamp <= '2017-04-21 02:55:25'  AND kll.kll_system_id in ( 30001205) order by ina.ina_timestamp desc /* kill list */
SELECT kll.kll_id, kll.kll_timestamp, kll.kll_external_id, mdn.itemID, mdn.itemName, plt.plt_name, crp.crp_name, crp.crp_id, ali.all_name, ali.all_id, kll.kll_system_id, kll.kll_ship_id, kll.kll_dmgtaken, kll.kll_victim_id, plt.plt_externalid, kll.kll_crp_id, kll.kll_points, kll.kll_isk_loss, shp.shp_class, shp.shp_id, scl.scl_id, scl.scl_class, scl.scl_value, sys.sys_id, sys.sys_name, sys.sys_sec, fbplt.plt_name as fbplt_name, fbplt.plt_id as fbplt_id, fbplt.plt_externalid as fbplt_externalid, fbcrp.crp_name as fbcrp_name, fbali.all_name as fball_name, fbcrp.crp_id as fbcrp_id, fbali.all_id as fball_id    FROM  kb3_kills kll  STRAIGHT_JOIN kb3_pilots plt
								ON ( plt.plt_id = kll.kll_victim_id )
							STRAIGHT_JOIN kb3_corps crp
								ON ( crp.crp_id = kll.kll_crp_id )
							STRAIGHT_JOIN kb3_alliances ali
								ON ( ali.all_id = kll.kll_all_id )
							STRAIGHT_JOIN kb3_pilots fbplt
								ON ( fbplt.plt_id = kll.kll_fb_plt_id )
							STRAIGHT_JOIN kb3_inv_detail fb
								ON ( fb.ind_kll_id = kll.kll_id AND fb.ind_plt_id = kll.kll_fb_plt_id )
							STRAIGHT_JOIN kb3_corps fbcrp
								ON ( fbcrp.crp_id = fb.ind_crp_id )
							STRAIGHT_JOIN kb3_alliances fbali
								ON ( fbali.all_id = fb.ind_all_id )
                                                        LEFT JOIN kb3_mapdenormalize mdn
                                                                ON (kll.kll_location = mdn.itemID)
						    STRAIGHT_JOIN kb3_ships shp
					ON ( shp.shp_id = kll.kll_ship_id )
					STRAIGHT_JOIN kb3_ship_classes scl
					ON ( scl.scl_id = shp.shp_class ) INNER JOIN kb3_systems sys
					ON ( sys.sys_id = kll.kll_system_id ) WHERE  kll.kll_timestamp >= '2017-04-21 02:49:10'  AND kll.kll_timestamp <= '2017-04-21 02:55:25'  AND  (   kll.kll_all_id in ( 1 ) )  AND  kll.kll_system_id in ( 30001205) order by kll.kll_timestamp desc /* kill list */
SELECT list.* , count(distinct com.id) as comments, count(distinct ind.ind_order) as inv FROM (SELECT kll.kll_id, kll.kll_timestamp, kll.kll_external_id, mdn.itemID, mdn.itemName, plt.plt_name, crp.crp_name, crp.crp_id, ali.all_name, ali.all_id, kll.kll_system_id, kll.kll_ship_id, kll.kll_dmgtaken, kll.kll_victim_id, plt.plt_externalid, kll.kll_crp_id, kll.kll_points, kll.kll_isk_loss, shp.shp_class, shp.shp_id, scl.scl_id, scl.scl_class, scl.scl_value, sys.sys_id, sys.sys_name, sys.sys_sec, fbplt.plt_name as fbplt_name, fbplt.plt_id as fbplt_id, fbplt.plt_externalid as fbplt_externalid, fbcrp.crp_name as fbcrp_name, fbali.all_name as fball_name, fbcrp.crp_id as fbcrp_id, fbali.all_id as fball_id    FROM  kb3_kills kll  STRAIGHT_JOIN kb3_pilots plt
								ON ( plt.plt_id = kll.kll_victim_id )
							STRAIGHT_JOIN kb3_corps crp
								ON ( crp.crp_id = kll.kll_crp_id )
							STRAIGHT_JOIN kb3_alliances ali
								ON ( ali.all_id = kll.kll_all_id )
							STRAIGHT_JOIN kb3_pilots fbplt
								ON ( fbplt.plt_id = kll.kll_fb_plt_id )
							STRAIGHT_JOIN kb3_inv_detail fb
								ON ( fb.ind_kll_id = kll.kll_id AND fb.ind_plt_id = kll.kll_fb_plt_id )
							STRAIGHT_JOIN kb3_corps fbcrp
								ON ( fbcrp.crp_id = fb.ind_crp_id )
							STRAIGHT_JOIN kb3_alliances fbali
								ON ( fbali.all_id = fb.ind_all_id )
                                                        LEFT JOIN kb3_mapdenormalize mdn
                                                                ON (kll.kll_location = mdn.itemID)
						    STRAIGHT_JOIN kb3_ships shp
					ON ( shp.shp_id = kll.kll_ship_id )
					STRAIGHT_JOIN kb3_ship_classes scl
					ON ( scl.scl_id = shp.shp_class ) INNER JOIN kb3_systems sys
					ON ( sys.sys_id = kll.kll_system_id ) INNER JOIN kb3_inv_all ina ON (ina.ina_kll_id = kll.kll_id)
						WHERE ina.ina_all_id in (1 )  AND ina.ina_timestamp >= '2017-04-21 02:49:10'  AND ina.ina_timestamp <= '2017-04-21 02:55:25'  AND kll.kll_system_id in ( 30001205) order by ina.ina_timestamp desc) list join kb3_inv_detail ind ON (ind.ind_kll_id = list.kll_id) left join kb3_comments com ON (list.kll_id = com.kll_id AND (com.site = "YFMS" OR com.site IS NULL)) group by list.kll_id order by kll_timestamp desc /* kill list */
SELECT list.* , count(distinct com.id) as comments, count(distinct ind.ind_order) as inv FROM (SELECT kll.kll_id, kll.kll_timestamp, kll.kll_external_id, mdn.itemID, mdn.itemName, plt.plt_name, crp.crp_name, crp.crp_id, ali.all_name, ali.all_id, kll.kll_system_id, kll.kll_ship_id, kll.kll_dmgtaken, kll.kll_victim_id, plt.plt_externalid, kll.kll_crp_id, kll.kll_points, kll.kll_isk_loss, shp.shp_class, shp.shp_id, scl.scl_id, scl.scl_class, scl.scl_value, sys.sys_id, sys.sys_name, sys.sys_sec, fbplt.plt_name as fbplt_name, fbplt.plt_id as fbplt_id, fbplt.plt_externalid as fbplt_externalid, fbcrp.crp_name as fbcrp_name, fbali.all_name as fball_name, fbcrp.crp_id as fbcrp_id, fbali.all_id as fball_id    FROM  kb3_kills kll  STRAIGHT_JOIN kb3_pilots plt
								ON ( plt.plt_id = kll.kll_victim_id )
							STRAIGHT_JOIN kb3_corps crp
								ON ( crp.crp_id = kll.kll_crp_id )
							STRAIGHT_JOIN kb3_alliances ali
								ON ( ali.all_id = kll.kll_all_id )
							STRAIGHT_JOIN kb3_pilots fbplt
								ON ( fbplt.plt_id = kll.kll_fb_plt_id )
							STRAIGHT_JOIN kb3_inv_detail fb
								ON ( fb.ind_kll_id = kll.kll_id AND fb.ind_plt_id = kll.kll_fb_plt_id )
							STRAIGHT_JOIN kb3_corps fbcrp
								ON ( fbcrp.crp_id = fb.ind_crp_id )
							STRAIGHT_JOIN kb3_alliances fbali
								ON ( fbali.all_id = fb.ind_all_id )
                                                        LEFT JOIN kb3_mapdenormalize mdn
                                                                ON (kll.kll_location = mdn.itemID)
						    STRAIGHT_JOIN kb3_ships shp
					ON ( shp.shp_id = kll.kll_ship_id )
					STRAIGHT_JOIN kb3_ship_classes scl
					ON ( scl.scl_id = shp.shp_class ) INNER JOIN kb3_systems sys
					ON ( sys.sys_id = kll.kll_system_id ) WHERE  kll.kll_timestamp >= '2017-04-21 02:49:10'  AND kll.kll_timestamp <= '2017-04-21 02:55:25'  AND  (   kll.kll_all_id in ( 1 ) )  AND  kll.kll_system_id in ( 30001205) order by kll.kll_timestamp desc) list join kb3_inv_detail ind ON (ind.ind_kll_id = list.kll_id) left join kb3_comments com ON (list.kll_id = com.kll_id AND (com.site = "YFMS" OR com.site IS NULL)) group by list.kll_id order by kll_timestamp desc /* kill list */
Yulai Federation Military Statistics Related kills & losses
Related kills & losses
Battle in CB4-Q2 (Catch), 21-04-2017 (02:49 - 02:55)
Friendly (47)

Pilot/Ship/Kills Corp/Alliance
Therapist Chester
Thanatos
N° 2
16.7 %
Hang out with your Wang out
None
Sawney JuskaRath
Abaddon
N° 1
8.3 %
Pleasant Peninsula Productions
Sanctuary Pact
RC Mingus
Armageddon
N° 2
16.7 %
S.E.S.
Apocalypse Now.
Serenity Xadi
Armageddon
N° 1
8.3 %
Skara Admiralty
Yulai Federation
IWASHO
Bhaalgorn
N° 6
50.0 %
The Stars in heaven
Yulai Federation
Arcus Maximus
Hyperion
N° 3
25.0 %
The Meridian Conclave
Yulai Federation
Aeryn-Sun
Legion
N° 5
41.7 %
Panda Express Inc.
Elemental Tide
realmkiller
Legion
N° 1
8.3 %
Occidendi
Apocalypse Now.
Fraan Anbee
Megathron
N° 4
33.3 %
Ember Inc.
Curatores Veritatis Alliance
jet Bob
Megathron
N° 1
8.3 %
Aetherium.
Almost Broken
Pomsta Atram
Typhoon
N° 3
25.0 %
The Meridian Conclave
Yulai Federation
catbrizzle
Typhoon
N° 4
33.3 %
Lone Wolf Union
Yulai Federation
Terechkovah
Vindicator
N° 4
33.3 %
Cohortes Vigilum
Curatores Veritatis Alliance
Jara Keam
Devoter
N° 2
16.7 %
D3RP Clan
Elemental Tide
Rhenia Lachesis
Devoter
N° 5
41.7 %
Valkyrie Knights
Yulai Federation
SSRAT
Devoter
N° 4
33.3 %
Un4seen Development
Sev3rance
J'arten
Sacrilege
N° 4
33.3 %
0rizen Irregulars
Sev3rance
M'lany
Sacrilege
N° 6
50.0 %
0rizen Irregulars
Sev3rance
BillyPilgrim
Falcon
N° 2
16.7 %
Un4seen Development
Sev3rance
Benedictus Hartmann
Confessor
N° 5
41.7 %
Fritz..
Sev3rance
Mara Arthie
Svipul
N° 5
41.7 %
Miners Of New Eden
Silent Infinity
ChristianBlood Blood
Brutix
N° 5
41.7 %
ExDominion
Evictus.
Hamfish Shades
Brutix
N° 2
16.7 %
ExDominion
Evictus.
Gavin Genisis
Gnosis
N° 2
16.7 %
Arx One
Arx Alliance
Divis Xuore
Harbinger
N° 3
25.0 %
Order In Disorder
Curatores Veritatis Alliance
razer maden
Hurricane Fleet Issue
N° 3
25.0 %
Black Scorpion Society
Apocalypse Now.
Lara Kindar
Oracle
N° 3
25.0 %
IONSTAR
Yulai Federation
Adam Jensen X
Talos
N° 6
50.0 %
Star Nation
Elemental Tide
Nakabayashi
Talos
N° 5
41.7 %
Planet - Express
Silent Infinity
I'm Withim
Ashimmu
N° 5
41.7 %
Pleasant Peninsula Productions
Sanctuary Pact
Robert Boret
Augoror
N° 1
8.3 %
Lone Wolf Union
Yulai Federation
Streetlamp Gannon
Augoror Navy Issue
N° 5
41.7 %
Yulai Guard
Yulai Federation
Haege Azizora
Blackbird
N° 5
41.7 %
Callide Vulpis
Curatores Veritatis Alliance
Nemelle
Caracal
N° 3
25.0 %
Yulai Guard
Yulai Federation
Dewy Pantee
Maller
N° 5
41.7 %
MUSE LLP
Arx Alliance
Key Longstride
Rupture
N° 1
8.3 %
Pentag Blade
Curatores Veritatis Alliance
Tai Creire-Geng
Thorax
N° 3
25.0 %
ExDominion
Evictus.
Skippio77 Arkangel
Vexor Navy Issue
N° 2
16.7 %
Unity Ventures
Apocalypse Now.
Dom Aumer
Vigilant
N° 4
33.3 %
Lone Wolf Union
Yulai Federation
Atmo Cesaille
Nemesis
N° 5
41.7 %
Valkyrie Knights
Yulai Federation
Vanokc Alland
Nemesis
N° 6
50.0 %
Aquilia Cohors Praetoria
Curatores Veritatis Alliance
Valkorsia
Wolf
N° 4
33.3 %
IONSTAR
Yulai Federation
Moka-chan Kira
Eris
N° 1
8.3 %
Lone Wolf Union
Yulai Federation
Silenar
Magus
N° 3
25.0 %
Ad Perpetuam Memoriam Heideran VII
Silent Infinity
Combelvon Bouchard
Stiletto
N° 6
50.0 %
0rizen Irregulars
Sev3rance
MasterChiff
Taranis
N° 1
8.3 %
Lone Star Warriors
Evictus.
Red Tear
Republic Fleet Firetail
N° 1
8.3 %
Skara Admiralty
Yulai Federation
Hostile (6)

Pilot/Ship/Kills Corp/Alliance
Feylore
Thanatos
N° 0
0.0 %
No-Mercy
DRONE WALKERS
Feylore
Templar I
N° 1
100.0 %
No-Mercy
DRONE WALKERS
Xax Tannor
Hurricane
N° 0
0.0 %
No-Mercy
DRONE WALKERS
Wasabi Sky
Myrmidon
N° 0
0.0 %
Imperial Guardians
DRONE WALKERS
Sicarius Mortem
Caracal
N° 0
0.0 %
No-Mercy
DRONE WALKERS
Dusty Fi
Catalyst
N° 0
0.0 %
Imperial Guardians
DRONE WALKERS
Keigs Oksaras
Sabre
N° 0
0.0 %
Imperial Guardians
DRONE WALKERS


  • Combined Fleet Battles Mod 0.2 Original Code by Quebnaric Deile
  • Enhanced and updated for EDK4 by Salvoxia
Darkside theme by J nx and Trent Angelus, Converted to EDK4 by Vecati
from DS-Natural designed by DzinerStudio