SQLITE3> -- Select everything from a pg and include the author
SELECT
ReadyCharacters.Palette AS "c",
ReadyCharacters.ID AS "id",
ReadyCharacters.NomePersonaggio AS "pgname",
ReadyCharacters.NomeCompleto AS "cpgname",
ReadyCharacters.Razza AS "race",
ReadyCharacters.Sesso AS "sex",
ReadyCharacters.Eta AS "age",
ReadyCharacters.Professione AS "prof",
ReadyCharacters.Autore AS "author",
ReadyCharacters.Linguaggio AS "lan",
ReadyCharacters.Pronomi AS "pro",
ReadyCharacters.Allineamento AS "ali",
ReadyCharacters.Peso AS "w",
ReadyCharacters.Taglia AS "s",
ReadyCharacters.Altezza AS "h",
ReadyCharacters.Divinità AS "div",
ReadyCharacters.PDF AS "pdf",
ReadyCharacters.Stato AS "status",
ReadyCharacters.PuntiVita AS "hp"
FROM ReadyCharacters
WHERE ReadyCharacters.NomePersonaggio LIKE '%' || :pg || '%'
GROUP BY ReadyCharacters.ID
LIMIT :offset, :entries;