MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()
10.3.28-MariaDB

CREATE TABLE edits (

edit_id INT,

edit_page_id INT,

edit_time INT,

stat INT

);

CREATE TABLE pages (

page_id INT,

cat_id INT

);

INSERT INTO edits VALUES (1, 10, 20210502, 90);

INSERT INTO edits VALUES (2, 10, 20210503, 91);

INSERT INTO edits VALUES (3, 20, 20210504, 91);

INSERT INTO edits VALUES (4, 30, 20210504, 90);

INSERT INTO edits VALUES (5, 30, 20210505, 92);

INSERT INTO edits VALUES (6, 40, 20210505, 90);

INSERT INTO edits VALUES (7, 50, 20210503, 90);

INSERT INTO pages VALUES (10, 100);

INSERT INTO pages VALUES (20, 100);

INSERT INTO pages VALUES (30, 100);

INSERT INTO pages VALUES (40, 100);

INSERT INTO pages VALUES (50, 200);

select

t1.stat, count(*) count_

from

(

SELECT

e.edit_id, p.page_id, e.stat,

rank() over(partition by e.edit_page_id order by e.edit_time desc) edit_rank