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 *
        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 cp.page_title = "Wikipedia_sockpuppets_of_대우건설"
        and  cl.cl_to = in (
        	SELECT REPLACE(cp.page_title, 'Wikipedia_sockpuppets_of_','') as master
            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 cp.page_title like "Wikipedia_sockpuppets_of_%"
            and  cl.cl_to = "Wikipedia_sockpuppets"
        )

ORDER BY cp.page_title DESC
LIMIT 10;
SQL

Checking query status...
