IWs and QIDs for a list of page titles

SQL

/*USE rowiki_p;
SELECT page_title, pp_value, ll_title, tw2.CI
	FROM page 
join (SELECT SUBSTRING_INDEX(pl1.pl_title, '/', -1) as sbs, b.CountField as CI
FROM test2wiki_p.pagelinks pl1
    right JOIN (SELECT pl2.pl_title, COUNT(*) AS CountField FROM test2wiki_p.pagelinks pl2 where pl2.pl_from = 57964 GROUP BY pl2.pl_title) b
        ON pl1.pl_title=b.pl_title) tw2
        on page_title =tw2.sbs
	LEFT JOIN langlinks
    	ON ll_from = page_id
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = page_id
WHERE
ll_lang="uk" AND
page_namespace = 0 and page_is_redirect = 0*/
USE rowiki_p;
SELECT page_title, pp_value, ll_title
	FROM page
	LEFT JOIN langlinks
    	ON ll_from = page_id and ll_lang="uk"
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = page_id
WHERE
# AND
page_namespace = 0 and page_is_redirect = 0 and
page_title in (SELECT pl1.pl_title FROM test2wiki_p.pagelinks pl1
               where pl1.pl_from = 33258)
               /**/
/*
(SELECT pl1.pl_title FROM test2wiki_p.pagelinks pl1
    INNER JOIN (SELECT pl_title, COUNT(*) AS CountField FROM test2wiki_p.pagelinks pl2 GROUP BY pl2.pl_title) b
        ON pl1.pl_title=b.pl_title
               where pl1.pl_from = 57964)*/
               
#ORDER BY page_title;
/*
USE wikidatawiki_p;
SELECT * FROM wb_items_per_site WHERE ips_site_id='rowiki' AND ips_site_page 
IN (SELECT REPLACE(pl1.pl_title, '_', ' ') FROM test2wiki_p.pagelinks pl1 where pl1.pl_from = 57964)
*/
#SELECT pl1.pl_title FROM test2wiki_p.pagelinks pl1 where pl1.pl_from = 57964
/*
SELECT SUBSTRING_INDEX(pl1.pl_title, '/', -1), b.CountField 
FROM test2wiki_p.pagelinks pl1
    right JOIN (SELECT pl2.pl_title, COUNT(*) AS CountField FROM test2wiki_p.pagelinks pl2 where pl2.pl_from = 57964 GROUP BY pl2.pl_title) b
        ON pl1.pl_title=b.pl_title
        */
SQL

Checking query status...
