Database error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'list.kll_timestamp' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by<br />SQL: 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_detail ind ON ind.ind_kll_id = kll.kll_id  WHERE ( ind.ind_plt_id IN (1,2,8734 )  ) AND shp.shp_class in ( 49 )  order by ind.ind_timestamp desc limit 300 ) UNION (SELECT kll.* FROM kb3_kills kll  STRAIGHT_JOIN kb3_ships shp on kll.kll_ship_id = shp.shp_id  WHERE  (   kll.kll_victim_id in ( 1,2,8734 ) )  AND shp.shp_class in ( 49 )  order by kll.kll_timestamp desc limit 300 ) ) 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 300 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 = "yeshua" OR com.site IS NULL)) group by list.kll_id order by kll_timestamp desc /* kill list */<br />