SELECT
@rownum :=@rownum + 1 AS rownum,
a.*
FROM
(SELECT @rownum := 0) r,
compare_wall_activity_works a
ORDER BY
vote_number DESC
SELECT
@rownum :=@rownum + 1 AS rownum,
a.*
FROM
(SELECT @rownum := 0) r,
compare_wall_activity_works a
ORDER BY
vote_number DESC