Last modified: 2014-01-03 15:57:00 UTC
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
------------------------------------------------------------------------------- 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