From: Hoo man <hoo@online.de>

Date: Mon, 05 Dec 2011 15:50:41

The table 'cur' has only been used on WMF wikis till mid-2005, so I presume you wont find much useful data their.

From: reza <reza.energy@gmail.com>

Date: Mon, 05 Dec 2011 16:44:40

thank you for your answer
how can I have query that show me pages that they have wikipedia url but they dont have any interwiki?

From: Hoo man <hoo@online.de>

Date: Mon, 05 Dec 2011 16:48:43

You mean pages that have a wikipedia URL in their text? No way from the TS SQL servers, you can only work with the database dumps here.

From: Dispenser <dispenser@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;

From: reza <reza.energy@gmail.com>

Date: Tue, 06 Dec 2011 11:33:24

Thank you

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: hoo@online.de
CC list: reza.energy@gmail.com, dispenser@toolserver.org, hoo@online.de