https://bugzilla.wikimedia.org/show_bug.cgi?id=59439

--- Comment #4 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Dispenser <dispen...@toolserver.org>
Date: Tue, 06 Dec 2011 06:49:43
-------------------------------------------------------------------------------

You could try...

    SELECT page_title, el_to
    FROM page
    JOIN externallinks ON  el_from=page_id
    /* Plain text interwiki links */
    LEFT JOIN iwlinks  ON iwl_from=page_id AND iwl_prefix="w" /* AND iwl_title
LIKE "en:%" [[w:]] defaults to ENWP */
    /* Language links (from sidebar) */
    LEFT JOIN langlinks ON ll_from=page_id AND ll_lang="en"
    WHERE page_namespace=0
    AND el_to LIKE "http://en.wikipedia.org/wiki/_%";
    AND iwl_from IS NULL
    AND ll_from IS NULL 
    LIMIT 20;

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to