Shadowhelix:Datenbank/Statistiken

Illustrationen

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
731645	Andreas Schroth	8
16874	Andreas Schroth	6
491038	Andreas Schroth	6
631425	Andreas Schroth	6
528346	Andreas Schroth	5
256083	Jeff Miracola	4
509321	Andreas Schroth	4