Fork of subcategories and pages under Johann_Sebastian_Bach cat in enwiki by RaymondYee
This query is marked as a draft This query has been published by Mr. Ibrahem.

SQL

AخA
 
USE arwiki_p;
SELECT 
    cl_from, cl_to, cl_timestamp, cl_type, p1.page_title as from_title, p2.page_id as to_page_id
FROM
    categorylinks cl  JOIN page p1  JOIN page p2
ON
    cl.cl_from = p1.page_id AND cl.cl_to = p2.page_title
WHERE
    p2.page_title = "صفحات_بها_بيانات_ويكي_بيانات" AND p2.page_namespace = 14
    limit 100;
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...