SQLITE3> -- Lista tutti i Personaggi e tutte le campagne in cui sono stati e in quante sessioni di esse
SELECT
Personaggio.Name AS "pg",
Image.File AS "file",
Image.Credit AS "crd" ,
Personaggio.CompleteName AS "cpg",
Personaggio.Color AS "colors",
Campaign.Title AS "campagna",
count(Personaggio.Personaggio_ID) AS "sessioni",
Campaign.Page as "page" FROM CharacterInSession
INNER JOIN Session ON Session.Session_ID = CharacterInSession.Session_ID
INNER JOIN Personaggio ON Personaggio.Personaggio_ID = CharacterInSession.Personaggio_ID
INNER JOIN Campaign ON Campaign.Campaign_ID = Session.Campaign_ID
INNER JOIN CharacterImage ON CharacterImage.Character_FK = Personaggio.Personaggio_ID
INNER JOIN Image ON CharacterImage.Image_FK = Image.Image_ID
WHERE Image.Kind = 1
GROUP BY Campaign.Campaign_ID, Personaggio.Personaggio_ID
ORDER BY Campaign.Campaign_ID
LIMIT :offset, :entries;