USE arwiki_p;

SET @start_date = '20040101000000';

SET @end_date = '20042131000000';

SELECT

  article.page_title as "المقالة", MIN(revision.rev_id) as "النسخة", actor.actor_name as "المستخدم", revision.rev_actor as "معرف المستخدم",

  revision.rev_timestamp as "تاريخ الإنشاء",  article.page_len as "حجم المقالة"

FROM revision

inner join actor

on actor_id = rev_actor

INNER JOIN page article ON 

    article.page_id = rev_page AND

    article.page_namespace = 0 AND

    article.page_is_redirect = 0 

INNER JOIN page talk ON 

    talk.page_title = article.page_title AND

    talk.page_namespace = 1

INNER JOIN categorylinks ON 

    cl_from = talk.page_id

WHERE 

    #rev_timestamp > DATE_SUB(NOW(), INTERVAL 1 WEEK)

    rev_timestamp between @start_date and @end_date

    AND rev_parent_id = 0

GROUP BY article.page_id

#ORDER BY edits DESC

#LIMIT 25;