Use enwiki_p;

Select page_namespace, page_title, rd_title from page inner join redirect on page_id = rd_from

Where rd_namespace = 10 and page_namespace = 10

And page_title not regexp "/doc|/sandbox|/testcases|/demo"

And rd_title like "%-stub"

and page_title not like "%stub%" and page_title not like "%Stub%";