Topic on Talk:Quarry

Hi I Want a Code For SQL that What Links Here For Redirects With More Than 10 Links And The Title With English Letters how can I do that, thanks.

@Сэм аласыз:

SELECT 
	CONCAT('*[[',p.page_title,']]') as "title",
	COUNT(pl.pl_from) as WLH,
	CONCAT('[[Special:Whatlinkshere/{{ns:',p.page_namespace,'}}:',p.page_title,']]') as "Whatlinkshere link"
FROM page p
INNER JOIN pagelinks pl ON p.page_title = pl.pl_title AND p.page_namespace = pl.pl_namespace
INNER JOIN page p2 ON p2.page_id = pl.pl_from and p2.page_is_redirect=1
where p.page_namespace = 0# only articles ?
and p.page_title REGEXP '[A-Za-z]'
GROUP BY p.page_title
HAVING WLH > 10
ORDER BY WLH DESC