https://bugzilla.wikimedia.org/show_bug.cgi?id=59278

       Web browser: ---
            Bug ID: 59278
           Summary: DBQ-22 More requested pages of Lithuanian wiktionary
           Product: Tool Labs tools
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: Unprioritized
         Component: Database Queries
          Assignee: wmf.bugconver...@gmail.com
          Reporter: wmf.bugconver...@gmail.com
    Classification: Unclassified
   Mobile Platform: ---

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 <lego...@pacbell.net>

-------------------------------------------------------------------------------
From: Vpovilaitis <vpovilai...@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)

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to