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 ((SELECT kll.* FROM kb3_kills kll  INNER JOIN kb3_ships shp on kll.kll_ship_id = shp.shp_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-06-26 12:33:00'  AND ina.ina_timestamp <= '2017-07-26 12:33:00'  AND shp.shp_class not in ( 2,3,11,53 ) order by kll_isk_loss DESC limit 6 ) UNION (SELECT kll.* FROM kb3_kills kll  STRAIGHT_JOIN kb3_ships shp on kll.kll_ship_id = shp.shp_id  WHERE  (   kll.kll_all_id in ( 1 ) )  AND kll.kll_timestamp >= '2017-06-26 12:33:00'  AND kll.kll_timestamp <= '2017-07-26 12:33:00'  AND shp.shp_class not in ( 2,3,11,53 ) order by kll_isk_loss DESC limit 6 ) ) 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 ) order by kll_isk_loss DESC limit 6 OFFSET 0 /* 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 ((SELECT kll.* FROM kb3_kills kll  INNER JOIN kb3_ships shp on kll.kll_ship_id = shp.shp_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-06-26 12:33:00'  AND ina.ina_timestamp <= '2017-07-26 12:33:00'  AND shp.shp_class in ( 2 )  order by kll_isk_loss DESC limit 6 ) UNION (SELECT kll.* FROM kb3_kills kll  STRAIGHT_JOIN kb3_ships shp on kll.kll_ship_id = shp.shp_id  WHERE  (   kll.kll_all_id in ( 1 ) )  AND kll.kll_timestamp >= '2017-06-26 12:33:00'  AND kll.kll_timestamp <= '2017-07-26 12:33:00'  AND shp.shp_class in ( 2 )  order by kll_isk_loss DESC limit 6 ) ) 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 ) order by kll_isk_loss DESC limit 6 OFFSET 0 /* 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 ((SELECT kll.* FROM kb3_kills kll  INNER JOIN kb3_ships shp on kll.kll_ship_id = shp.shp_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-07-01 00:00:00'  AND ina.ina_timestamp <= '2017-07-31 23:59:00'  AND shp.shp_class in ( 27 )  order by ina.ina_timestamp desc ) UNION (SELECT kll.* FROM kb3_kills kll  STRAIGHT_JOIN kb3_ships shp on kll.kll_ship_id = shp.shp_id  WHERE  (   kll.kll_all_id in ( 1 ) )  AND kll.kll_timestamp >= '2017-07-01 00:00:00'  AND kll.kll_timestamp <= '2017-07-31 23:59:00'  AND shp.shp_class in ( 27 )  order by kll.kll_timestamp desc ) ) 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 ) order by kll.kll_timestamp desc limit 100 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 July, 2017
July, 2017
Active campaigns
Name Start date Kills ISK (B) Losses ISK (B) Efficiency
JEIV pocket Defence 2012-09-18 25895 1907.88 17059 1676.67 53.23
 
Providence Campaign 2010-05-09 120723 11084.21 46168 3652.09 75.22
 
Catch Region Skirmishes 2010-05-09 45005 3934.95 9765 483.62 89.05
 
HED-GP Raids 2010-05-09 7538 681.77 1654 72.54 90.38
 
Most expensive Kills and Losses for the past 30 days.
 YF Holdings - XHQ-7V  Arttu  Archeras Umangiar  gobbergreen  Funis Boring  Galq
Fortizar Fortizar
XHQ-7V
(0.0)
Ark Ark
XHQ-7V
(0.0)
Moros Moros
U-HYMT
(0.0)
Apostle Apostle
XHQ-7V
(0.0)
Revelation Revelation
XHQ-7V
(0.0)
Revelation Revelation
XHQ-7V
(0.0)
23.14 Billion ISK 9.77 Billion ISK 4.28 Billion ISK 4.01 Billion ISK 3.45 Billion ISK 3.39 Billion ISK
Most expensive Pod Kills and Losses for the past 30 days.
 Tufir Hwat  The Hun Terona  Arttu  Royter Toleran  Fluffy Bunny123  El Trox
https://imageserver.eveonline.com/Character/368689456_64.jpg Capsule
Amarr
(1.0)
https://imageserver.eveonline.com/Character/95393100_64.jpg Capsule
JEIV-E
(0.0)
https://imageserver.eveonline.com/Character/761353702_64.jpg Capsule
KBP7-G
(0.0)
https://imageserver.eveonline.com/Character/93175748_64.jpg Capsule
N-RMSH
(0.0)
https://imageserver.eveonline.com/Character/93922391_64.jpg Capsule
F-YH5B
(0.0)
https://imageserver.eveonline.com/Character/1540809418_64.jpg Capsule
Niarja
(0.5)
2.58 Billion ISK 1.19 Billion ISK 1.12 Billion ISK 1.01 Billion ISK 921.20 Million ISK 873.02 Million ISK
Monday, July 24th

Ship type Victim Final blow Location Value
Chimera
Carrier
None
Providence, XHQ-7V (0.0)
I: 70 C: 0
1.71B
Sunday, July 16th

Ship type Victim Final blow Location Value
Thanatos
Carrier
Cohortes Triarii
Providence, 0B-HLZ (0.0)
I: 40 C: 0
2.57B
Chimera
Carrier
Cohortes Triarii
Providence, 0B-HLZ (0.0)
I: 42 C: 0
2.13B
Saturday, July 15th

Ship type Victim Final blow Location Value
Thanatos
Carrier
Unreasonable Bastards
Catch, 36N-HZ (0.0)
I: 84 C: 0
2.97B
Sunday, July 9th

Ship type Victim Final blow Location Value
Thanatos
Carrier
Yulai Federation
Providence, IWZ3-C (0.0)
I: 13 C: 0
2.76B
Thursday, July 6th

Ship type Victim Final blow Location Value
Nidhoggur
Carrier
Tactical Supremacy
Catch, RNF-YH (0.0)
I: 16 C: 0
1.68B
Tuesday, July 4th

Ship type Victim Final blow Location Value
Thanatos
Carrier
Yulai Federation
Providence, K1Y-5H (0.0)
I: 8 C: 0
2.48B
Saturday, July 1st

Ship type Victim Final blow Location Value
Thanatos
Carrier
None
Providence, KBP7-G (0.0)
I: 34 C: 0
2.01B
Menu
Top killers
medal
1. Salvadar King
 
179

2.Boy Scout
 
93
3.Drizzt Entreri
 
90
4.Eragorn Uisen
 
83
5.Colindy Telemnar
 
81
6.Arttu
 
74
7.Jordan Calleste
 
70
8.Rounon Dax
 
68
9.Douche Baag
 
59
10.Zoya Talvanen
 
59
(ship kills in July, 2017)
Top scorers
medal
1. Arttu
 
5852

2.Salvadar King
 
5818
3.Atmo Cesaille
 
5495
4.Drizzt Entreri
 
4698
5.Zmeul Celmare
 
4431
6.Boy Scout
 
4417
7.Jordan Calleste
 
3937
8.Colindy Telemnar
 
3493
9.Rounon Dax
 
3362
10.Douche Baag
 
3331
(killpoints in July, 2017)
Top Corp Killers
pilot award
1. Valkyrie Knights
 
423
2.Terra Nanotech
 
250
3.MUSE LLP
 
243
4.Lone Wolf Union
 
222
5.Globaltech Industries
 
176
6.Yulai Guard
 
175
7.Sister of Eve-Universe
 
110
8.Blake Industries
 
89
9.Zarnfell
 
77
10.Noobs for Ethnical Treatment of Scrubs
 
58
(kills in July, 2017)
Darkside theme by J nx and Trent Angelus, Converted to EDK4 by Vecati
from DS-Natural designed by DzinerStudio