PDO statement query to randomize last 10 rows

[goma smile]

Es zinu ka to var uztaisīt caur php bet vai caur vaicājumu nevar.......? izmantoju PDO::statement...

 

Ideja ļoti vienkārša izvelk pēdējos 10  ORDER BY id DESC LIMIT 10....

bet man vaig lai tieši šiem pēdējiem 10 ir uzlikts Random

[PheliX]

SELECT * FROM ( ... ORDER BY id DESC LIMIT 10) AS last10 ORDER BY RAND()

[marcis]

PHP shuffle izpildīsies ātrāk un bez mindfuck kverijā. Iesaku atstāt kā ir - darīt to PHP pusē.

[goma smile]

SELECT * FROM (items ORDER BY item_id DESC LIMIT 10) ORDER BY RAND() 

 

izmet erroru 

 

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 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 'ORDER BY RAND()' at line 1' in C:\AppServ\www\index.php:27 Stack trace: #0 C:\AppServ\www\index.php(27): PDOStatement->execute() #1 {main} thrown in

[waplet]

Un jēga, ja tu sākumā order'o pēc item id un tad šafflo?

 

SELECT * from items ORDER by RAND() LIMIT 10