SQL
AخA
USE fawiki_p;
SELECT DISTINCT REPLACE(noyr.page_title,'_',' ')# , REPLACE(yr.page_title,'_',' '), MID(noyr.page_title,1,LOCATE('فیلم',noyr.page_title)-3), MID(yr.page_title,1,LOCATE('فیلم',yr.page_title)-3)
FROM page AS yr JOIN page AS noyr 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
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 LIKE "%۱%"
OR yr.page_title LIKE "%۲%"
)
AND yr.page_title <> noyr.page_title
ORDER BY noyr.page_title;
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.