[Lando]

Jag får det inte riktigt att funka:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '50 res_id FROM test_result ORDER BY res_date) ORDER BY res_result

Så här ser SQLn ut:
SELECT * FROM test_result WHERE res_id IN (SELECT TOP 50 res_id FROM test_result ORDER BY res_date) ORDER BY res_result

Hjälp?