This issue was converted from https://jira.toolserver.org/browse/DBQ-25.
Summary: More requested templates of Lithuanian wiktionary
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: (none)
From: Vpovilaitis <Vpovilaitis@gmail.com>
Date: Tue, 03 Jun 2008 10:39:53
Would it be possible to periodicaly (7 d) get a list of more requested templates of Lithuanian wiktionary.
For this job was used SQL select:
Select curdate() as `` from dual
union
SELECT distinct concat(_utf8'* [[',case pp.page_namespace when 0 then '' else concat('{{ns:',pp.page_namespace,'}}:') end,
replace(pp.page_title,_utf8'_',_utf8' '),']], ([[',
case t.tl_namespace when 0 then '' else concat('{{ns:',t.tl_namespace,'}}:') end,
t.tl_title,'|',t.tl_title,']], ',pp.page_namespace,')') AS ``
FROM templatelinks t, page pp
where not exists (SELECT 1 FROM page p
where p.page_title = t.tl_title
and p.page_namespace = 10)
and t.tl_namespace = 10
and t.tl_from = pp.page_id;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