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
    Classification: Unclassified
   Mobile Platform: ---

This issue was converted from
Summary: More requested pages of Lithuanian wiktionary
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Legoktm <>

From: Vpovilaitis <>
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:

This job I made befoe manualy from download files. Result of my manual work is
in file:

For this job was used SQL select:

* * *

Select curdate() as `` from dual  
(select concat(_utf8'* [[',replace(`a`.`pl_title`,_utf8'_',_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` =
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,  

You are receiving this mail because:
You are on the CC list for the bug.
Wikibugs-l mailing list

Reply via email to