use fawiki_p;

select distinct concat("الگو:", page_title) as Title,SUBSTRING(REGEXP_SUBSTR (comment_text,"(=(.*?)&)"), 2, LENGTH (REGEXP_SUBSTR (comment_text,"(=(.*?)&)"))-2) as Target_link, ll_title as en

from page

join revision on page_id = rev_page 

left join langlinks on ll_from = page_id

join comment on comment_id = rev_comment_id 

where ll_from is null

and page_namespace = 10 and page_is_redirect = 0

and page_title not like '%/%' 

and comment_text like "%به ویکی•فا%" 

-- limit 10