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

SQL

x
 
USE fawiki_p;
# child and parent category in an article
SELECT page_title title, chld.cl_to child_category, prnt.cl_to parent_category
FROM categorylinks AS chld JOIN page ON chld.cl_from = page_id AND page_namespace = 14 AND page_is_redirect = 0
JOIN categorylinks AS prnt ON prnt.cl_from = page_id
# none is hidden
WHERE NOT EXISTS (
  SELECT NULL
  FROM page JOIN page_props ON page_id = pp_page
  WHERE page_namespace = 14
  AND page_is_redirect = 0
  AND (
    page_title = chld.cl_to
    OR page_title = prnt.cl_to
  )
  AND pp_propname = 'hiddencat'
)
# prnt is parent of chld
AND prnt.cl_to IN (
  SELECT cl_to
  FROM categorylinks JOIN page ON cl_from = page_id
  WHERE page_title = chld.cl_to
  AND page_namespace = 14
  AND page_is_redirect = 0
)
LIMIT 5;
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.

Checking query status...