[Bug 59439] DBQ-170 problem with getting query
https://bugzilla.wikimedia.org/show_bug.cgi?id=59439 --- 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 "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
[Bug 59439] DBQ-170 problem with getting query
https://bugzilla.wikimedia.org/show_bug.cgi?id=59439 Bugzilla Bug Importer (valhallasw) changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #6 from Bugzilla Bug Importer (valhallasw) --- 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: h...@online.de CC list: reza.ene...@gmail.com, dispen...@toolserver.org, h...@online.de -- 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
[Bug 59439] DBQ-170 problem with getting query
https://bugzilla.wikimedia.org/show_bug.cgi?id=59439 --- Comment #5 from Bugzilla Bug Importer (valhallasw) --- --- From: reza Date: Tue, 06 Dec 2011 11:33:24 --- Thank you -- 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
[Bug 59439] DBQ-170 problem with getting query
https://bugzilla.wikimedia.org/show_bug.cgi?id=59439 --- Comment #3 from Bugzilla Bug Importer (valhallasw) --- --- From: Hoo man 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. -- 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
[Bug 59439] DBQ-170 problem with getting query
https://bugzilla.wikimedia.org/show_bug.cgi?id=59439 --- Comment #2 from Bugzilla Bug Importer (valhallasw) --- --- From: reza 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? -- 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
[Bug 59439] DBQ-170 problem with getting query
https://bugzilla.wikimedia.org/show_bug.cgi?id=59439 --- Comment #1 from Bugzilla Bug Importer (valhallasw) --- --- From: Hoo man 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. -- 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