Fr.wikiquote sysop

SQL

/*
SET @project = "frwikiquote_p.user";

set @qry1:= concat('select user_id, user_name, ug_group from ', @project,
                   ' JOIN user_groups on ug_user = user_id and ug_group = "sysop"',
                  ' limit 10');
prepare stmt from @qry1 ;
execute stmt ;
*/

SELECT DISTINCT a.actor_name AS User, 
		cl.cl_to AS Category
    
FROM 
    
    # get commons page
    enwiki_p.page cp
    # get commons category
    INNER JOIN enwiki_p.categorylinks  cl
    	ON cp.page_id = cl.cl_from
    
    # get author details
    INNER JOIN enwiki.actor a 
    	ON a.actor_id = cp.page_actor
    
    WHERE 
    	# filter by user
    	cl.cl_from = "Wikipedia sockpuppets"
        
    GROUP BY Category
    LIMIT 30;
SQL

Checking query status...
