Fork of page categories not hidden by Alexander Misel
This query is marked as a draft This query has been published by Xiplus.

SQL

AخA
 
SELECT cl_to, pp_propname
FROM page
LEFT JOIN categorylinks ON page_id = cl_from
LEFT JOIN page AS cpage ON cl_to = cpage.page_title AND cpage.page_namespace = 14
LEFT JOIN page_props ON cpage.page_id = pp_page AND pp_propname = 'hiddencat'
WHERE page.page_title = 'SPY×FAMILY間諜家家酒'
    AND page.page_namespace = 0
    AND pp_propname IS NULL
/*SELECT cl_to, pp_propname
FROM categorylinks
LEFT JOIN page ON cl_to = page_title AND page_namespace = 14
LEFT JOIN page_props ON page_id = pp_page AND pp_propname = 'hiddencat'
WHERE cl_from = (
  SELECT page_id FROM page WHERE page_title = 'SPY×FAMILY間諜家家酒' AND page_namespace = 0 AND page_is_redirect = 0
)
AND pp_propname IS NULL*/
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...