Last modified: 2014-01-03 16:07:21 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-167. Summary: query from short pages Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: reza <reza.energy@gmail.com> Date: Thu, 10 Nov 2011 17:35:41 ------------------------------------------------------------------------------- Hi, I want a list of 1000 short pages that they are not disambiguation or redirect in fa.wiki thank you
------------------------------------------------------------------------------- From: reza <reza.energy@gmail.com> Date: Thu, 10 Nov 2011 17:38:55 ------------------------------------------------------------------------------- in fa.wiki we use {{ابهامزدایی}} for disambiguation pages or in percentage characters %7B%7B%D8%A7%D8%A8%D9%87%D8%A7%D9%85%E2%80%8C%D8%B2%D8%AF%D8%A7%DB%8C%DB%8C%7D%7D
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Fri, 11 Nov 2011 14:43:15 ------------------------------------------------------------------------------- Here are the 1000 shortest articles on fa.wiki not including the given template and not being redirects. SQL: SELECT page_title FROM page WHERE page_namespace = 0 AND page_is_redirect = 0 AND page_id NOT IN (SELECT tl_from FROM templatelinks WHERE tl_title = 'ابهامزدایی' AND tl_namespace = 10) ORDER BY page_len ASC LIMIT 1000; Result: http://toolserver.org/~hoo/dbq/dbq-167.txt
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, hoo@online.de