Which users are similar to me

similar.sql

SELECT 
  @UserBit_50 = 
    IFNULL(
      convert(profilevalue_50, unsigned)
      ,0
    ) 
FROM 
  se_profilevalues 
WHERE 
  profilevalue_user_id = 1;

SELECT 
  SUM(
    (
      convert( IFNULL(profilevalue_50, 0) , unsigned ) & 
      @UserBit_50) > 0
    ) / (
      SELECT COUNT(*) FROM se_profilevalues
    ) AS 'Avg Intersection'
FROM 
  se_profilevalues 
WHERE 
  profilevalue_user_id != 1