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(replace(cl.cl_to, 'Wikipedia_sockpuppets_of_',''), '_', ' ') as master, 
		replace(cp.page_title, '_', ' ') as sock
        /**/
        
        FROM 

        # get  page
        enwiki_p.page cp
        # get  category
        INNER JOIN enwiki_p.categorylinks  cl
        ON cp.page_id = cl.cl_from

        #WHERE cp.page_title = "Wikipedia_sockpuppets_of_대우건설"
        WHERE  cl.cl_to in (
        	SELECT cp.page_title as master
            FROM 

            # get  page
            enwiki_p.page cp
            # get  category
            INNER JOIN enwiki_p.categorylinks  cl
            ON cp.page_id = cl.cl_from

            WHERE cp.page_title like "Wikipedia_sockpuppets_of_%"
          	#WHERE cp.page_title = "Wikipedia_sockpuppets_of_대우건설"
          	
            and  cl.cl_to = "Wikipedia_sockpuppets"
          	
        )
        # only user pages
        and cp.page_namespace = 2

ORDER BY cl.cl_to DESC
LIMIT 5000;
SQL

Checking query status...
