DROP VIEW IF EXISTS editor_total_article_view;
CREATE VIEW editor_total_article_view(
    editorTotalArticleScoring,
    user_id
) as
SELECT
    count(*) as editorTotalArticleScoring,
    scoring.user_id as user_id
FROM
    scoring
WHERE
    scoring.participant_type = 2 AND scoring.scoring_type = 1 AND scoring.scoring > 0
GROUP BY
    scoring.user_id;