Untitled query #4643

SQL

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 page_namespace = 0
AND text_id REGEXP "tipocolore(\ {0,22})\=.(\ {0,22})(?!colore|B\/N)\w*"
AND text_id REGEXP "\{\{Film"
SQL

Checking query status...
