use eswiki_p;

SELECT distinct page_id, page_title, cl_timestamp, user_name, DATEDIFF(now(), cl_timestamp) as days FROM categorylinks 

INNER JOIN page ON cl_from = page_id

INNER JOIN revision ON rev_page = page_id

INNER JOIN actor ON actor_id = rev_actor

INNER JOIN user ON actor_user = user_id

WHERE page_namespace = 0

    AND cl_to = "Wikipedia:Artículos_en_desarrollo"

    AND abs(convert(rev_timestamp, datetime) - cl_timestamp) < 30 -- 30 segundos de tolerancia entre la edición y la inserción de la categoría

ORDER BY 5 desc

LIMIT 10000;

SELECT user_name, count(1)

FROM categorylinks 

INNER JOIN page ON cl_from = page_id

INNER JOIN revision ON rev_page = page_id

INNER JOIN actor ON actor_id = rev_actor

INNER JOIN user ON actor_user = user_id

WHERE page_namespace = 0

    AND cl_to = "Wikipedia:Artículos_en_desarrollo"

    AND abs(convert(rev_timestamp, datetime) - cl_timestamp) < 30 -- 30 segundos de tolerancia entre la edición y la inserción de la categoría

GROUP BY user_name

ORDER BY 2 desc

LIMIT 10000