Fork of
Untitled query #44720
by Huji
This query is marked as a draft
This query has been published
by Yamaha5.
SQL
x
use fawiki_p;
select distinct concat("الگو:", page_title) as Title, comment_text as Summary, ll_lang as en
from page
join langlinks on page_id = ll_from
-- and ll_lang = 'en'
join revision on page_id = rev_page -- and rev_timestamp between 20190501000000 and 20190601000000
join comment on comment_id = rev_comment_id and comment_text like "%به ویکی•فا%"
where
page_namespace = 10
and page_is_redirect = 0
-- and ll_title is null
group by page_title
having ll_lang<>'en'
limit 10
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.