Untitled query #79232

SQL

USE wikidatawiki_p;

SELECT
    enwiki.page_title AS enwiki_title,
    kuwiki.page_title AS kuwiki_title
FROM
    wb_items_per_site AS enwiki
    JOIN categorylinks ON enwiki.page_title = categorylinks.cl_to
    JOIN wb_items_per_site AS kuwiki ON kuwiki.page_title = categorylinks.cl_to
    JOIN wb_items_per_site AS enwiki_item ON enwiki.page_title = enwiki_item.page_title AND enwiki_item.site = 'enwiki'
    JOIN wb_items_per_site AS kuwiki_item ON kuwiki.page_title = kuwiki_item.page_title AND kuwiki_item.site = 'kuwiki'
WHERE
    categorylinks.cl_to = 'Top-importance_France_articles'
    AND enwiki.site = 'enwiki'
    AND kuwiki.site = 'kuwiki';
SQL

Checking query status...
