LLM Session Dashboard Lade OpenRouter API...

SELECT 
    s.id AS session_id,
    s.title,
    s.time_created AS created,
    s.time_updated AS last_access,
    s.directory as directory,
    s.model,
    (s.tokens_input + s.tokens_cache_write) AS frontend_input_tokens,
    (s.tokens_output + s.tokens_reasoning) AS frontend_output_tokens,
    s.tokens_cache_read AS frontend_cached_tokens,
    (
        SELECT COUNT(*) 
        FROM message m 
        WHERE m.session_id = s.id 
        AND json_extract(m.data, '$.role') = 'user'
    ) AS user_message_count
FROM session s
WHERE s.tokens_input > 0 OR s.tokens_output > 0
ORDER BY created DESC;