Shadowhelix:Datenbank/Statistiken

Illustrationen

Anzahl von unterschiedlicher Illustrationen für Shadowrun

SELECT COUNT (DISTINCT id_illustration) FROM illustration_source

7677

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