--- Comment #4 from Bugzilla Bug Importer (valhallasw) 
<> ---
From: Dispenser <>
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 "";
    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

Reply via email to