Ontological Web Organizer (O.W.O.) - Go Back

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;