Query Fix: remove dependency on depreciated revision table

[EmmanuelEmp]

What this PR Does

• This PR addresses issue #5995 by shifting the focus of student statistics from articles edited to articles created, aligning with the new impact factor.

Notable Changes

• The key metric has changed from articles_edited to articles_created.
• Refactored logic: Replaced the individual_mainspace_edits query (which used the revisions table) with a new approach that uses the articles_courses table.

Expected Data Output

Before

(Prior Data Fields):

• course_string_prefix
• individual_article_count
• individual_article_views
• individual_articles_created
• individual_courses_count
• individual_references_count
• individual_upload_count
• individual_upload_usage_count
• individual_word_count

After

(Updated Data Fields):

• course_string_prefix
• individual_article_views ![Views on user articles]
• individual_articles_created
• individual_courses_count
• individual_upload_count
• individual_word_count ![Words added by the user via article created]

Note: The individual_references_count field has been removed from the data output with the new stats depending on the users articles.

[ragesoss]

Please include before/after screenshots to demonstrate the UI changes associated with this PR.

[EmmanuelEmp]

@ragesoss , Okay I'd update this PR with the UI changes

[EmmanuelEmp]

Hello @ragesoss, I'd like you to please revisit this PR as I've included the before/after screenshots demonstrating the UI changes.

[ragesoss]

Please test your changes locally before pushing them.

[EmmanuelEmp]

Some test scripts associated with the user profile pages are resulting in check failures.

I would look into the tests also.

[EmmanuelEmp]

@ragesoss, I've tested locally, identified bugs, and fixed them. However, a test appears to fail since the function relies on data from the revision table. Kindly review.

the failing test:

Image of the dashboard now(statistics):

[ragesoss]

In that case, you'll need to adjust the test appropriately.

[EmmanuelEmp]

Okay, I'd do that.