Last modified: 2014-01-03 15:33:47 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-22. Summary: More requested pages of Lithuanian wiktionary Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Legoktm <legoktm@pacbell.net> ------------------------------------------------------------------------------- From: Vpovilaitis <Vpovilaitis@gmail.com> Date: Thu, 08 May 2008 13:57:02 ------------------------------------------------------------------------------- Would it be possible to periodicaly (7 d) get a list of more requested pages of Lithuanian wiktionary. This result list must by saved as: http://lt.wiktionary.org/wiki/S%C4%85ra%C5%A1as:Geid%C5%BEiamiausi_puslapiai/Auto This job I made befoe manualy from download files. Result of my manual work is in file: http://lt.wiktionary.org/wiki/S%C4%85ra%C5%A1as:Geid%C5%BEiamiausi_puslapiai For this job was used SQL select: * * * Select curdate() as `` from dual union (select concat(_utf8'* [[',replace(`a`.`pl_title`,_utf8'_',_utf8' '),_utf8']] (',`a`.`kiekis`,_utf8') ([[:Specialus:Whatlinkshere/',replace(`a`.`pl_title`,_utf8'_',_utf8' '),_utf8'|? nuorodos]])') AS `` from (select `p`.`pl_title` AS `pl_title`,count(1) AS `kiekis` from `pagelinks` `p` where ((not(exists(select 1 AS `1` from `page` `pg` where ((`p`.`pl_namespace` = `pg`.`page_namespace`) and (`p`.`pl_title` = `pg`.`page_title`))))) and (`p`.`pl_namespace` = 0)) group by `p`.`pl_namespace`,`p`.`pl_title`) `a` where (`a`.`kiekis` > 10) order by `a`.`kiekis` desc); * * * Original Estimate of work of this job is estimation of work of my select. Best regards, (http://lt.wiktionary.org/wiki/Naudotojas:Vpovilaitis)
------------------------------------------------------------------------------- From: SQL <sxwiki@gmail.com> Date: Mon, 26 May 2008 19:31:42 ------------------------------------------------------------------------------- Query run, results at http://tools.wikimedia.de/~sql/ltwik.txt
------------------------------------------------------------------------------- From: SQL <sxwiki@gmail.com> Date: Wed, 13 Aug 2008 17:09:33 ------------------------------------------------------------------------------- I've crontabbed this query to run every seven days (sorry about that!). Output will appear at http://toolserver.org/~sql/DBQ/22.txt.gz every seven days
------------------------------------------------------------------------------- From: Vpovilaitis <Vpovilaitis@gmail.com> Date: Mon, 08 Sep 2008 13:39:21 ------------------------------------------------------------------------------- Output http://toolserver.org/~sql/DBQ/22.txt.gz are generating from Lithuanian wikipedia. Please made that output will by generating from the Lithuanian wiktionary.
------------------------------------------------------------------------------- From: SQL <sxwiki@gmail.com> Date: Tue, 09 Sep 2008 14:20:26 ------------------------------------------------------------------------------- Whoops! Sorry! ![][1] Fixed both of them. SQL [1]: https://jira.toolserver.org/images/icons/emoticons/sad.gif
------------------------------------------------------------------------------- From: Vpovilaitis <Vpovilaitis@gmail.com> Date: Fri, 26 Sep 2008 14:35:00 ------------------------------------------------------------------------------- But query dont run every seven days
------------------------------------------------------------------------------- From: Legoktm <legoktm@pacbell.net> Date: Sat, 17 Jan 2009 01:48:51 ------------------------------------------------------------------------------- I have the query running weekly and results being posted at http://toolserver.org/~legoktm/DBQ/22.txt. Legoktm
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: legoktm.wikipedia@gmail.com CC list: legoktm.wikipedia@gmail.com, sxwiki@gmail.com, Vpovilaitis@gmail.com