USE trwiktionary_p;

​

-- Resultset 1: wikisource

​

SELECT

    page_title AS wikt_page_title,

    iwl_title AS s_page_title

FROM

    iwlinks INNER JOIN page ON iwl_from = page_id

WHERE

    page_namespace = 0 AND

    iwl_prefix = "s" AND

    #iwl_title != "" AND

    NOT EXISTS (

        SELECT NULL

        FROM plwikisource_p.page AS s_page

        WHERE s_page.page_title = iwl_title

    )

;

​

-- Resultset 2: wikiquote

/*

SELECT

    page_title AS wikt_page_title,

    iwl_title AS q_page_title

FROM

    iwlinks INNER JOIN page ON iwl_from = page_id

WHERE

    page_namespace = 0 AND

    iwl_prefix = "q" AND

    #iwl_title != "" AND

    NOT EXISTS (

        SELECT *

        FROM plwikiquote_p.page AS q_page

        WHERE q_page.page_title = iwl_title

    )

LIMIT 10;

​

-- Resultset 3: wikipedia

​

SELECT

    page_title AS wikt_page_title,

    iwl_title AS wp_page_title

FROM

    iwlinks INNER JOIN page ON iwl_from = page_id

WHERE

    page_namespace = 0 AND

    iwl_prefix = "w" AND

    #iwl_title != "" AND

    NOT EXISTS (

        SELECT NULL

        FROM plwiki_p.page AS wp_page

        WHERE wp_page.page_title = iwl_title

    )

LIMIT 10;*/