Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT list.* , count(distinct com.id) as comments FROM (
- SELECT kll.kll_id,
- kll.kll_timestamp,
- kll.kll_external_id,
- 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 )
- 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_all ina ON (ina.ina_kll_id = kll.kll_id)
- WHERE ina.ina_all_id in (3 ) AND shp.shp_class not in ( 2,3,11 ) order by ina.ina_timestamp desc limit 10 OFFSET 0) list left join kb3_comments com ON (list.kll_id = com.kll_id AND (com.site = "RADA" OR com.site IS NULL)) group by list.kll_id order by kll_timestamp desc /* kill list */
- TO :
- select ina_kll_id from kb3_inv_all ina
- join kb3_kills kll on ina_kll_id=kll_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 ina.ina_all_id = 3 AND shp.shp_class not in ( 2,3,11 ) order by ina.ina_timestamp desc limit 10 OFFSET 0
- -- select ina_kll_id from kb3_inv_all ina WHERE ina.ina_all_id = 3 order by ina.ina_timestamp desc limit 10 OFFSET 0
- SELECT list.* , count(distinct com.id) as comments FROM (
- SELECT kll.kll_id,
- kll.kll_timestamp,
- kll.kll_external_id,
- 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 )
- 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_id IN (75792,75791,75789,75787,75777,75753,75754,75756,75757,75758))
- list left join kb3_comments com ON (list.kll_id = com.kll_id AND (com.site = "RADA" OR com.site IS NULL)) group by list.kll_id order by kll_timestamp desc /* kill list */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement