Page MenuHomePhabricator

DBQ-113 List of articles in a category sorting by creation time
Closed, ResolvedPublic

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-113.
Summary: List of articles in a category sorting by creation time
Issue type: Task - A task that needs to be done.
Priority: Blocker
Status: Done
Assignee: Autocracy <jeff@storyinmemo.com>


From: Mjbmr <mjbmri@gmail.com>

Date: Fri, 24 Dec 2010 08:41:12

I want to get a list on articles on an special category sorting by creation time, it is very important, thanks


Version: unspecified
Severity: blocker

Details

Reference
bz59364

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:25 AM
bzimport set Reference to bz59364.

From: Hoo man <hoo@online.de>

Date: Sun, 26 Dec 2010 23:49:44

I'm sorry but I can't help you without knowing which wiki and category you want to have this query performed on, please add these informations.


From: Mjbmr <mjbmri@gmail.com>

Date: Mon, 27 Dec 2010 09:43:30

I want to get a list of articles on منتشرشده category on fawikinews


From: Autocracy <jeff@storyinmemo.com>

Date: Mon, 27 Dec 2010 12:35:05

"select page_namespace, page_title, min(rev_timestamp)
from categorylinks
join revision on cl_from = rev_page
join page on cl_from = page_id
where cl_to = 'منتشرشده'
group by page_id
order by min(rev_timestamp)"

Results at http://toolserver.org/~autocracy/dbq-113

The results might be a little confusing to read because the headers are left-to-right, but the columns are right-to-left. You can thank the mixture of languages and inherent direction of them for that.


From: Mjbmr <mjbmri@gmail.com>

Date: Mon, 27 Dec 2010 14:36:21

Thank you so much


From: Mjbmr <mjbmri@gmail.com>

Date: Thu, 06 Jan 2011 16:28:57

Is it possible to get list of category and articles both that they are exist in منتشرشده category and ایران category?


From: Hoo man <hoo@online.de>

Date: Thu, 06 Jan 2011 17:40:53

SQL:

SELECT page.page_title as page FROM categorylinks INNER JOIN categorylinks as catlinks ON categorylinks.cl_from = catlinks.cl_from INNER JOIN page ON categorylinks.cl_from = page.page_id WHERE categorylinks.cl_to = 'منتشرشده' AND catlinks.cl_to = 'ایران';

Results:
http://toolserver.org/~hoo/dbq/dbq-113.txt (plain text)
http://toolserver.org/~hoo/dbq/dbq-113_wiki.txt (wiki table)


From: AVRS <deletesoftware@yandex.ru>

Date: Fri, 28 Jan 2011 13:43:34

Yesterday I've added http://eo.wikinews.org/wiki/Pro_gravegaj_sekurkorektoj_eldonitas_Bugzilla_4.0rc2,_3.6.4,_3.4.10_kaj_3.2.10 to the category "Publikigitaj artikoloj" using the template "Publikigita". Then I renamed the article. It never appeared in http://toolserver.org/~mjbmr/rss/rss.php?title=Vikinova%C4%B5oj&lang=eo&family=wikinews&cat=Publikigitaj+artikoloj&lim=10&ns=0 .

The query (as cited by Mjbmr):

<@Mjbmr> select page_namespace, page_title, min(rev_timestamp) from categorylinks join revision on
cl_from = rev_page join page on cl_from = page_id where (page_namespace = 0 ) AND cl_to =
'Publikigitaj_artikoloj' group by page_id order by min(rev_timestamp) DESC Limit 10;

Raw output (given by Mjbmr):

page_namespace page_title min(rev_timestamp)
0 Ekfunkciis_rusinlingva_Vikipedio 20110126155019
0 Estas_elŝutebla_Fajrovulpo_v.4.0b10 20110126132457
0 Terora_ago_en_la_flughaveno_Domodedovo_(Moskvo,_Rusio) 20110125162733
0 Google_forigos_malkodilon_de_H.264_el_sia_TTT-legilo_Chrome 20110112102159
0 Vikinovaĵaj_mallongaĵoj,_2010-12-24 20101224215457
0 Eldonistoj_oponas_la_proponatajn_ŝanĝojn_de_Rusia_aŭtorrajta_leĝo 20101224191804
0 Eldonitas_Poŝfajrovulpo_4.0b3 20101224123628
0 Firefox_4.0b8,_kun_plibonigoj_je_Sync_kaj_WebGL,_kaj_la_nova_menuo_ĉe_GNUo-Linukso 20101223204901
0 Firefox_Input_2.1,_kun_aparta_paĝo_por_sendi_proponojn 20101222130557
0 UN_eliminas_sankciojn_al_Irako 20101216114937

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: bugzilla@storyinmemo.com
CC list: deletesoftware@yandex.ru, hoo@online.de, mjbmri@gmail.com, bugzilla@storyinmemo.com