SQL
AخA
use enwiki_p;
select concat("الگو:", ll_title, "/meta/shortname") as Title, concat(ll_title, " برای_جایگزینی") as Content
from langlinks
join page
on ll_from = page_id
where ll_lang = "fa"
and page_title in
(
select replace(page_title, "/meta/shortname", "")
from page
where page_namespace = 10 -- Template
and page_title like "%/meta/shortname"
and page_is_redirect = 0
);
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.