SET @start_date = '20240101000000';

SET @end_date =   '20241231000000';

SELECT CONCAT('[[user:',page_Title,']]') AS 'عنوان_الصفحة_الأصلية', 

    page_len AS 'حجم_الصفحة_الأصلية',

    CONCAT('[[user:',page_Title,"&oldid=",page_latest,']]') AS 'التعديل الأخير',

    page_content_model

​

FROM page rd

inner join actor on actor_id = rev_actor

WHERE page_is_redirect=1

        AND page_namespace=2 

        AND page_content_model ='wikitext'

​

ORDER BY page_id DESC

Limit 100;