Untitled query #82032

SQL

SELECT
    user_name,
    DATE_FORMAT(CONVERT_TZ(user_registration, '+00:00', '+05:30'), '%Y-%m-%d') AS Registration_date,
    DATE_FORMAT(CONVERT_TZ(MIN(rev_timestamp), '+00:00', '+05:30'), '%Y-%m-%d') AS First_edit_date,
    DATE_FORMAT(CONVERT_TZ(MAX(rev_timestamp), '+00:00', '+05:30'), '%Y-%m-%d') AS Last_edit_date,
    COUNT(DISTINCT rev_id) AS Total_edits
FROM
    revision
JOIN page ON page_id = rev_page
JOIN actor ON actor_id = rev_actor
JOIN user ON user_id = actor_user
JOIN user_properties ON up_user = user_id
GROUP BY
    user_name, user_registration
HAVING
    Total_edits > 50
ORDER BY
    Total_edits DESC;
SQL

Checking query status...
