Untitled query #42176

SQL

use viwiki_p;
select CONCAT ("#[[",page_title,"]]") 
from page 
where page_id not in (select pp_page 
                      from page_props 
                                where pp_propname = "wikibase_item" 
                                and pp_page = page_id) 
                                and page_namespace = 14 
                                and page_is_redirect = 0;
                                and
SELECT page_title
FROM revision r
JOIN page on rev_page = page_id/*
/**/
WHERE r.rev_timestamp > '20190708235959'
AND r.rev_timestamp < '20190815235959'
AND r.rev_user_text = 'Ptthnhan'
AND page_is_redirect = 0 AND page_namespace = 0

AND r.rev_parent_id = 0
and page_len < 1500
SQL

Checking query status...
