SQL
AخA
USE fawiki_p;
SELECT REPLACE(noyr.page_title,'_',' ') #, REPLACE(yr.page_title,'_',' ')
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) JOIN categorylinks ON cl_from = noyr.page_ID
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
AND (
(cl_to LIKE "فیلم•های%(میلادی)"
AND length(cl_to) = 41)
OR
(cl_to LIKE "فیلم•های%۱%"
AND length(cl_to) = 26)
)
GROUP BY cl_to
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.