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 'التعديل الأخير',

FROM page 

        page_is_redirect=1

        AND page_namespace=2 

        AND page_content_model ='wikitext'

​

ORDER BY page_id DESC

Limit 100;