use fawiki_p;

select concat("الگو:", page_title) as Title, comment_text as Summary, ll_title as en

from page

join revision on page_id = rev_page and rev_timestamp between 20190501000000 and 20190601000000

join langlinks l1 on l1.ll_from = page_id

join comment on comment_id = rev_comment_id and comment_text like "%به ویکی•فا%"

left join (SELECT distinct ll.ll_from FROM langlinks  ll) as T on T.ll_from=l1.ll_from

where page_namespace = 10

and T.ll_from is null

-- and ll_from NOT IN ;