Query failed:
SELECT offset
FROM
(SELECT hpdate, @num := @num + 1 AS offset FROM hp_votedate WHERE lng='hu' ORDER BY hpdate) x
WHERE hpdate='2023-08-31'
Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset
FROM
(SELECT hpdate, @num := @num + 1 AS offset FROM hp_votedate...' at line 1