Revisions for new pages from namespace 0 not in page_props

SQL

use wikidatawiki_p;

describe page_props;
#SELECT COUNT(*)
#FROM page_props;

use enwiki_p;
describe recentchanges;

SELECT count(*) 
FROM recentchanges
INNER JOIN 
page_props
ON pp_page = rc_cur_id
WHERE rc_new = 1;

SELECT *
FROM recentchanges
WHERE rc_cur_id NOT IN
(
  SELECT pp_page
  FROM page_props
  WHERE pp_page IN 
      (
        SELECT rc_cur_id
        FROM recentchanges
        WHERE rc_new = 1 AND rc_namespace = 0
      )
)
WHERE rc_new = 1 AND rc_namespace = 0
limit 1000;


SELECT COUNT(*)
FROM page_props
WHERE pp_page IN 
	(
      SELECT rc_cur_id
      FROM recentchanges
      WHERE rc_new = 1 AND rc_namespace = 0
	)
;

SELECT COUNT(*)
FROM recentchanges
WHERE rc_new = 1 AND rc_namespace = 0;

SQL

Checking query status...