[Bug 59411] DBQ-149 Number if transclusions of templates in [[Commons:Category:Institution template stubs]]

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59411

Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---

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: h...@online.de
CC list: h...@online.de, jaroslaw.w.tuszyn...@leidos.com

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


[Bug 59411] DBQ-149 Number if transclusions of templates in [[Commons:Category:Institution template stubs]]

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59411

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: Hoo man h...@online.de
Date: Wed, 17 Aug 2011 16:18:46
---

SQL:

SELECT templatelinks.tl_title as title, COUNT(*) as transclusion_count FROM
categorylinks INNER JOIN page ON categorylinks.cl_from = page.page_id INNER
JOIN templatelinks ON templatelinks.tl_title = page.page_title AND
page.page_namespace = templatelinks.tl_namespace WHERE cl_to =
'Institution_template_stubs' GROUP BY templatelinks.tl_title;

Result:  
http://toolserver.org/~hoo/dbq/dbq-149.txt (plain text)

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


[Bug 59411] DBQ-149 Number if transclusions of templates in [[Commons:Category:Institution template stubs]]

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59411

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: Jarek Tuszynski jaroslaw.w.tuszyn...@saic.com
Date: Mon, 29 Aug 2011 17:31:31
---

Thanks

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