DBQ-167 query from short pages
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 4:07 PM

Description

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

Version: unspecified
Severity: major

Details

Reference: bz59435

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:30 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59435.

JiraBugConverter created this task.Jan 3 2014, 4:07 PM

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

DBQ-167 query from short pagesClosed, ResolvedPublicActions