Articles, created in certain period and edited in certain period whose talk pages belong to certain category

SQL

SELECT P1.page_title, R.rev_user_text, R.rev_timestamp, RE.rev_timestamp
FROM ukwiki_p.revision R
 JOIN ukwiki_p.page P1 ON R.rev_page = P1.page_id
 JOIN ukwiki_p.page P2 ON P1.page_title = P2.page_title
 JOIN ukwiki_p.categorylinks CL ON P2.page_id = CL.cl_from
 LEFT JOIN ukwiki_p.revision RE ON P1.page_id = RE.rev_page
WHERE R.rev_parent_id = 0
 AND P1.page_namespace = 0
 AND P2.page_namespace = 1
 AND RE.rev_parent_id <> 0
 AND CL.cl_to = "Статті_Вікімарафону_2019"
 AND R.rev_timestamp<20190126000000
 AND RE.rev_timestamp>=20190127000000
 AND RE.rev_timestamp< 20190128000000
ORDER BY P1.page_len DESC#R.rev_timestamp ASC

SQL

Checking query status...