CREATE TEMPORARY TABLE stevealikes
AS
(SELECT id, 1 AS hair, 0 AS beard, 0 AS eyes FROM appearance WHERE hair_colour = 'black')
UNION
(SELECT id, 0 AS hair, 1 AS beard, 0 AS eyes FROM appearance WHERE beard_style = 'long')
UNION
(SELECT id, 0 AS hair, 0 AS beard, 1 AS eyes FROM appearance WHERE eye_colour = 'green');
 
SELECT id, hair, beard, eyes, SUM(hair,beard,eyes) AS total
FROM stevealikes
GROUP BY id, hair, beard, eyes
ORDER BY total DESC;

CREATE TEMPORARY TABLE stevealikes
                                AS
                                (SELECT uid, 1 AS hair, 0 AS beard, 0 AS eyes FROM people_main WHERE des_haircolour = 'black')
                                UNION
                                (SELECT uid, 0 AS hair, 1 AS beard, 0 AS eyes FROM people_main WHERE des_facialhair = 'long')
                                UNION
                                (SELECT uid, 0 AS hair, 0 AS beard, 1 AS eyes FROM people_main WHERE des_eyecolour = 'green');
 
                                 
                                SELECT uid, hair, beard, eyes, SUM(hair,beard,eyes) AS total
                                FROM stevealikes
                                GROUP BY uid, hair, beard, eyes
                                ORDER BY total DESC;