SQL
AخA
USE fawiki_p;
SELECT COUNT(pl_title)
FROM pagelinks
LEFT JOIN page ON pl_namespace = page_namespace AND pl_title = page_title
LEFT JOIN redirect ON page_id = rd_from
WHERE page_is_redirect = 1
AND page_namespace = 0
AND rd_namespace = 0
AND pl_from IN (
SELECT page_id
FROM page
WHERE page_is_redirect=0
AND (
pl_from_namespace=0 # مقاله
OR pl_from_namespace=100 # درگاه
OR pl_from_namespace=14 # رده
# OR pl_from_namespace=828 # پودمان
OR (
pl_from_namespace=2 # کاربر
AND page_title LIKE "%جعبه_کاربر%"
)
OR (
pl_from_namespace=4 # ویکی•پدیا
AND (
page_title LIKE "%یادبودهای_برگزیده%"
OR page_title LIKE "%انتخاب_نگاره%"
OR page_title LIKE "%نوشتار_پیشنهادی_هفته%"
OR page_title LIKE "%آیا_می•دانستید_که%"
OR page_title LIKE "%گزیدن_نگاره_برگزیده%"
)
)
)
)
AND EXISTS (
SELECT null
FROM page
WHERE pl_from = page_id
AND page_is_redirect=0
)
AND EXISTS (
SELECT null
FROM page
WHERE page_title = rd_title
AND EXISTS (
SELECT null
FROM page_props
WHERE page_id = pp_page AND pp_propname = 'disambiguation'
)
);
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.