use plwikisource_p;

​

SELECT

    'PWhS' AS type,

    page_title AS title,

    page_len AS len,

    rev_id as id,

    DATE_FORMAT(MAX(rev_timestamp),'%Y-%m-%d') AS ledit_date,

    DATE_FORMAT(MIN(rev_timestamp),'%Y-%m-%d') AS create_date

FROM

    revision, page

WHERE

    page_id = rev_page AND

    page_content_model <> rev_content_model AND

    page_namespace = 100 AND

    page_is_redirect = 0

GROUP BY title

ORDER BY ledit_date

LIMIT 7000;