Die druckbare Version wird nicht mehr unterstützt und kann Darstellungsfehler aufweisen. Bitte aktualisiere deine Browser-Lesezeichen und verwende stattdessen die Standard-Druckfunktion des Browsers.
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
|