Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT quote
- FROM (
- SELECT quote
- , DATEDIFF('DAY', last_selected, CURDATE()) * RAND() AS randWeighted
- FROM quotesTest
- WHERE DATEDIFF('DAY', last_selected, CURDATE()) > 7
- )
- ORDER BY randWeighted DESC
- LIMIT 1
- ;
Advertisement
Add Comment
Please, Sign In to add comment