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