SQL
AخA
SELECT page_title
FROM page
JOIN categorylinks AS hc ON hc.cl_from = page_id AND hc.cl_to = 'Hidden_categories'
JOIN categorylinks AS tc ON tc.cl_from = page_id AND tc.cl_to = 'Tracking_categories'
LEFT JOIN categorylinks AS oc ON oc.cl_from = page_id AND oc.cl_to NOT IN ('Hidden_categories', 'Tracking_categories')
WHERE page_namespace = 14
AND oc.cl_to 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.
All SQL code is licensed under CC0 License.