SELECT * FROM soft WHERE s_id >= ((SELECT MAX(s_id) FROM soft)-(SELECT MIN(s_id) FROM soft)) * RAND() + (SELECT MIN(s_id) FROM soft) LIMIT 9;