SELECT
  `k`.`id` AS `id`,
  `k`.`timestamp` AS `timestamp`,
  `c`.`channel` AS `channel`,
  concat( `v1`.`nick`,_latin1'!', `v1`.`ident_name`, _latin1'@', `v1`.`hostname`) AS `kicked_by`,
  concat( `v2`.`nick`,_latin1'!', `v2`.`ident_name`, _latin1'@', `v2`.`hostname`) AS `kicked`,
  `q`.`message` AS `reason`
FROM
  (
    (
      (
        ( `view_user_id` `v1` on(`v1`.`id` = `k`.`kicker_user_id`) )
        JOIN
        ( `view_user_id` `v2` on(`v2`.`id` = `k`.`kicked_user_id`) )
      )
      JOIN
      `quit_messages` `q` on( `q`.`id` = `k`.`reason_id` )
    )
    JOIN
    `channels` `c` on( `c`.`id` = `k`.`channel_id` )
  );