https://bugzilla.wikimedia.org/show_bug.cgi?id=59395

       Web browser: ---
            Bug ID: 59395
           Summary: DBQ-138 Need to find list of articles which contains
                    <!--  WikiBhasha   v=X time=YYYY-MM-DD hh:ii:ss:mmm-->
           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-138.
Summary: Need to find list of articles which contains <!--  WikiBhasha   v=X
time=YYYY-MM-DD hh:ii:ss:mmm-->   
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Hoo man <h...@online.de>

-------------------------------------------------------------------------------
From: WikiBhasha MSR <wbm...@microsoft.com>
Date: Tue, 03 May 2011 07:42:34
-------------------------------------------------------------------------------

Hi,

I need to find list of revisions which contains <!-- WikiBhasha v=X
time=YYYY-MM-DD hh:ii:ss:mmm-->   
I have toolserver access but on querying the following sql 

Select old_text from revision r inner join text t on r.rev_text_id = t.old_id
where t.old_text like "%WikiBhasha%" limit 2;

I am getting the old_text as   
DB://cluster22/144813013  
DB://cluster22/123998601 

In the above pattern/string ( ex. DB://cluster22/144813013) what is 'cluster22'
and '144813013'?  
I figured out that the above pattern indicates an external db server. How can i
access this external db server?  
How to query the content?

regards  
anilande

-- 
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

Reply via email to