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