Main space page links to user space

SQL

SELECT p.page_title, pl.pl_namespace, pl.pl_title
FROM page p
INNER JOIN pagelinks pl ON p.page_id = pl.pl_from AND pl.pl_namespace = 2
WHERE p.page_namespace = 0
AND pl.pl_title != 'Citation_bot'
AND p.page_id NOT IN (SELECT tl.tl_from FROM templatelinks tl WHERE tl.tl_target_id IN (236264, 17233, 99384, 2139, 13870, 881, 658, 8718, 8187, 2308))
AND p.page_id NOT IN (SELECT cl.cl_from FROM categorylinks cl WHERE cl.cl_to IN 
	('Candidates_for_speedy_deletion', 'Wikipedia_people', 'Wikimedia_Foundation_staff_members', 'American_Wikimedians', 'British_Wikimedians', 'Canadian_Wikimedians', 'French_Wikimedians', 
	'German_Wikimedians', 'Ghanaian_Wikimedians', 'Indian_Wikimedians', 'New_Zealand_Wikimedians', 'Polish_Wikimedians', 'Russian_Wikimedians', 'Ukrainian_Wikimedians', 'History_of_Wikipedia',
	'Wikipedia_controversies'))
AND p.page_is_redirect = 0
AND p.page_title NOT IN ('Main_Page', 'The_Signpost', 'Dirty_Politics')
AND p.page_title NOT LIKE '%Wiki%'
SQL

Checking query status...
