categories of pagelinks from some specific page

SQL

USE cebwiki_p;
SELECT cl_to, COUNT(page_title), GROUP_CONCAT(page_title) AS pages
from page
join pagelinks on pl_title = page_title AND page_namespace = 0 and page_is_redirect = 0
join categorylinks on cl_from=page_id 
WHERE pl_from = 8493865#8037437
group BY cl_to
having COUNT(page_title) > 10;

USE svwiki_p;
SELECT cl_to, GROUP_CONCAT(page_title) AS pages, COUNT(page_title)
from page
join pagelinks on pl_title = page_title AND page_namespace = 0 and page_is_redirect = 0
join categorylinks on cl_from=page_id 
WHERE pl_from = 8037437
group BY cl_to
having COUNT(page_title) > 10;
/*Format: page | cats
USE cebwiki_p;
SELECT page_title, GROUP_CONCAT(cl_to) AS cats#cl_to, COUNT(page_title)
from page
join pagelinks on pl_title = page_title AND page_namespace = 0 and page_is_redirect = 0
join categorylinks on cl_from=page_id 
WHERE pl_from = 8493873
group BY page_title
*/
SQL

Checking query status...
