imported>mutante mNo edit summary |
imported>mutante mNo edit summary |
||
| Line 4: | Line 4: | ||
<tt> |
<tt> |
||
(select 'wikipedias' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikipedias) |
(select 'wikipedias' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikipedias) |
||
union all |
union all |
||
(select 'wiktionaries' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wiktionaries) |
(select 'wiktionaries' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wiktionaries) |
||
union all |
union all |
||
(select 'wikiquotes' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikiquotes) |
(select 'wikiquotes' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikiquotes) |
||
union all |
union all |
||
(select 'wikibooks' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikibooks) |
(select 'wikibooks' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikibooks) |
||
union all |
union all |
||
(select 'wikinews' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikinews) |
(select 'wikinews' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikinews) |
||
union all |
union all |
||
(select 'wikisources' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikisources) |
(select 'wikisources' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikisources) |
||
union all |
union all |
||
(select 'wikia' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikia) |
(select 'wikia' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikia) |
||
union all |
union all |
||
(select 'editthis' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from editthis) |
(select 'editthis' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from editthis) |
||
union all |
union all |
||
(select 'wikitravel' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikitravel) |
(select 'wikitravel' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikitravel) |
||
union all |
union all |
||
(select 'mediawikis' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from mediawikis) |
(select 'mediawikis' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from mediawikis) |
||
union all |
union all |
||
(select 'uncyclomedia' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, |
(select 'uncyclomedia' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, |
||
sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from uncyclomedia) |
|||
union all |
union all |
||
(select 'anarchopedias' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from anarchopedias) |
(select 'anarchopedias' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from anarchopedias) |
||
order by ggood desc,gtotal desc; |
order by ggood desc,gtotal desc; |
||
</tt> |
</tt> |
||
Revision as of 21:08, 15 August 2006
The following is a single MySQL query. Its being used to get the numbers for the coalesced grand-totals of Wikistats.
(select 'wikipedias' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikipedias)
union all
(select 'wiktionaries' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wiktionaries)
union all
(select 'wikiquotes' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikiquotes)
union all
(select 'wikibooks' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikibooks)
union all
(select 'wikinews' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikinews)
union all
(select 'wikisources' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikisources)
union all
(select 'wikia' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikia)
union all
(select 'editthis' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from editthis)
union all
(select 'wikitravel' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from wikitravel)
union all
(select 'mediawikis' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from mediawikis)
union all
(select 'uncyclomedia' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from uncyclomedia)
union all
(select 'anarchopedias' as name,sum(good) as ggood, sum(total) as gtotal, sum(edits) as gedits, sum(admins) as gadmins, sum(users) as gusers,sum(images) as gimages from anarchopedias)
order by ggood desc,gtotal desc;