Shadowhelix:Datenbank/Statistiken: Unterschied zwischen den Versionen

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
(Die Seite wurde neu angelegt: „==Illustrationen== ===Am häufigsten wiederverwendete Illustration=== <pre>SELECT id_illustration, COUNT(id_illustration) FROM illustration_source GROUP BY id…“)
 
Keine Bearbeitungszusammenfassung
 
(7 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
==Illustrationen==
==Illustrationen==
===Anzahl unterschiedlicher Illustrationen für Shadowrun===
<pre>SELECT COUNT (DISTINCT id_illustration) FROM illustration_source</pre>
7792
===Künstler mit den meisten Illustrationen===
<pre>SELECT c.forename_first, c.surname, COUNT(DISTINCT cil.id_illustration)
FROM contribution_illustration AS cil, contributor AS c
WHERE cil.id_contributor = c.id_contributor
GROUP BY cil.id_contributor
ORDER BY COUNT(DISTINCT cil.id_illustration) DESC</pre>
{| class="infotable"
!Illustrator
!Anzahl
|-
|Jeff Laubenstein
|126
|-
|Echo Chernik
|124
|-
|Chad Sergesketter
|118
|-
|Víctor Manuel Leza
|86
|-
|Andreas Schroth
|81
|-
|Florian Stitz
|75
|-
|James Nelson
|61
|-
|Ian King
|61
|}


===Am häufigsten wiederverwendete Illustration===
===Am häufigsten wiederverwendete Illustration===
<pre>SELECT id_illustration, COUNT(id_illustration)
<pre>SELECT ils.id_illustration, c.forename_first, c.surname, COUNT(DISTINCT id_source)
FROM illustration_source
FROM illustration_source AS ils
GROUP BY id_illustration
  LEFT JOIN contribution_illustration AS cil ON ils.id_illustration = cil.id_illustration
ORDER BY COUNT(id_source) DESC</pre>
  LEFT JOIN contributor AS c ON cil.id_contributor = c.id_contributor
GROUP BY ils.id_illustration
ORDER BY COUNT(DISTINCT id_source) DESC</pre>


{| class="infotable"
{| class="infotable"
!<tt>id_illustration</tt>
!<tt>id_illustration</tt>
!Illustrator
!Häufigkeit
!Häufigkeit
|-
|-
|47269
|o09485102
|5
|Andreas Schroth
|8
|-
|-
|493861
|o56362750
|5
|Andreas Schroth
|6
|-
|-
|76541
|o70844220
|4
|Andreas Schroth
|6
|-
|-
|158690
|o95627699
|4
|Andreas Schroth
|6
|-
|-
|256083
|o82992504
|4
|Andreas Schroth
|5
|-
|-
|257139
|o62838181
|Jeff Miracola
|4
|4
|-
|-
|526407
|o65396586
|Florian Stitz
|4
|4
|-
|-
|584721
|o69760111
|Andreas Schroth
|4
|4
|}
|}

Aktuelle Version vom 5. August 2016, 15:07 Uhr

Illustrationen

Anzahl unterschiedlicher Illustrationen für Shadowrun

SELECT COUNT (DISTINCT id_illustration) FROM illustration_source

7792

Künstler mit den meisten Illustrationen

SELECT c.forename_first, c.surname, COUNT(DISTINCT cil.id_illustration)
FROM contribution_illustration AS cil, contributor AS c
WHERE cil.id_contributor = c.id_contributor
GROUP BY cil.id_contributor
ORDER BY COUNT(DISTINCT cil.id_illustration) DESC
Illustrator Anzahl
Jeff Laubenstein 126
Echo Chernik 124
Chad Sergesketter 118
Víctor Manuel Leza 86
Andreas Schroth 81
Florian Stitz 75
James Nelson 61
Ian King 61

Am häufigsten wiederverwendete Illustration

SELECT ils.id_illustration, c.forename_first, c.surname, COUNT(DISTINCT id_source)
FROM illustration_source AS ils
  LEFT JOIN contribution_illustration AS cil ON ils.id_illustration = cil.id_illustration
  LEFT JOIN contributor AS c ON cil.id_contributor = c.id_contributor
GROUP BY ils.id_illustration
ORDER BY COUNT(DISTINCT id_source) DESC
id_illustration Illustrator Häufigkeit
o09485102 Andreas Schroth 8
o56362750 Andreas Schroth 6
o70844220 Andreas Schroth 6
o95627699 Andreas Schroth 6
o82992504 Andreas Schroth 5
o62838181 Jeff Miracola 4
o65396586 Florian Stitz 4
o69760111 Andreas Schroth 4
Abgerufen von „https://shadowhelix.de/index.php?title=Shadowhelix:Datenbank/Statistiken&oldid=222214“