Web browser: ---
            Bug ID: 59281
           Summary: DBQ-25 More requested templates of Lithuanian
           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 templates of Lithuanian wiktionary
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: (none)

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

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

Reply via email to