Redlinks in articles created by a specific user

SQL

set @username := "Mathieu Mars";

select
	distinct pl_title
from pagelinks
	left join page as page_missing on
		page_missing.page_title = pl_title and
		page_missing.page_namespace = pl_namespace
    inner join page as page_backlink on page_backlink.page_id = pl_from
	inner join revision on rev_page = page_backlink.page_id
	inner join actor on actor_id = rev_actor
	left join page_props on
		pp_page = page_backlink.page_id and
		pp_propname = "disambiguation"
where
	page_missing.page_id is null and
	pp_page is null and
	actor_name = @username and
	pl_namespace = 0 and
	pl_from_namespace = 0 and
	rev_parent_id  = 0 # page creation

SQL

Checking query status...