This query is marked as a draft This query has been published by Mahir256.

SQL

AخA
 
SELECT DISTINCT pl_title#, COUNT(*)
FROM pagelinks
LEFT JOIN page ON 
    pl_title = page_title 
    AND pl_namespace = page_namespace
WHERE
    pl_from_namespace IN (0, 120, 146)
    AND pl_namespace IN (0, 120, 146)
    AND pl_title in ("Q117280363","Q117280362","Q117280355","Q117280345","Q117280342","Q117280334","Q117280326","Q117280316","Q117280315","Q117280294","Q117280293","Q117280291","Q117280286","Q117280278","Q117280255","Q117280238","Q117280020","Q117279923","Q117279873","Q117279841","Q117279792","Q117279786","Q117279773","Q117279743","Q117279712","Q117276734","Q117276713","Q117276676","Q117276663","Q117276604","Q117276579","Q117276504","Q117276430","Q117276369","Q117276361","Q117276355","Q117276341","Q117276338","Q117276316","Q117276275","Q117276243","Q117276205","Q117276192","Q117276130","Q117276050","Q117275962","Q117269942","Q117269919","Q117269907","Q117269896","Q117269865","Q117269849","Q117269839","Q117269819","Q117269811","Q117269810","Q117269786","Q117269747","Q117269701","Q117269683","Q117269618","Q117269617","Q117269526","Q117269509","Q117269484","Q117269447","Q117269411","Q117269409","Q117269347","Q117269330","Q117269305","Q117269275","Q117269264","Q117269260","Q117269258","Q117269235","Q117269234","Q117269230","Q117269210","Q117269193","Q117269183","Q117269175","Q117269162","Q117269150","Q117269142","Q117269141","Q117269126","Q117269119","Q117269106","Q117269101","Q117269077","Q117269073","Q117269061","Q117268995","Q117268798","Q117268684","Q117268617","Q117268577","Q117268490","Q117268451","Q117266682","Q117266005","Q117265963","Q117265623","Q117265532","Q117265427","Q117265285","Q117265216","Q117265084","Q117264966","Q117264902","Q117264783","Q117264758")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q117280363","Q117280362","Q117280355","Q117280345","Q117280342","Q117280334","Q117280326","Q117280316","Q117280315","Q117280294","Q117280293","Q117280291","Q117280286","Q117280278","Q117280255","Q117280238","Q117280020","Q117279923","Q117279873","Q117279841","Q117279792","Q117279786","Q117279773","Q117279743","Q117279712","Q117276734","Q117276713","Q117276676","Q117276663","Q117276604","Q117276579","Q117276504","Q117276430","Q117276369","Q117276361","Q117276355","Q117276341","Q117276338","Q117276316","Q117276275","Q117276243","Q117276205","Q117276192","Q117276130","Q117276050","Q117275962","Q117269942","Q117269919","Q117269907","Q117269896","Q117269865","Q117269849","Q117269839","Q117269819","Q117269811","Q117269810","Q117269786","Q117269747","Q117269701","Q117269683","Q117269618","Q117269617","Q117269526","Q117269509","Q117269484","Q117269447","Q117269411","Q117269409","Q117269347","Q117269330","Q117269305","Q117269275","Q117269264","Q117269260","Q117269258","Q117269235","Q117269234","Q117269230","Q117269210","Q117269193","Q117269183","Q117269175","Q117269162","Q117269150","Q117269142","Q117269141","Q117269126","Q117269119","Q117269106","Q117269101","Q117269077","Q117269073","Q117269061","Q117268995","Q117268798","Q117268684","Q117268617","Q117268577","Q117268490","Q117268451","Q117266682","Q117266005","Q117265963","Q117265623","Q117265532","Q117265427","Q117265285","Q117265216","Q117265084","Q117264966","Q117264902","Q117264783","Q117264758")
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...