Query failed:

SELECT offset
FROM
(SELECT hpdate, @num := @num + 1 AS offset FROM hp_votedate WHERE lng='hu' ORDER BY hpdate) x
WHERE hpdate='2017-03-18'


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