Database error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'kll.kll_timestamp' which is not in SELECT list; this is incompatible with DISTINCT
SQL: SELECT DISTINCT kll_id FROM ((SELECT kll.* FROM kb3_kills kll INNER JOIN kb3_inv_crp inc ON inc.inc_kll_id = kll.kll_id WHERE inc.inc_crp_id IN (1 ) AND inc.inc_timestamp >= '2018-12-31 00:00:00' AND inc.inc_timestamp <= '2019-01-06 23:59:59' order by inc.inc_timestamp desc ) UNION (SELECT kll.* FROM kb3_kills kll WHERE ( kll.kll_crp_id in ( 1 ) ) AND kll.kll_timestamp >= '2018-12-31 00:00:00' AND kll.kll_timestamp <= '2019-01-06 23:59:59' order by kll.kll_timestamp desc ) ) kll order by kll.kll_timestamp desc