Last modified: 2014-01-03 15:34:11 UTC
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)
------------------------------------------------------------------------------- From: SQL <sxwiki@gmail.com> Date: Wed, 13 Aug 2008 17:11:13 ------------------------------------------------------------------------------- sql@nightshade:~/sqlq$ sql ltwiki_p < ltwiki2.sql ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''',_utf8' '),']], ([[', case t.tl_namespace when 0 then '' else concat('ns:',t.t' at line 4 I'm not quite sure how to fix it.
------------------------------------------------------------------------------- From: SQL <sxwiki@gmail.com> Date: Wed, 13 Aug 2008 18:37:06 ------------------------------------------------------------------------------- Alright, will appear at http://toolserver.org/~sql/DBQ/25.txt.gz every seven days.
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: (none) CC list: sxwiki@gmail.com, Vpovilaitis@gmail.com