SELECT * FROM `pred` WHERE on_off=1 order by rand() DESC LIMIT 100