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