Shadowhelix:Datenbank/Statistiken

Aus Shadowhelix
Wechseln zu: Navigation, Suche

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