Query Run
SELECT @rownum := @rownum + 1 AS rank, username, gallery FROM ... 5 years ago
SELECT @rownum := @rownum + 1 AS rank, username, gallery FROM ... 5 years ago