Untitled query #72448

This query is marked as a draft This query has been published by لوقا.

SQL

/*
SELECT main_page.page_title, cl.cl_to, COUNT(cl.cl_to) AS num_duplicates
FROM categorylinks cl
JOIN page AS main_page ON cl.cl_from = main_page.page_id
WHERE main_page.page_namespace = 0
GROUP BY main_page.page_id, cl.cl_to
HAVING COUNT(cl.cl_to) > 1
limit 10
*/

select *
FROM categorylinks
where cl_from = 9151584;


select *
FROM pagelinks
where pl_from = 9151584;

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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...