ToFawiki Templates without interwiki

SQL

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 and page_title not like '%/%' and page_namespace = 10 and page_is_redirect = 0
left join langlinks on ll_from = page_id
join comment on comment_id = rev_comment_id and comment_text like "%به ویکی‌فا%" 
where ll_from is null
-- limit 10

AخA
 
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 enfrom pagejoin revision on page_id = rev_page and page_title not like '%/%' and page_namespace = 10 and page_is_redirect = 0left join langlinks on ll_from = page_idjoin comment on comment_id = rev_comment_id and comment_text like "%به ویکی•فا%" where ll_from is null-- limit 10

SQL

Checking query status...