query

                    if ( $kick_set )
                    {
                        $sql_where = 'WHERE a.user_id = \'' . (int) $kick_set . '\'';
                    }
                    else
                    {
                        $sql_where = 'WHERE a.username_clean = \'' . (string) $db->sql_escape(utf8_clean_string($uname)) . '\'';
                    }
                    $sql = 'SELECT a.user_id, a.user_colour, a.username, a.group_id, a.ums_kick_owner,
                                    b.group_name, b.group_id, b.group_colour,
                                     c.user_id AS owner_user_id, c.user_colour AS owner_user_colour, c.username AS owner_username, c.group_id AS owner_group_id,
                                      d.group_name AS owner_group_name, d.group_id AS owner_group_id, d.group_colour AS owner_group_colour
                                FROM ' . USERS_TABLE . ' a
                                    INNER JOIN ' . GROUPS_TABLE . ' b
                                        INNER JOIN ' . USERS_TABLE . ' c
                                            INNER JOIN ' . GROUPS_TABLE . ' d
                                                ON (b.group_id = a.group_id AND d.group_id = c.group_id AND c.user_id = a.ums_kick_owner) ' . $sql_where;
                    $result = $db->sql_query_limit($sql, 1);