Silli: Server schaft es nicht mehr

Beitrag lesen

HI,

Die Abfrage scheint meine mysql Version nicht zu unterstützen
Woran liegt es ?

SQL-Befehl:

SELECT *
FROM ok_tabelle AS t1
INNER JOIN (

SELECT ROUND( RAND( ) * (
SELECT MAX( ID )
FROM ok_tabelle ) ) AS ID
) AS t2 ON t1.ID >= t2.ID
ORDER BY t1.ID ASC
LIMIT 1
MySQL meldet:

#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 'SELECT
    ROUND(RAND() * (SELECT MAX(ID) FROM ok_tabelle)) AS

Grüße Silli