use itwiki_p;

SELECT

    p.page_id AS "page_id",

    #CAST(p.page_title AS CHAR(10000) CHARACTER SET utf8) AS "page_title",

    #CONCAT ("# [[", p.page_title , "]]") AS "Titolo",

    CONCAT ("https://it.wikipedia.org/wiki/", p.page_title) AS "TITOLO",

    p.page_is_new AS "page_new",

    #p.page_namespace AS "page_namespace",

    #p.page_is_redirect AS "page_is_redirect",

    #r.rev_text_id AS "revision_id",

    r.rev_timestamp AS "time Stamp"

    #p.page_latest, r.rev_id

​

    #t.old_id AS "text_id"

FROM

    page p

        INNER JOIN revision r

            ON ( #p.page_latest = r.rev_id or 

                 r.rev_page = p.page_id 

                 AND r.rev_id = (select min(rr.rev_id) from revision rr where r.rev_page = rr.rev_page) )

        #INNER JOIN text t

        #    ON r.rev_text_id = t.old_id

WHERE r.rev_timestamp >= "20160401000000"       

  and r.rev_timestamp <= "20160401235959"

  #and p.page_is_new = 1

  and p.page_namespace = 0

  and p.page_is_redirect = 0

  #p.page_title = "ALTRAN"

order by r.rev_timestamp desc