Miscellany

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` )  );