How similar is this user?

similar.sql

SELECT 
  @UserBit_50 as 'UserBit_50 (This Should not Be Null!)',
  SUM(
    (
      convert( IFNULL(profilevalue_50, 0) , unsigned ) & 
      40988 /*@UserBit_50*/) > 0
  ) / (
    SELECT COUNT(*) FROM se_profilevalues
  ) AS 'Avg Intersection'
FROM 
  se_profilevalues 
WHERE 
  profilevalue_user_id != 1;

SELECT 
  BIT_COUNT(
    IFNULL(
      convert(Left.profilevalue_50, unsigned)
      ,0
    ) &
    IFNULL(
      convert(Right.profilevalue_50, unsigned)
      ,0
    ) 
  ) / (
    BIT_COUNT(
      IFNULL(
        convert(Left.profilevalue_50, unsigned)
        ,0
      )
    ) +
    BIT_COUNT(
      IFNULL(
        convert(Right.profilevalue_50, unsigned)
        ,0
      )
    )
  )
FROM se_profilevalues AS 'Left'
INNER JOIN se_profilevalues AS 'Right'
  ON Right.profilevalue_user_id = 2 /*Right User ID*/
WHERE
  Left.profilevalue_user_id = 1 /*Left User ID*/