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 REPLACE(cp.page_title, 'Wikipedia_sockpuppets_of_','') as sock
    
FROM 
    
    # get commons page
    enwiki_p.page cp
    # get commons category
    INNER JOIN enwiki_p.categorylinks  cl
    	ON cp.page_id = cl.cl_from
    
    WHERE 
    	# filter by user
    	cl.cl_to = "Wikipedia_sockpuppets"
        and  cp.page_title like "Wikipedia_sockpuppets_of_%"
    ORDER BY cp.page_title DESC
    LIMIT 1000;
SQL

Checking query status...
