count eligible user votes, MySQL

Language: Layout:

drop table if exists user1;
create table user1 (
    user_uid varchar(100),
    first_name varchar(100),
    last_name varchar(100)
);
insert into user1 values
    ('abc123', 'bob', 'smith'),
    ('def456', 'rob', 'smithies'), 
    ('ghi789', 'john', 'clark');

drop table if exists event;
create table event (
    guid varchar(100),
    name varchar(100)
);
insert into event values
    ('ev1', 'event1'),
    ('ev2', 'event2'),
    ('ev3', 'event3');
    
drop table if exists user_event;
create table user_event (
    user_event_id int,
    user_uid varchar(100),
    event_uid varchar(100)
);
insert into user_event values
    (1, 'abc123', 'ev1'),
    (2, 'def456', 'ev2'),
    (3, 'ghi789', 'ev3');
    
drop table if exists event_vote;
create table event_vote (
    event_vote_id int,
    user_uid varchar(100),
    event_uid varchar(100)
);
insert into event_vote values
    (1, 'def456', 'ev1');

SELECT      t.*,
            @curRank := @curRank + 1 AS rank 
FROM        (
                SELECT     u.user_uid,
                           e.guid, 
                           e.name, 
                           count(ev.user_uid) votes, 
                           count(distinct case when u.user_uid in (ev.user_uid, ue.user_uid) then 1 end) ineligible 
                FROM       user1 u
                CROSS JOIN event e
                INNER JOIN user_event ue
                        ON ue.event_uid = e.guid
                LEFT JOIN  event_vote ev
                        ON ev.event_uid = e.guid
                GROUP BY   u.user_uid, 
                           e.guid
                ORDER BY   votes desc, e.guid, u.user_uid
            ) as t
CROSS JOIN (SELECT @curRank := 0) r
WHERE      t.user_uid = 'def456'
ORDER BY   votes desc, guid, user_uid


absolute service time: 0,43 sec