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 2: | Zeile 2: | ||
===Am häufigsten wiederverwendete Illustration=== | ===Am häufigsten wiederverwendete Illustration=== | ||
<pre>SELECT id_illustration, COUNT(DISTINCT id_source) | <pre>SELECT ils.id_illustration, c.forename_first, c.surname, COUNT(DISTINCT id_source) | ||
FROM illustration_source | FROM illustration_source AS ils | ||
GROUP BY id_illustration | 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</pre> | ORDER BY COUNT(DISTINCT id_source) DESC</pre> | ||
{| class="infotable" | {| class="infotable" | ||
!<tt>id_illustration</tt> | !<tt>id_illustration</tt> | ||
!Illustrator | |||
!Häufigkeit | !Häufigkeit | ||
|- | |- | ||
|731645 | |731645 | ||
|Andreas Schroth | |||
|8 | |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 | ||
|} | |} | ||
Version vom 28. April 2016, 12:26 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 |
|---|---|---|
| 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 |