query

                $sql = 'SELECT a.user_id, a.user_colour, a.username, a.ums_kick, a.ums_kick_owner, b.user_id AS owner_user_id, b.user_colour AS owner_user_colour, b.username AS owner_username
                       FROM ' . USERS_TABLE . ' a
                       INNER JOIN ' . USERS_TABLE . ' b
                        ON b.user_id = a.ums_kick_owner
                            WHERE a.ums_kick ' . $db->sql_like_expression($db->any_char . 's:6:"kicked";b:1;}') . '
                                AND a.user_type <> ' . USER_IGNORE . '
                                    ORDER BY a.username ASC';
                    $result = $db->sql_query($sql);