Last modified: 2014-01-03 15:57:11 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-114. Summary: How many pages contains "Infobox Indian Jurisdiction" Issue type: Task - A task that needs to be done. Priority: Trivial Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: Mahir <mahir78@gmail.com> Date: Tue, 28 Dec 2010 16:08:03 ------------------------------------------------------------------------------- Hi We need to replace this `Infobox Indian Jurisdiction` template in ta.wikipedia with another. Can you please find & let me know how many pages have this template included? Thanks Mahir
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Tue, 28 Dec 2010 17:34:12 ------------------------------------------------------------------------------- There is no query no special query required, you can just us the web tool: http://toolserver.org/~jarry/templatecount/ http://toolserver.org/~jarry/templatecount/index.php?lang=ta&name=Infobox+Indian+Jurisdiction (filled with the data above) Please reopen this if you need more information ![][1] [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif
------------------------------------------------------------------------------- From: Mahir <mahir78@gmail.com> Date: Tue, 28 Dec 2010 18:08:06 ------------------------------------------------------------------------------- Quick help. Thanks. It works. I'm now interested in finding this template "இந்திய அதிகார அமைப்புகள் தகவல்பெட்டி" in site ta. But this is not working. I made a comment in jarry talk page. Thanks Mahir
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Tue, 28 Dec 2010 22:54:43 ------------------------------------------------------------------------------- MySQL (or may putty) seems to have problems with tamil titles, I had to lookup the page id per hand (on http://ta.wikipedia.org/w/index.php?title=%E0%AE%B5%E0%AE%BE%E0%AE%B0%E0%AF%8D%E0%AE%AA%E0%AF%8D%E0%AE%AA%E0%AF%81%E0%AE%B0%E0%AF%81:%E0%AE%87%E0%AE%A8%E0%AF%8D%E0%AE%A4%E0%AE%BF%E0%AE%AF_%E0%AE%85%E0%AE%A4%E0%AE%BF%E0%AE%95%E0%AE%BE%E0%AE%B0_%E0%AE%85%E0%AE%AE%E0%AF%88%E0%AE%AA%E0%AF%8D%E0%AE%AA%E0%AF%81%E0%AE%95%E0%AE%B3%E0%AF%8D_%E0%AE%A4%E0%AE%95%E0%AE%B5%E0%AE%B2%E0%AF%8D%E0%AE%AA%E0%AF%86%E0%AE%9F%E0%AF%8D%E0%AE%9F%E0%AE%BF&redirect=no) and then I was able to build a query: mysql> SELECT COUNT(*) FROM templatelinks INNER JOIN page ON page_title = tl_title WHERE page_id = '61227'; +----------+ | COUNT(*) | +----------+ | 49 | +----------+ 1 row in set (2.23 sec)
------------------------------------------------------------------------------- From: Mahir <mahir78@gmail.com> Date: Thu, 30 Dec 2010 18:25:16 ------------------------------------------------------------------------------- Thanks Hoo man, Jarry now fixed this issue i can query directly there itself.
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: hoo@online.de CC list: hoo@online.de, mahir78@gmail.com