SQL
AخA
USE fawiki_p;
SELECT t.page_title, t.page_len
FROM page AS t
WHERE t.page_namespace = 1
AND t.page_is_redirect = 0
AND t.page_len > 0
AND EXISTS (
SELECT null
FROM page AS p
WHERE p.page_namespace = 0
AND p.page_title = t.page_title
AND p.page_is_redirect = 1
)
AND t.page_id NOT IN (
SELECT cl_from
FROM categorylinks
WHERE cl_to = 'صفحه•های_دارای_جعبه_بحث•شده_در_جای_دیگر'
)
ORDER BY t.page_len DESC;
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.