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_systems sys
					ON ( sys.sys_id = kll.kll_system_id ) 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_inv_detail ind ON (ind.ind_kll_id = kll.kll_id)
						WHERE (  ind.ind_plt_id in (108657 )  ) /* 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_systems sys
					ON ( sys.sys_id = kll.kll_system_id ) 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_inv_detail ind ON (ind.ind_kll_id = kll.kll_id)
						WHERE (  ind.ind_plt_id in (108657 )  ) /* 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_systems sys
					ON ( sys.sys_id = kll.kll_system_id ) 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 ) WHERE  (   kll.kll_victim_id in ( 108657 ) )  /* 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_systems sys
					ON ( sys.sys_id = kll.kll_system_id ) 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_inv_detail ind ON (ind.ind_kll_id = kll.kll_id)
						WHERE (  ind.ind_plt_id in (108657 )  ) order by ind.ind_timestamp desc limit 10 OFFSET 0) 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_systems sys
					ON ( sys.sys_id = kll.kll_system_id ) 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 ) WHERE  (   kll.kll_victim_id in ( 108657 ) )  order by kll.kll_timestamp desc limit 10 OFFSET 0) 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 Wood Vulcan
Wood Vulcan
Pilot Details
Lieutenant Junior Grade
Corporation: SniggWaffe
Alliance: WAFFLES.
Kills: 79
Real kills: 75
Losses: 29
Damage done (ISK): 323.22B
Damage received (ISK): 4.07B
Enemy survival: 27.88%
Pilot Efficiency (ISK): 98.76%
Medal Box
Lieutenant Junior Grade
Lieutenant Junior Grade
Abbreviation:

Month Kills ISK (B) Losses ISK (B) Efficiency
July, 2017185.3710.0499.28%
June, 201790.20111.0515.66%
May, 20173410.6731.5487.37%
April, 201730.1381.259.26%
December, 20162300.0320.1599.95%
July, 201652.0200.00100.00%
February, 201600.0010.030.00%
January, 201600.0010.000.00%
December, 201550.6220.0099.24%
November, 201534.1900.00100.00%

10 Most recent kills
Ship type Victim Final blow Location Value
Heretic
Interdictor
Yulai Federation
Providence, XHQ-7V (0.0)
I: 15 C: 0
68M
Caracal
Cruiser
Yulai Federation
Providence, XHQ-7V (0.0)
I: 14 C: 0
29M
Abaddon
Battleship
Yulai Federation
Providence, XHQ-7V (0.0)
I: 98 C: 0
280M
Abaddon
Battleship
None
Providence, XHQ-7V (0.0)
I: 135 C: 0
249M
Abaddon
Battleship
Yulai Federation
Providence, XHQ-7V (0.0)
I: 95 C: 0
359M
Abaddon
Battleship
Yulai Federation
Providence, XHQ-7V (0.0)
I: 110 C: 0
293M
Caracal
Cruiser
Yulai Federation
Providence, XHQ-7V (0.0)
I: 8 C: 0
24M
Cerberus
Heavy Assault Cruiser
Yulai Federation
Providence, XHQ-7V (0.0)
I: 12 C: 0
288M
Cerberus
Heavy Assault Cruiser
Yulai Federation
Providence, XHQ-7V (0.0)
I: 11 C: 0
303M
Scorpion
Battleship
Dark Taboo
Providence, KBP7-G (0.0)
I: 110 C: 0
194M
10 Most recent losses
Ship type Victim Final blow Location Value
Manticore
Covert Ops
WAFFLES.
Providence, XHQ-7V (0.0)
I: 2 C: 0
39M
Cruor
Frigate
WAFFLES.
Providence, N-RMSH (0.0)
I: 2 C: 0
65M
Capsule
Capsule
WAFFLES.
Providence, IWZ3-C (0.0)
I: 1 C: 0
725K
Confessor
Tactical Destroyer
WAFFLES.
Providence, IWZ3-C (0.0)
I: 1 C: 0
154M
Sabre
Interdictor
WAFFLES.
Providence, G-5EN2 (0.0)
I: 16 C: 0
73M
Capsule
Capsule
WAFFLES.
Providence, G-5EN2 (0.0)
I: 7 C: 0
0
Sabre
Interdictor
WAFFLES.
Providence, G-5EN2 (0.0)
I: 17 C: 0
76M
Capsule
Capsule
WAFFLES.
Providence, 9UY4-H (0.0)
I: 3 C: 0
3M
Cruor
Frigate
WAFFLES.
Providence, 9UY4-H (0.0)
I: 11 C: 0
70M
Legion
Strategic Cruiser
WAFFLES.
Providence, G-5EN2 (0.0)
I: 32 C: 0
528M
Menu
Kill points
Loss points
Total points
Darkside theme by J nx and Trent Angelus, Converted to EDK4 by Vecati
from DS-Natural designed by DzinerStudio