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)

Version: unspecified
Severity: major