SQL
AخA
USE fawiki_p;
SELECT DISTINCT CONCAT ('# [[',page_title,']]'),COUNT(pl_from)
FROM pagelinks JOIN page ON pl_title=page_title
WHERE page_is_redirect=0
AND page_title LIKE "آمریکایی"
AND page_namespace=0
AND page_title NOT LIKE "%(ابهام•زدایی)%"
AND page_id IN (
SELECT pp_page
FROM page_props
WHERE pp_propname = 'disambiguation'
)
AND pl_from IN (
SELECT page_id
FROM page
WHERE page_is_redirect=0
AND (pl_from_namespace=4
AND page_title LIKE "%یادبودهای_برگزیده%"
)
)
AND pl_namespace=0
#AND (
# pl_from_namespace=0
# OR pl_from_namespace=100
# OR pl_from_namespace=828
# (
# pl_from_namespace=0
# AND page_title LIKE "%یادبودهای برگزیده%"
# )
# )
GROUP BY pl_title
ORDER BY COUNT(pl_from) 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.