pub const EPISODE_WORKFLOW_SELECT: &str = r#"
me.*,
med."translatorSetupTime", med."translatorUpdateTime",
med."proofreaderSetupTime", med."proofreaderUpdateTime",
med."lettererSetupTime", med."lettererUpdateTime",
med."timerSetupTime", med."timerUpdateTime",
med."reviewerSetupTime", med."reviewerUpdateTime",
provider.username AS providerName,
translator.username AS translatorName,
proofreader.username AS proofreaderName,
letterer.username AS lettererName,
timer.username AS timerName,
reviewer.username AS reviewerName,
providerFile.filename AS providerFilename,
translatorFile.filename AS translatorFilename,
proofreaderFile.filename AS proofreaderFilename,
lettererFile.filename AS lettererFilename,
timerFile.filename AS timerFilename,
(SELECT COUNT(1)::BIGINT FROM editor_page epg WHERE epg.episode_id = me."Id") AS "editorPageCount"
"#;Expand description
话数 workflow SELECT 列