Shadowhelix:Datenbank/Statistiken

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