Shadowhelix:Datenbank/Statistiken: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Loki (Diskussion | Beiträge) Keine Bearbeitungszusammenfassung |
Loki (Diskussion | Beiträge) Keine Bearbeitungszusammenfassung |
||
| Zeile 14: | Zeile 14: | ||
!Häufigkeit | !Häufigkeit | ||
|- | |- | ||
| | |o09485102 | ||
|Andreas Schroth | |Andreas Schroth | ||
|8 | |8 | ||
|- | |- | ||
| | |o56362750 | ||
|Andreas Schroth | |Andreas Schroth | ||
|6 | |6 | ||
|- | |- | ||
| | |o70844220 | ||
|Andreas Schroth | |Andreas Schroth | ||
|6 | |6 | ||
|- | |- | ||
| | |o95627699 | ||
|Andreas Schroth | |Andreas Schroth | ||
|6 | |6 | ||
|- | |- | ||
| | |o82992504 | ||
|Andreas Schroth | |Andreas Schroth | ||
|5 | |5 | ||
|- | |- | ||
| | |o62838181 | ||
|Jeff Miracola | |Jeff Miracola | ||
|4 | |4 | ||
|- | |- | ||
| | |o65396586 | ||
|Florian Stitz | |||
|4 | |||
|- | |||
|o69760111 | |||
|Andreas Schroth | |Andreas Schroth | ||
|4 | |4 | ||
|} | |} | ||
Version vom 21. Juli 2016, 11:03 Uhr
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 |
|---|---|---|
| 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 |