IWs and QIDs for a list of page titles

SQL

USE rowiki_p;
SELECT page_title, pp_value, ll_title
	FROM page
	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 and 
page_title in (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
SQL

Checking query status...
