SQL
x
USE fawiki_p;
SELECT REPLACE(noyr.page_title,'_',' ')
FROM page AS noyr JOIN page AS yr ON MID(noyr.page_title,1,LOCATE('فیلم',noyr.page_title)-3) = MID(yr.page_title,1,LOCATE('فیلم',yr.page_title)-3)
WHERE noyr.page_namespace = 0
WHERE noyr.page_namespace = 0
AND noyr.page_is_redirect = 0
AND noyr.page_title LIKE "%(فیلم)"
AND yr.page_namespace = 0
AND yr.page_is_redirect = 0
AND yr.page_title LIKE "%(فیلم%"
AND yr.page_title <> noyr.page_title
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.