help with multiple order by conditions...with rand()

[dinox]

hello, i tried searching for something similar to my situation but i haven't found so far..

for example ...
i have users table with 15 registered users and i want to show only 5 of them in front page...the table has (id) as unique value...
and i want to make an sql query that shows the 5 users registered lately...

...how?
by picking (random 5 ) users from the ( last 10 inserted users in table...) !!
this means the older ones won't show up...


so how i do this??

i thought of:

SELECT  * FROM  table WHERE id IN ( SELECT id FROM table ORDER BY id DESC LIMIT 10 )  ORDER BY  RAND() LIMIT 5 ;

but it gives errors...
any ideas?


(
note:
i do not want to use dates to collect the last 10 or something closer (since there might be days none registered)...

also i do not want to use MAX() to find last added id value then subtract 10...to find the last 10...
)

[mwasif]

What about this one?

SELECT  * FROM  (
    SELECT * FROM table ORDER BY id DESC LIMIT 10 
    )  temp 
ORDER BY  RAND() LIMIT 5 ;

[dinox]

What about this one?

SELECT  * FROM  (
    SELECT * FROM table ORDER BY id DESC LIMIT 10 
    )  temp 
ORDER BY  RAND() LIMIT 5 ;

hey this is worked perfectly!!
thanks alot dude!! you are a great help!

i tried something exactly similar to this long ago but i got errors (i guess my bad) so i thought this is not the right way to begin with.... but in fact it is !

[mwasif]

You are welcome, glad to help you.