Tako nešto, beats me
PHP kôd:
SELECT
@rownum := @rownum + 1 AS rownum, questions.*, id AS i
FROM (SELECT @rownum := 0) AS rownum, questions
WHERE difficulty > 0
HAVING i = 23
ORDER BY id ASC
Ovo ga opet spljošti, u slučaju da ti treba pk za rownum, onda radi bez problema.