select scl_id, scl_class
                    from kb3_ship_classes
                   where scl_class not in ( 'Drone', 'Unknown' )
                  order by scl_class
          223 Query       select distinct kll.kll_id, kll.kll_timestamp, plt.plt_name,
                                crp.crp_name, crp.crp_id, ali.all_name, ali.all_id, kll.kll_ship_id,
                                kll.kll_system_id, kll.kll_ship_id,
                                kll.kll_victim_id, plt.plt_externalid,
                                kll.kll_crp_id, kll.kll_points,
                           shp.shp_class, shp.shp_name,
                            shp.shp_externalid, shp.shp_id,
                           scl.scl_id, scl.scl_class, scl.scl_value,
                           sys.sys_name, sys.sys_sec,
                                fbplt.plt_name as fbplt_name,
                                fbplt.plt_externalid as fbplt_externalid,
                                fbcrp.crp_name as fbcrp_name    from kb3_kills kll
            inner join kb3_ships shp
               on ( shp.shp_id = kll.kll_ship_id )
            inner join kb3_ship_classes scl
               on ( scl.scl_id = shp.shp_class )inner join kb3_pilots plt
                              on ( plt.plt_id = kll.kll_victim_id )
                           inner join kb3_corps crp
                              on ( crp.crp_id = kll.kll_crp_id )
                           inner join kb3_alliances ali
                              on ( ali.all_id = kll.kll_all_id )
                           inner join kb3_pilots fbplt
                              on ( fbplt.plt_id = kll.kll_fb_plt_id )
                           inner join kb3_corps fbcrp
                              on ( fbcrp.crp_id = kll.kll_fb_crp_id )
                           inner join kb3_systems sys
                              on ( sys.sys_id = kll.kll_system_id ) inner join kb3_inv_all ina
                         on ( ina.ina_all_id in ( 285 ) and kll.kll_id = ina.ina_kll_id
                               and ina.ina_all_id != kll.kll_all_id )  and date_format( kll.kll_timestamp, "%u" ) = 17 and date_format( kll.kll_timestamp, "%Y" ) = 2008