any626

   I have experience working at a startup and a large company (Amazon).

    property_id, user_id, value(string)
    1 (assume age), 1213,    60
    2 (gender),     1213,    female

    property_id, user_id, value_str, value_int
    1 (assume age), 1213,    null, 60
    2 (gender),     1213,    female, null

    SELECT DISTINCT loyaltyMemberID
    from members as m
    INNER JOIN properties as p1 on m.id = p1.user_id
    INNER JOIN properties as p2 on m.id = p2.user_id
    INNER JOIN properties as p3 on m.id = p3.user_id
    AND (p1.prop = 'gender' AND p1.value = x)
    AND ((p2.prop = 'age' AND p2.value = y) OR (p3.prop = 'censor' AND p3.value = z))

    id, name, age, gender
    1213, fake, 60, female

    property_id, user_id, value
    1 (assume age), 1213,    60
    2 (gender),     1213,    female