https://bugzilla.wikimedia.org/show_bug.cgi?id=59281
Web browser: ---
Bug ID: 59281
Summary: DBQ-25 More requested templates 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-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 <vpovilai...@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)
--
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
